Change From when using xp_sendmail

I am writing a stored procedure that will send an email, using xp_sendmail, in the error handling if the procedure fails. However, I want the from and return address to list a shared mailbox, so that any questions from the user are directed back to the work queue. Can this be done?
DavidLook into CDO or xp_smtp_sendmail. (http://www.sqldev.net/download/xp/80/xpsmtp80-v1.1.0.8.zip) It's much easier and more flexible (bofem)

CDONTS on sql2000 ?

I need to send email in html format, but xp_sendmail
doesnot support it.
Does anyone know hot to use cdonts on sql2000 ?
Thx.On Tue, 4 Nov 2003 16:59:28 -0800, "Kresna Rudy Kurniawan"
<kresna_rk@.yahoo.com> wrote:
>I need to send email in html format, but xp_sendmail
>doesnot support it.
>Does anyone know hot to use cdonts on sql2000 ?
Instead of CDONTS, use CDOSYS on Windows 2000.
http://msdn.microsoft.com/library/en-us/dnanchor/html/collabdataobjects.asp
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander|||> Does anyone know hot to use cdonts on sql2000 ?
CDONTS is deprecated.
Use CDO.Message or, better yet, xp_smtp_sendmail.
http://www.aspfaq.com/2403|||You can use XPSMTP instead, see http://SQLDev.Net/xp/xpsmtp.htm
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"Kresna Rudy Kurniawan" <kresna_rk@.yahoo.com> wrote in message
news:05c201c3a338$109174d0$a401280a@.phx.gbl...
> I need to send email in html format, but xp_sendmail
> doesnot support it.
> Does anyone know hot to use cdonts on sql2000 ?
> Thx.