im sending out newsletters to the companies database of subscribers, they say they get several thousand bounce backs each time. So I want to remove those bounce back emails from db. So i figured I'd set up a seperate email account just for the newsletters and grab all the bounce backs via cfpop and loop thru the results and run a delete against the mailing list db and get rid of them all.
so the problem is that the email address comes back in the body section of the bounce back message and you have to go in and find it and grab it then run it into the delete query. You can use a regex but im not sure how to just get the email address out of all that. here is a sample of a bounce back ---------------------------------------------------------------------------------------- I'm sorry to have to inform you that your message could not be be delivered to one or more recipients. It's attached below. For further assistance, please send mail to <postmaster> If you do so, please include this problem report. You can delete your own text from the attached returned message. The Postfix program <[EMAIL PROTECTED]>: host mail.asdd.com[216.77.62.196] said: 550 5.1.1 User unknown (in reply to RCPT TO command) ---------------------------------------------------------------------------------------- how do i get that out and into its own variable? ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
