Develop a MS Outlook VBA project that will send email transactions(ie. Mail received, mail deleted, mail opened, etc.) to a SQL*Server database. For example, when a user opens an email I need to send a record, ie. transaction, to the database recording such event. Also, I want to send the email's subject, from address, to address, # of attachments, etc. as a part of the record into the SQL*Server database.
1. Is it possible to connect to a SQL*Server database using MS Outlook Macro/VBA, and automate such event when the transaction occurrs? If so, is there a technical document illustrating such?
2. Do email messages have a unique identifier that can be tracked?