We send over 100,000 emails per day to a subscriber list however some emails are inadvertently marked as spam by those recipients who are no longer active, have forgotten about their membership. We subscribe to the feedback loops provided by Yahoo, Hotmail and AOL covering all their respective domains. Feeback loop alerts are delivered as emails to one of our admin addresses and come in two forms, namely 1) one with the full original email as an attachment (this accounts for 80% of all feedback alerts) and 2) the others with the original email as an attachment but with the recipient email address redacted. Within all of those emails is contained the subscriber's unique membership ID (can be identified by the string 'id=xxxxx').
I need to script the extraction of both types of feedback loop email in order to flag accounts and no longer send them emails. Once I have extracted the recipient email address or unique user ID I will process this data in a SQL database, either automatically as an additional step to the extraction process, or manually using a batch process. The main efficiency I'm looking for at present is the extraction of the email address from the feedback loop email attachment.
I'm assuming others must have come across this issue and will have developed VBA scripts to address this challenge.