Yes... Many ways, but the easiest would be to have them bounce into a mailbox of your choosing. You could then use CF to pop the mail and read the information that is needed to identify enough to send the query to the database to delete or do what you need to do.
That is just one method, out of many... On Tue, Aug 23, 2011 at 10: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 > > -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
