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 > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
