Alex, thanks again. Sometimes I get very narrow focused and can't see the forest for the trees.
I was already using a CF template I had written, that stripped the email adresses from the text file that Outlook Express (Mac) saves it's emails in. I was ftping that text file to the CF server and then stripping it. Somehow I got it into my head that when I retrieved the email with CFPOP I needed to put them into a database that would replace the text file as input into the stripping program. Your comment got me to thinking that I could use the CFPOP #body# as the input into the stripping program. Made the change in code and it works like a charm. Michael Gribbin ----- Original Message ----- From: "Alex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 25, 2001 2:04 PM Subject: Re: returned emails > I don't know what a database has to do with this, but if you just want to > parse out <[EMAIL PROTECTED]> use a regular expression. > > > On Thu, 25 Oct 2001, Michael Gribbin wrote: > > > Alex, > > > > Thanks, what you said makes sense to me now. I do send out the initial > > emails, but since the returned emails are in the attachment, I can't get > > anything from the original TO: or the original BODY: to show up in my > > database. > > > > In fact, I think I am overlooking something here. > > > > Example: This is what the returning email server wrote in the body, as well > > as including the original email as an attchment. > > > > --------------------- > > The original message was received at Tue, 2 Oct 2001 03:18:29 -0700 (PDT) > > from [209.221.166.109] > > > > ----- The following addresses had permanent fatal errors ----- > > <[EMAIL PROTECTED]> > > > > ----- Transcript of session follows ----- > > <[EMAIL PROTECTED]>...Deferred: Connection timed out with resortsys.com. > > Message could not be delivered for 5 days > > Message will be deleted from queue > > ----------------- > > > > None of the above shows up in the database either. > > > > But when the same routine processes an email from the same returned batch > > that included one sent from a porno site that has in the body: > > > > "Finally a nude celebrity site for people that hate celebrity sites!" > > > > That shows up in the database just fine. Go figure!!! > > > > So I'm wondering what there is about the body of the returned email that > > keeps it from being inserted. Like I said, when I use the same QUERY and > > show the body in HTML using #query.body#, it all show up just fine. I could > > pinpoint the problem if none of them worked but original emails are fine, > > returned emails, no. > > > > Michael Gribbin > > > > > > > > > > > > ----- Original Message ----- > > From: "Alex" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, October 25, 2001 12:37 PM > > Subject: Re: returned emails > > > > > > > "First time" means the very first time an email is sent. NOT the returns. > > > Do you send the initial emails or just get returned emails? > > > > > > > > > On Thu, 25 Oct 2001, Michael Gribbin wrote: > > > > > > > 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
