Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 xp_sendmail from or reply to ?

Author  Topic 

jhilb
Starting Member

22 Posts

Posted - 2002-09-17 : 09:44:01
Is there a way to set the FROM or REPLY TO while using xp_sendmail?

J

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-09-17 : 10:12:04
XP_sendmail was alwayts extremely limited. The best method I found was to include a link inside the message. Just something at the very end saying

to reply to this message click HERE

where HERE is write a little html with a mailto in it.

-----------------------
Take my advice, I dare ya
Go to Top of Page

tammy
Starting Member

3 Posts

Posted - 2002-09-21 : 14:11:01
I also wanted to set the from value.
I ended up writing a stored procedure that uses asp mail.
Now I can send mail from my triggers or jobs by executing that stored procedure.
http://www.sqlteam.com/item.asp?ItemID=5003
Go to Top of Page
   

- Advertisement -