I have the same problem. I have thought up several possible ways, but there is no good answer that I know of.
The best method that I have come up with is to assign a very identifiable ID to each email address and include it in the bottom of the email newsletter body. Then use outlook to check the return account and after about a week I will export the "bad address" folder to an access database. (Or any other client that will export to a file that can be imported to a database) Then do a search for the identifiable IDs and log them as a "strike". After a few newsletter sends the email that have constantly bounced "struck out" are bad. This should take account for temporary mail server failures, out of office replies, email account quota reached, etc... Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -----Original Message----- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 10:40 AM To: CF-Talk Subject: Removing bad emails from newsletter db One of my client's has about 103k people in his mailing list. He's running his website since 99 and many of these e-mails are bad ones. He wants me to remove the bad e-mails from this list. I used to do that using a software called worldcast, from fairlogic (www.fairlogic.com). It uses DNS to validate e-mails, pretending to send an e-mail and stopping just after he got the 250 code (user exists) or 550 (unknow). Unfortunatly, many networks are not allowing DNS sends, because of spam, so it its not a good solution anymore. I will need to build a tool that interprets the returned e-mails from an actual send (those Undeliverable e-mails) and delete the user based on this e-mail's content. Do you guys knows any software or code that do such thing? Doesn't need to be in cf... I will need to code it myself if i don't find something like that to use, because client needs it very bad (he needs to reduce bandwidth costs). Thank you for your repplies in advance. BP. _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
