locked
MultipleReceipents RRS feed

  • Question

  • User1979860870 posted

    Hi

    select @Recipient = Email from test where SName = @SName 

    I want to save multiple receipents in a variable and then pass to - How variable @Recipient to be passed

    EXEC msdb.dbo.sp_send_dbmail @recipients='abc@gmail.com',
    			@profile_name = 'Testing',
    			@subject = @MailSubject,
    			@body = @tableHTML,
    			@body_format = 'HTML' ;



    Thanks

    Thursday, August 27, 2020 4:59 PM

All replies