Database Mail

I am using the sp_send_dbmail for my mailing activity for my client
applications. I have created a profile for the SP and assigned my name
and e-mail address. but when any of my users send a mail from the
client application the display name of the mail is my name and not the
person who actually sends the mail.
Is it possible to set the display name dynamically? or anyother
workaround ?
Any help would be appreciated
ThanxsThe only way I could think of is to setup several mail profiles and have eac
h user use a different
mail profile. Or, use xp_smtp_sendmail. Also, consider wishing this feature
at
connect.microsoft.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<brinda.shree@.gmail.com> wrote in message
news:1173789930.776042.169600@.c51g2000cwc.googlegroups.com...
>I am using the sp_send_dbmail for my mailing activity for my client
> applications. I have created a profile for the SP and assigned my name
> and e-mail address. but when any of my users send a mail from the
> client application the display name of the mail is my name and not the
> person who actually sends the mail.
> Is it possible to set the display name dynamically? or anyother
> workaround ?
> Any help would be appreciated
> Thanxs
>