Dave -- I have used a tag like the activsoftware one before. They are great if you are verifying a single email address as legit before sticking it in your db. They actually go out and check the domain. However, if you are doing 10,000 of these, I think it would be prohibitively slow. Also, you already know they are bad emails since they bounced, correct?
Once you have moved the bounced emails around as I described before, the work is all done except running your script to parse the email address and remove it from your db. I was forced into figuring this out since I was in essentially the same situation as you, and I didn't want to go through 300 emails and manually remove each email from the db. You still might want the activsoftware tag though, those are good for keeping bad emails out of your db in the first place. -- Josh ----- Original Message ----- From: "Dave Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, October 06, 2006 12:31 PM Subject: Re: removing bad emails from bounced emails and db > yes the newsletter still goes out. > The mail is sent out of a seperate account so that it will collect bounces > basically the same was as using failto, so there is no worries about > getting "good emails". > > Actually, thats a pretty good idea ya got there! > > At this point im waiting to hear back from the activesoftware folks, the > have a tag there that will do this but in another way, which would work > perfect. http://www.activsoftware.com/email/verify/ > > The cost aint no biggie but they have it listed as a free tag as well, so > of course free would be better. > > > >>Hi Dave, >> >>Are you still actively sending out the newsletter? If so, maybe you could >>set up your own pop box to receive the bounces (this would depend on how >>you're sending the newsletter, you need contol -- if cfmail then set the >>failto attribute), then download them via your favorite email client >>(thunderbird or whatever) to your local box overnight or something. Then >>you copy them into a directory (on Windows they are automatically >>converted >>to .eml text files when you do this), then ftp them as text files up to >>your >>server and use cfdirectory to loop over the files, parse out the email >>addresses and update your db. That way you don't have to worry about >>cfpop. >> >>It will still take a long time to move all the files around but probably >>way >>faster than cfpopping each one. >> >>I had to do something similar recently, although it was more like 300 >>emails >>than 10,000, it worked dandy. I also used Ray's getEmail function to >>parse >>out the email addresses. >> >>-- Josh >> >> >> >>----- Original Message ----- >>From: "Dave Lyons" <[EMAIL PROTECTED]> >>To: "CF-Talk" <[email protected]> >>Sent: Thursday, October 05, 2006 7:08 PM >>Subject: removing bad emails from bounced emails and db > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
