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'JackVamvas@sqlserver-dba.com',
@copy_recipients ='JackVamvas@sqlserver-dba.com’
@blind_copy_recipients ='tuning@sqlserver-dba.com’
@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 ='JackVamvas@sqlserver-dba.com’
@blind_copy_recipients = 'tuning@sqlserver-dba.com'

Related Posts

Set up Database Mail on SQL Server 2005