Changing display-name in Database Mail

In our SQL Server 2005, VB.NET application, we want to send email to
outside clients, and have the email look like it came from the user who
sent it, meaning the Display Name and if possible, Email Address were
related to the person logged into our app.
>From my reading, it seems like we'd have to create a Database Mail
profile for each user. Is it instead possible to modify the Display
Name that sp_send_dbmail uses?
Thanks for any help.You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<petecuce@.gmail.com> wrote in message news:1165017764.318000.233460@.73g2000cwn.googlegroups.com...
> In our SQL Server 2005, VB.NET application, we want to send email to
> outside clients, and have the email look like it came from the user who
> sent it, meaning the Display Name and if possible, Email Address were
> related to the person logged into our app.
>>From my reading, it seems like we'd have to create a Database Mail
> profile for each user. Is it instead possible to modify the Display
> Name that sp_send_dbmail uses?
> Thanks for any help.
>|||I appreciate the response, but that's for older versions of SQL Server
as is way overkill for what I'm trying to achieve.
Tibor Karaszi wrote:
> You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>|||I see. AFAIK, the only place for Database Mail where you can set a display name is in the profile.
Consider posting a request at http://connect.microsoft.com/site/sitehome.aspx?SiteID=68.
I'm fairly certain that xp_smtp will work on 2005, even though I haven't tried it myself (I've seen
comments on using it on 2005 a few times). But the fact that 2005 isn't mentioned on the web site
might be enough to deter you from using it, of course. I'm not sure what you mean by overkill,
though. IMO, xp_smtp is the easiest way to use SMTP to send email - an extended proc that does the
SMTP sockets communication. No configuration, only download the dll, and run sp_addextendedproc. But
you won't get the queuing, of course.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<petecuce@.gmail.com> wrote in message news:1165242880.037495.215810@.80g2000cwy.googlegroups.com...
>I appreciate the response, but that's for older versions of SQL Server
> as is way overkill for what I'm trying to achieve.
>
> Tibor Karaszi wrote:
>> You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>