MS SQL Server - SQL Mail using an alias

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Mail using an alias

LiliA

2005-12-02, 1:23 pm

Hi there,

I need to send an email outside of the company whenever an Invoice is
printed.
This is simple to do with a trigger in Invoice Table what uses
xp_sendmail.
My problem is that the email is sent by the SQL Mail account (which is
called SQL).
I would like the email to say that it was sent by
orderdesk@mycompany.com
Is is possible to do something like this?

Thanks,

LiliA

Sponsored Links