Need to keep track of SENT emails
-
I am sending bulk emails using asp.net with vb.net. Is it possible to keep track of sent mails? My problem is: - I want to get all mails in my sent items folder (of my mail account) - If mail is not delievered, I want to get a list of mails which are sent successfully and which mails undelievered due to any problem like unknown email id ? - Any suggestion to use xp_sendmail stored proc using SQL Server 2000 to handle this situation? Thanks.
-
I am sending bulk emails using asp.net with vb.net. Is it possible to keep track of sent mails? My problem is: - I want to get all mails in my sent items folder (of my mail account) - If mail is not delievered, I want to get a list of mails which are sent successfully and which mails undelievered due to any problem like unknown email id ? - Any suggestion to use xp_sendmail stored proc using SQL Server 2000 to handle this situation? Thanks.
I used a method which is not bullet proof, but gives you an idea of the sent mails. There are loads of but's and if's involved though... I sent HTML mails including a picture of 1 by 1 pixel. The image comes from a dynamic webpage. The source of my html mail contains the image tag
As said, mailimage.aspx returns an image which allows you to hide the image. Mailingid and Contact id allowed me to set some database flags. Also, when my html mail contained links, for example[a href="http://www.google.com"]google[/a]I changed the link to a diffrent link[a href="http://www.server.com/redirect.aspx?link=http://www.google.com&mailingid=12345&contactid=12345"]google[/a]which also allowed me to keep track of clicked links. However as you can understand, this technique is far from bullet proof and only works when the receipient accepts html mail, and allows you to display pictures. The links still work, which enables you to get some feedback..: I love it when a plan comes together :. http://www.zonderpunt.nl