How to change From field in e-mail sent by SQL Mail?

We use SQL Mail to sent e-mail notification to customers. In the From field of the e-mail they see the ugly name of our SQL Server account, under which SQL Mail runs. How can I change that From to something more meaningful for the customers?
SQL Mail doesn't support that.
Xp_smtp_sendmail from www.sqldev.net does, however. And it doesn't rely on MAPI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:64C50FD1-144B-4746-ADB1-3C3D6FEE6B67@.microsoft.com...
> We use SQL Mail to sent e-mail notification to customers. In the From field of the e-mail they see the ugly
name of our SQL Server account, under which SQL Mail runs. How can I change that From to something more
meaningful for the customers?
|||Thanks, Tibor.
Just one more try. I forgot to mention that SQL Mail works through Exchange Server. Is there any way to set that nickname for the SQL account at Exchange?
|||I don't know. I suggest you check with someone who know exchange :-).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:1C9C059E-6CD9-46D7-87B9-CAF7383658C7@.microsoft.com...
> Thanks, Tibor.
> Just one more try. I forgot to mention that SQL Mail works through Exchange Server. Is there any way to set
that nickname for the SQL account at Exchange?