Options For Sending Mail With Reply To 1

[OrWolf]

I'm looking for a way to send a mail from a SQL Stored Procedure that allows me to specify a reply to value. I'm using SQL 2000 but will be moving to SQL 2005 within three months. Suggestions?

Thank you

 

[nickdel]

OrWolf, if you use the CDO object to send mail then you should be able to use 'AddHeaderField' to add a 'Reply-To' header to the mail.

Have never done this and unable to test at present but it makes sense (in my mind anyway!)

Nick

where would we be without rhetorical questions...

 

[mrdenny]

I beleive that xp_smtp_sendmail allows you to set this field. Google for it, it should be the first or second thing found.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[OrWolf]

Thanks Denny. That worked excellent with very little trouble.