sql stored procedure conextually problem with assigning value to a variable within a loop

DECLARE @tmp_subject varchar(1000)

WHILE @@FETCH_STATUS = 0
   BEGIN
    SET @tmp_subject = 'Your '+@monthlyaccountdescription+' Program at the Wash'

    --Sending Mail
    EXEC msdb.dbo.sp_send_dbmail @recipients = @recipientemail,
          @subject = @tmp_subject
,           @body = '<p>Dear Neil,</p>
				   <p>Your credit card ending with an expiration date of DDYY has been charged in the amount of $49.95 for the Program.</p>
				   <p>Thank you for your business.</p>',
          @body_format = 'HTML';
             
      FETCH NEXT FROM Mail_Cursor
      INTO @recipients, @subject, @body;
   END;

Select allOpen in new window