On Sun, 2002-08-25 at 11:35, Ken & Marilyn wrote:

> I send out a newsletter every week and get back a number of bounces
> for full mail boxes, mailboxes not found, etc. I track those so that
> after a few weeks of the same bounce I'll delete them from my list.
> Is there any way to extract information from these emails into an
> Excel file? Right now I open each email, and transfer the email
> address and reject info to Excel manually.

Not entirely sure on how you'd do it, but this is how I'd do it (in
theory).  Create a filter that moves the mail to a specific folder.  In
that filter, use a regexp to extract the email address... Append the
results to a text file (use tabbing if you want to store multiple values
on one line)... when it comes to processing the file, you can open it up
as a text file inside excel, and it'll be fairly nicely formated.  I'm
useless at regexp, so maybe the more intelligent of the list will be
able to help you ;)

-- 
Jonathan Angliss
([EMAIL PROTECTED])


________________________________________________________
 Current version is 1.61 | "Using TBTECH" information:  
http://www.silverstones.com/thebat/TBUDLInfo.html

Reply via email to