RE: SQL Mail to forward replies to different people depending on subject?

From: Alicia (anonymous_at_discussions.microsoft.com)
Date: 05/19/04


Date: Wed, 19 May 2004 13:16:08 -0700

Sql mail isn't particularly robust - and as I find, not that reliable. To do what you want you're going to have to build your to list (@recipients) as a variable and pass that into xp_sendmail. So I assume you'd use xp_readmail then based upon the sender/mail you'd set your reply variables @subject, @recipients, @message etc..
Like I say SQL mail isn't that robust and probably not your best option.

Alicia

www.sqlporn.co.uk