Question Repetitive tasks with external data

[Peter Ramshaw]

Hi guys
Seeking some direction re some data I need to delete.
Short stoy is that I did an email merge to a list to clean it out ... as a result I have about 1200 emails that have 'bounced'. I want to delete these email addresses from the database as they are useless to me.
Is there some way of automating that? Might seem odd question but I'd appreciate some advise. What we have:
1) an inbox in Outlook 2010 with 1200 'rejected'/'non-deliverable' emails in it.
2) an Access 2010 database with two email fields (one for work and one for private addresses)
I ned somethign to replace what what I'm doing manually (and that is open the next email, copy the rejected email address, switch to database, search email field for email address and delete it, then start again). ...

Cheers
Peter

 

[John Big Booty]

Perhaps on of the articles here may be of assitance.

If you are able to import the failed amails and extract the bad addresses it should then be a simple matter to delte the bad ones from your table.

 

[Peter Ramshaw]

Well, I do have (if I can find it) an email harvetsing program by MaxProg (don't use it anymore for email campaigns as that is illegal here in Aus) but for a maintenace job like this, it might be okay. It simply strips email addresses from whatever you drop onto it and creates a list of them. I'll check your links and see. Many thanks.
Peter

 

[Galaxiom]

It is generally a lot simpler to work with the mailserver logs than the bounce messages themselves. Our mailserver gives a list of failed deliveries by response code, which I found quite easy to import.

 

[Peter Ramshaw]

Thanks to all.
I now DO have a plain text file with all of the email addresses I need to get out of my table as a list.
What's the easiest way to do that? Anyone point me in the right direction?
Thanks in advance.