RE: SQL Mail to forward replies to different people depending on subject?
From: Alicia (anonymous_at_discussions.microsoft.com)
Date: 05/19/04
- Next message: Alex Molochnikov: "QL Server Report Generator - beta testers needed"
- Previous message: ld: "SQL Mail to forward replies to different people depending on subject?"
- In reply to: ld: "SQL Mail to forward replies to different people depending on subject?"
- Next in thread: ld: "RE: SQL Mail to forward replies to different people depending on subject?"
- Reply: ld: "RE: SQL Mail to forward replies to different people depending on subject?"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Alex Molochnikov: "QL Server Report Generator - beta testers needed"
- Previous message: ld: "SQL Mail to forward replies to different people depending on subject?"
- In reply to: ld: "SQL Mail to forward replies to different people depending on subject?"
- Next in thread: ld: "RE: SQL Mail to forward replies to different people depending on subject?"
- Reply: ld: "RE: SQL Mail to forward replies to different people depending on subject?"
- Messages sorted by: [ date ] [ thread ]