Changing the Sender in XP

8 Dec 2005 6:10 PM

anthonysjo

Is is possible to change the sender when using XP_Sendmail? I am sending a
notification that reports are available in reporting services in a single
email and want to change the sender from SQLSERVICEADMIN to something users
will recgonize easily.

Thanks for the help!!

Anthony

8 Dec 2005 6:44 PM

Stijn Verrept

anthonysjo wrote:

> Is is possible to change the sender when using XP_Sendmail? I am
> sending a notification that reports are available in reporting
> services in a single email and want to change the sender from
> SQLSERVICEADMIN to something users will recgonize easily.

You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)

--

HTH,

Stijn Verrept.

8 Dec 2005 7:00 PM

anthonysjo

Yes, I had found reference to that but my DBA's will push heavily on not
installing it. Is there another way?

Show quote

"Stijn Verrept" wrote:

> anthonysjo wrote:
>
> > Is is possible to change the sender when using XP_Sendmail? I am
> > sending a notification that reports are available in reporting
> > services in a single email and want to change the sender from
> > SQLSERVICEADMIN to something users will recgonize easily.
>
>
> You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
>
> --
>
> HTH,
>
> Stijn Verrept.
>

8 Dec 2005 7:04 PM

Jens

As I know there is no way using the "friendly" name within XP_sendmail.
Once I had a commandline program which was able to send also via SMTP.
But this could be easily reprogrammed in .NET or another programming
language covering the same functionality. If you are interested in,
just send me a mail.

HTH, Jens Suessmeyer.

Changing the Sender in XP_Sendmail