SQLMail + From Address

[vlitim]

Is it possiblt to set the From address when you are sending from SQL??

Cheers
Tim

 

[NoCoolHandle]

In my understanding the answer would be NO. The probem is that you are sending it from a specific mail profiles email account.. no spoofing.

You might want to look into SMTP mail functionality. This can be achieved via CDONTS and sp_oaCreate. Or there are a couple of SQLserver SMTP agents out there for the grabbing..

check out

http://sqldev.net/xp/xpsmtp.htm

I believe it is run by Gert Draipers who used to be the SQL client tool manager for MS

HTH

Rob
PS Look around his site, got some really cool code snips!

 

[mrdenny]

Sadly the answer is no. SQLMail will only send from the email address configured in the mail client. I would recommend xp_smtp_sendmail. I have used it several times to send large quanties of email, and it works great.

I would stay away from the sp_oa procedures when ever possible. There are memory leak issues with using the sp_oa procedures that creap up after time and are very hard to track down.

Some of these memory issues were fixed in sp3a but not all.

Denny

--Anything is possible. All it takes is a little research. (Me)