use www.mailchimp.com it will handle bounces for you automatically as well as lots of other cool stuff.
On Tue, Aug 23, 2011 at 1:47 AM, Dave Long <d...@northgoods.com> wrote: > > I have a customer who has a modest opt-in mailing list of approx. 4,000 > subscribers that have been added to a MySQL DB via a CF enabled contact > form. Since the list pertains to a once-a-year event, he does not > utilize the list until a month or two before the event and perhaps once > or twice afterwards. As you might guess, over the year long interim, two > or three hundred addresses become invalid annually. > > Now, please don't laugh at the ignorance of my process because I'm here > to be educated. > > In order to prevent accumulation of bad e-mails, I open each individual > failure notice, bring up the attached original message, scroll to the > bottom to click the "Unsubscribe" link which activates a delete query > for that specific e-mail address, (which also displays an > acknowledgement page,) close the page, close the attachment, and > finally, delete the notice. (Whew!) Repeating this action several > hundred times is a real time waster. > > Does anyone in this illustrious group have an idea how this "house > cleaning" could be automated with ColdFusion (or otherwise)? One really > tough part of the problem is that the failure notices are not a > consistent form... various servers use varied formats. > > BTW, if it matters, I'm using a CF5 server with MySQL 3.51 on a Linux > system. > > Thanks for considering this problem. > > Dave Long > NorthGoods Merchant Services > http://www.northgoods.com > > > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm