July 21st, 2004, 09:28 AM
|
|
Contributing User
|
|
Join Date: Jul 2004
Posts: 95
Time spent in forums: 9 h 8 m 12 sec
Reputation Power: 0
|
|
|
CDO_SendMail
I have the following sp where I am executing a cdo_mail.
I would like to put in a messagebody some results from exec sp. However it is not working. What am I doing incorrect?
declare @MessageBody varchar(2000)
set @MessageBody=exec sp
EXECUTE CDO_SendMail @From = 'from@com',
@To ='to@com',
@Cc = '',
@Bcc = '',
@Subject = 'Subject' ,
@MessageFormat = 0,
@Message = @MessageBody
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
