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:346948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
