DECLARE

@emailTo VARCHAR(255),
@email VARCHAR(max),
@sku VARCHAR(30),
@emailSubject VARCHAR(128),

SET @emailTo = 'myemail@mycompany.co.uk'
SET @emailSubject = 'Warning stock is below safety for : '

-- SELECT RECORDS THAT NEED TO BE EMAILED
  DECLARE c1 CURSOR FOR 
    SELECT  @emailTo as email_add,
			rtrim(StockCode) as StockCode
    FROM	dbo.tbl_STOCK_safety_check 
    WHERE	email_status = 1

-- LOOP THROUGH RECORDSET AND SEND EMAIL FOR EACH RECORD
  OPEN c1
  FETCH NEXT FROM c1 INTO @email, @sku
  WHILE @@FETCH_STATUS <> -1
    BEGIN
    SELECT

      @emailSubject = @emailSubject + @sku

      EXEC msdb.dbo.sp_send_dbmail 
	   @importance = 'High',
       @recipients= @email ,
       @subject = @emailSubject

    FETCH NEXT FROM c1 INTO @email,@sku
    END
  CLOSE c1
  DEALLOCATE c1

 --@emailSubject = @emailSubject + @sku

      EXEC msdb.dbo.sp_send_dbmail 
	   @importance = 'High',
       @recipients= @email ,
       @subject = @emailSubject + @sku

DECLARE @emailTo VARCHAR(255),
	@email VARCHAR(max),
	@sku VARCHAR(30),
	@emailSubject VARCHAR(128),

SET @emailTo = 'myemail@mycompany.co.uk'
SET @emailSubject = 'Warning stock is below safety for : '

-- SELECT RECORDS THAT NEED TO BE EMAILED
DECLARE c1 CURSOR FOR 
	SELECT  rtrim(StockCode) as StockCode
	FROM	dbo.tbl_STOCK_safety_check 
	WHERE	email_status = 1

-- LOOP THROUGH RECORDSET AND SEND EMAIL FOR EACH RECORD
OPEN c1
FETCH NEXT FROM c1 INTO @sku

WHILE @@FETCH_STATUS <> -1
BEGIN
	EXEC msdb.dbo.sp_send_dbmail 
		@importance = 'High',
		@recipients= @email ,
		@subject = @emailSubject + @sku
	FETCH NEXT FROM c1 INTO @email,@sku
END

CLOSE c1
DEALLOCATE c1