Post reply

How can I track if the email has been opened or not?

  • June 1, 2010 at 4:17 am

    #219535

    I have to track whether all e-mails sent were opened or not. Any suggestions?

    My system is purely in SQL Server 2005. No front end.

  • June 1, 2010 at 7:14 am

    #1174755

    do you host the email server? if you are talking about emails you SENT, you cannot, you can only check the status of emails that exist on your mail server, whether Exchange or an SMTP server like MailEnable or something.

    and you would end up doing it outside of SQL Server, as the data does nto exist in SQL Server anyway.

    the sleazy way to do it is what you see in all your spam emails: adding an image to the html email that gests an image for a server side process that sent a uniqueId to get the image:

    <img src="somepage.aspx?ID=12345"

    so you can infer if the image was downloaded, the page was views(and therefore the email was good, so you can send more spam.)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply