Sure
SET @MailMsg = '78 load ran correctly'
-- Actually this is built dynamically in a
--case satement, and is only one of the
--possible results for the mail message
EXEC master.dbo.xp_sendmail
@recipients = 'TomN.@myco.com; TomS@myco.com',
@message = @MailMsg ,
@copy_recipients = 'JWT@myco.com'
@subject = 'Daily 78 Load'
Edited by - jwt on 07/16/2003 1:44:38 PM