http://www.aspfaq.com/show.asp?id=2474 - http://www.aspfaq.com/show.asp?id=2474

Bear in mind that the trend in email clients is to have html display turned off by default.

thekiwi,

Do you know if I will still be able to track when someone reads my email if they open the email in Plain Text?

With either an HTML or a text email, you can have an active link to take a user to a page.

With HTML, you can include an image in the email that is loaded from your site. You can set up the image src for something like http://www.mysite.com/image.jpg?ID&NUM=9999 - http://www.mysite.com/image.jpg?ID&NUM=9999 - where 9999 is some code that you put on that specific email.

You then write yourself a little script to view your logs and pull the 999's and match them up against your data base to find out who opened the email. - Note that instead of 9999, you could have something like IDNUM=Username

I use Outlook 2003 which has images turned off by default so this wouldn't work for me or for similar email clients.

You can also send either a text or an html email with a "Request Receipt" option. But most email clients will not send you a receiept by default.

Bottom line is that there's no sure way to tell if someone reads your email.

I have created the web pages. However, I have one problem. I get notified by email that the person has read the email after I have sent it which is not true. How do I fix this problem?

Here are some significiant lines of code to look at:

MHTMLBody = "http://www.--------.com/ReadEmail.asp?ID=" & EmailNum

Few lines of code for ReadEmail.asp:

If Read = false then rs("TimeRead") = Now()
'Set value of boolean field
rs("Read") = true rs.Update

Misty wrote: I have created the web pages. However, I have one problem. I get notified by email that the person has read the email after I have sent it which is not true.

Do you get notified for all emails you send, or just some of them?

You'll have to print more code. what you show may mean something to someone else, but it puzzles me.

I get notified for all of the emails that I send out. I will give you the code for both web pages (1. The web page that sends the email out. 2.) The ASP page that adds yes to the read box in the database when someone has read a particular email.

The page that sends the email:

<%

'EmailSent.asp

%>

<%

    'declare variables

    'Strings for recipient, subject, boby

    Dim SubjectLine, Body, EmailNum

    Dim MyMail 'The Jmail object

    Dim rs

    'grab the variables from the form

    EmailNum = Request.QueryString("EmailID")

    'Declare constants for a recordset that allows adding records

      dim sqlString

      dim connectionString, databaseName, path

      dim SEmail, Sender, EmailBody, Email

      dim Name, Msg, EmailAddr

      'Set connection details

      sqlString = "Select * FROM Emails, Users"

      'Add WHERE Join clause

      sqlString = sqlString & " where Emails.EmailID=Users.EmailID"

      sqlString = sqlString & " and Emails.EmailID=" & EmailNum

      set rs = Server.CreateObject("ADODB.Recordset")

      rs.Open sqlString, connectionString

    'loop through the recordset

    While Not rs.EOF

    SEmail = rs("SEmail")

    Sender = rs("Sender")

    Name = rs("Name")

It didn't work for the ASP page that sends out the email. 

I think that the MHTMLBody code is causing the problem because it refers to ReadEmail.asp.

This is the code in my reademail.asp page:

If Read = false then
rs("TimeRead") = Now()

'Set value of boolean field
rs("Read") = true rs.Update

I tried setting the read to false in reademail.asp, but it didn't work. I don't know what's wrong.

I really appreciate Don's help. I finally got the application working. However, there is one small problem I'd like to solve.

I looked at the view source. It is referenced as <img src=" http://www.anywhere.com/reademail.asp?ID=9 - http://www.anywhere.com/reademail.asp?ID=9 "> I've chosen to type anywhere instead of the real web site address for security reason.

I would like for the logo to show up. The logo is on the reademail.asp page.

I really appreciate Don's help. I have solved all of my problems. I wanted to share the code for the ASP page that sends out the email and the ASP Page that notifies users when someone has read their emails. This is very useful if you want to send HTML emails to your friends and would like to find out if they have read your email. You will need to create a form page and a page that adds the information to a database. The lines of code that are in red are significant.

Code for the page that sends out the email:

<% 

Option Explicit

'=========================================================== =====

' name: EmailSent.asp

' programmer: Misty Roberts

'Procedures:

' DrawPage()

'=========================================================== =====

      'Declare constants for a recordset that allows adding records

      Const adLockOptimistic = 3

      Const adOpenDynamic = 2

      dim sqlString

      dim connectionString, databaseName, Path

      dim rs

      Dim SubjectLine, Body, EmailNum

      dim SEmail, Sender, EmailBody

      dim Name, Msg, EmailAddr, Email

    'grab the variables from the form

    EmailNum = Request.QueryString("EmailID")

     'Set connection details

     Add your database connection details here

      sqlString = "Select * FROM Emails, Users"

      'Add WHERE Join clause

      sqlString = sqlString & " where Emails.EmailID=Users.EmailID"

      sqlString = sqlString & " and Emails.EmailID=" & EmailNum

      set rs = Server.CreateObject("ADODB.Recordset")

      rs.Open sqlString, connectionString, adOpenDynamic, adLockOptimistic