May 24, 2005 at 3:03 pm
Hello All,
I have a question about the xp_smtp_sendmail procedure. I am trying to use it with both the @message and @messagefile parameters. The process works except that the @message variable ends up as a txt attachment on the email instead of embedded into the body. What I'm trying to do is create an email that reports numbers to certain account reps for their own information. To make the email a little more friendly I was trying to add an opening by using @message to explain the purpose of the email and the numbers that follow. The reported numbers would then be pulled into the body of the email from a text file using the @messagefile parameter.
Any ideas on how to accomplish this through xp_smtp_sendmail w/out attachments?
Thanks for any input...
May 25, 2005 at 4:58 am
Not entirely sure, but when reading the change log at http://www.sqldev.net/xp/xpsmtp.htm I get the feeling that @message and @messagefile are mutually exclusive. Haven't done any testing on it, though. If I remember tonight, I'll ask Gert about it.
/Kenneth
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply