record Emaisl statuses in asp.net, mssql db

On this page [login to view URL] After sending email, you need to add the following statuses: Sent - date and time Open - date and time (check below of more details about Open emails) Bounced - date and time SMTP Invalid - date and time Open means it was sent and opened by recipient. You need to place a table below the editor to record the status each time it is sent in date/time descending order. The table name in MSSQL db: "MailHistory" with the 3 below columns have aleady been created 1) Id (bigint) 2) Email Recipient(nvarchar(100)) 3) Mail Sending Status (int) ----- Tracking “opens” in HTML emails - [login to view URL] If you want to track an “open” in an HTML email, you would embed a tiny, 1×1 pixel .GIF at the bottom of the email message. This image is also known as a “web beacon” or a “tracker image”. In reality, most people don’t use a 1×1 size pixel, because a lot of anti-virus packages will block that GIF size since they know that it’s a tracker image. So, what would count as an open? When your recipient opens his or her email, the tracker image is downloaded from your server, and this download is then counted as an ‘open’ . A lot of people will say that you can’t track opens unless it’s an HTML email, which means that tracking open emails is not an exact science. But, that is true only to a certain extent. Check out the next article to see how tracking is done in plain text emails. ------ Tracking “opens” in Plain text emails - [login to view URL]