using existing sql mail profile.

 

EXEC msdb.dbo.sp_send_dbmail

@profile_name

= 'ReportsMail',

@recipients

= @emailto,

@body

= @body,

@blind_copy_recipients

= 'add addresses here',

@subject

= @subject;