HTML Emails

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?

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

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")