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