Hi there!
I was wondering if anyone has any ideas on how to handle bounce backs. I need to clean up my database. When I send a mass email, there can be up to 100,000 recipients. I typically get 10,000 to 15,000 bounce backs. I know this should be much lower, but I need to be able to easily identify these records in my database in order to take action on them.
Any ideas?
Gérald Gallant
Canadian Federation of Independent Business
www.cfib.ca
Subject: Bulk Emailing: How can I handle all the bounce backs?
Create a view in the database which receives those delivery failures and compare IntendedRecepient field of every document in that view with list of all people in the list.When you find match, you can delete the recepient document from the list database or put status of the list doc to “To be reviewed” or something. Next sending exclude recepients with doc status “To be reviewed” from sending.
Coding depends on how your database is designed and what actions you want to take. A rather simple formula agent with dblookups should be able to do the job.