January 20, 2009 at 10:54 pm
how to send mail and track the bounced mail in SQL-Server or C#.NET.actually am able to send mails using SQL-Server(CDO) but unable to track the bounced mail .
January 27, 2009 at 9:46 am
I am watching this to see if there is a good answer here.
My current solution is: Make sure the sending address is human checked so a bounced Email can be caught. When my App sends an Email, a BCC is also sent to sender, that way the sender knows the Email has left the system, but they do not get a reminder when it fails! From my App, i can browse failed Email messages:
SELECT LEFT(items.subject,35) AS Subject, items.last_mod_date, CAST(items.Recipients AS CHAR(31)) AS Recipients, CAST(ISNULL(items.Copy_Recipients,' ') AS CHAR(15)) AS CC, CAST(items.Profile_ID AS CHAR(2)) AS PI, l.description FROM MSDB.dbo.sysmail_faileditems as items JOIN MSDB.dbo.sysmail_event_log AS l ON items.mailitem_id = l.mailitem_id WHERE items.send_request_date > GETDATE()-365 ORDER BY items.last_mod_date DESC
Maybe the answer is a automated check on this data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply