It may take some trial and error, but compared with manually reviewing all emails, this can be a significant time saver. Your logic can be as simple or as complex as you want. You will need to examine your own list of returned emails and add logic as your needs require.
In this case, some of our newsletters failed to reach their recipients and were returned to us as undeliverable. For example, assume that our Contacts list is as followsĪnd that we have sent several monthly newsletters to this contact list. To demonstrate, we’ll use the Access 2007 Contacts template. Using your own logic, you can write a series of queries to review the incoming messages and handle unsubscribe requests. Microsoft Access includes the ability to link to Exchange/Outlook folders and treat the email messages just like records in a table.