Hi guys, I have a rule of thumb. NEVER DELETE ANY DATA. Be it an obsolete email, a diseased customer, etc. I just flag the as NOT TO BE USED. This is because over time, someone may decide to activate that data and become your next biggest buyer.
Also, with respect to newsletters, I have over 17,000 emails in my list. (I know its not as much as yours), but after spending so much with the likes of icontact and campaign monitor, I decided to get ingenious. So I segmented the list into minor groups of 2,000. Then I churned our this flow in my code: 1. Select all from list table, but group by list name- this is so I can select which list to sent to at a time. 2. Put selected list(s) in a table, then loop through each list one by one, confirming: a) if there are valid emails, using the inValid function, else, isolate (don't delete) b) last contact we had with it. This is to watch out for excessive newsletters sent to a particular email weekly c) etc 3. Loop through emails and Send newsletters to each in the batch, using page refresh. By this, I can send to as much as 100 emails in every 10 seconds. Well, its old fashioned, but I get to save newsletters marketing funds. Hehe ;) Best regards, Chuka Anene www.Quorium.org Sent from Samsung tablet Mike K <afpwebwo...@gmail.com> wrote: You probably know already, but I'll say it just in case ... you can rarely have a 100% clean list. I have found that even after you just clean up a list, your next mailing will have rejects in it. Even if it's only a few minutes since you last cleaned it up. Your error handling needs to be able to differentiate between temporary problems (e.g. mailbox full) and permanent problems (e.g. that user not known here) . Your block of ip addresses can be blocked if someone in the same data centre gets flagged as a spammer. And that can be only transient too, so next time you try to bulk email some of the ones that were rejected as "sender address blocked" are not rejected now. Then there are the ones that are rejected because their mailbox is full. It might be full because it's an inactive email address (i.e. permanent) , or simply that they have been on vacation and havent picked up email for a while (i.e. temporary). Or they might be in arrears with the credit department at their email hosting service, which will be cleared again once they pay their bill. I usually flag bouncing email addresses but still include them in the next couple of emails. If they bounce 3 times I consider them to be dead and remove them from the list. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
