dweil
SSCrazy
Points: 2408
More actions
May 10, 2006 at 12:56 pm
#112075
Using xp_sendmail, is it possible to put a query into the subject line.
I know how to put a query into the text of the email but we have a case where a query in the subject would identify how high a priority the email actually is.
Thanks
David Weil
homebrew01
SSC Guru
Points: 55548
May 10, 2006 at 1:16 pm
#637096
Do you want the results of the query in the subject line ?
May 10, 2006 at 1:18 pm
#637097
Yes
thanks
David A. Long
SSCrazy Eights
Points: 8421
May 10, 2006 at 11:38 pm
#637154
DECLARE @Subject varchar(4000)
SELECT @Subject = MyField FROM MyTable
EXEC xp_sendmail 'me@mydomain.com', @Subject
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply