Where might I find some info on creating the search string - Basically what I have done so far is go into my pop mail box and for instance found each batch of 25 emails sitting there - then I have queried all those that have [EMAIL PROTECTED] in the from address. From this I am looping through each email - and am ready to search the message body for email strings. - I guess I can use the udf to find the email address that is being referred to.
I guess what I'm not sure about is the code to have it read the message string and look for one of those messages like 550 - I don't think the cffile would work since it's not a file but just the message body... as returned by cfpop After I find the email and confirm that the string 550 and something else in that list you have provided is in the text, I'd have the page query the database and remove any subscribers with that email address. I'd also have it delete that message from the mail box with the cfpop. Thanks for the help so far Colin Wilson -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Breeman Sent: December 7, 2004 12:37 PM To: [EMAIL PROTECTED] Subject: RE: find email addresses in message text > > Read the files with cffile, then search for a single quote in > the string, use the Mid() function to start slicing it up. > If you can be sure that 'Failed to deliver' will always exist > you can look for that too. If you want to get more advanced > you could create a tickler file containing the common phrases > to search for that could be used to determine the position of > the address. > I ran a loop over some failed messages a while ago, and came up with these common strings for failed delivery: 550 mailbox not found mailbox unknown not accepting invalid recipient address not known mailbox unavailable user not known no such user user unknown unknown user no such recipient does not have an account recipient not here permanent fatal does not like recipient user not OK not a valid mailbox permanent error permanent failure Action: failed This may take care of the bulk of your bounces; for those bounces which do not contain any of the phrases above, you can look at them "by hand" for anything that's obviously close, and then add that phrase to the list. There are also some "softer" messages, such as those relating to a full mailbox, that you may want to add or remove according to however strictly you want to eliminate people from future mailings. Adrian ===== . Adrian Breeman http://perplexed.net "If they hang you, I'll always remember you." ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
