SQL Server - Sp_send_dbmail and bcc

To send BCC and Copy in SQL Sp_send_dbmail,  use this way to send email from a configured Database Mail server.

EXEC msdb.dbo.sp_send_dbmail
@recipients=N'[email protected]',
@copy_recipients ='[email protected]’
@blind_copy_recipients ='[email protected]’
@body= 'Some text for body', 
@subject = 'Some text for subject',
@profile_name = 'MyProfile1';

The email addresses in @recipients go on the To:  line.

To  use   COPY and BCC on sp_send_dbmail , the parameters are :

@copy_recipients ='[email protected]’
@blind_copy_recipients = '[email protected]'

Related Posts

Set up Database Mail on SQL Server 2005