HTML Emails

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