Or save yourself a lot of work and use SmartBounce http://www.smartbounce.com/
H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -----Original Message----- > From: Alex [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 25, 2001 2:04 PM > To: CF-Talk > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
