Alex, I guess i don't follow what you are saying. I have 500+ returned emails each with a different TO:email address. There is only one returned copy of each of them. I don't understand the "first time" and the "bounces". So far I haven't been able to get any of the TO:email address into my database. (Of course I haven't tried all 500+ yet, but will and see if any show up).
Further explaination would be appreciated. Michael Gribbin ----- Original Message ----- From: "Alex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 25, 2001 11:43 AM Subject: Re: returned emails > send the emails out with the email address in the body of the text the > FIRST time. Then on bounces grab the to email address from there > > On Thu, 25 Oct 2001, Michael Gribbin wrote: > > > Hi all, > > > > I have an interesting problem I need help with. I have a client that sends > > out around 5000 emails from a master list once a week. About 500 per session > > are returned as undeliverable. I am writing a program to grab the returned > > email from the POP server, strip out the email addresses and ftp the > > resulting "bad" list to a different server for master list cleaning. > > > > I don't have any problems with the CFPOP getting the emails, nor the CFFTP > > putting the list where it belongs. My problem is that most of the returned > > emails have the original "TO: Email Address" in an attatchment. When I view > > these emails in my Outlook Express, the attatchment shows up as part of the > > message body. When I download them with CFPOP and view them as HTML, these > > attatchments shows up as part of the message body. When I INSERT them into > > an Access database using the same CFQUERY as the HTML display, and the same > > #query.body#, the part of the message body that was the attatchment won't > > show up. Only the part of the message body that is not in the attatchment is > > there. > > > > Kind of defeats my intentions if I can't grab the original "TO: Email > > Address". > > > > Any help will be appreciated, > > > > Michael Gribbin > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
