Saving sent items from xp_sendmail

[JamesLean]

Does anyone know how to get mails sent using xp_sendmail to save in the Sent Items folder?

I know there's an option in the SQL Agent properties for this but this only affects Agent mail (job notifications, DTS sendmail tasks etc).

All mail used to be saved when we were using SQL 7 but since upgrading to SQL 2000 xp_sendmail is not saved. Is this a "feature"?

--James

 

[smedvid]

I have the same question? Did u reach a resolution to this item? tia,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[JamesLean]

Unfortunately, no. I searched for ages, posted questions like this etc but could not find an answer!

In the end I have taken to amending the xp_sendmail calls where I need to save a copy of the sent item and adding a BCC to the SQL Server mailbox (ie, it sends a copy to itself). Bit of a hack but it does the job.

Let me know if you do manage to find anything.

--James

 

[smedvid]

Good idea... thanks...

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...