in reply to email bouncebacks

I would like to thank you all very much for your input.


I am in the unhappy position of having to run this report with both hands tied behind my back...or at least a hand and one foot. My only access to the mail is via Outlook and my access to support data (for later pulling of phone numbers that correspond to the addresses)is via a web page. I will be working from either a CSV dump of a bounce back email folder or I will set up a rule to have outlook bounce a copy of the bounce back messages to my personal mail server.

Our messages go out around the first of the month, so I will only have about a 1 week period of messages to work with at a time (unfortunately, I will have no way to wait for multiple bounces to help rule out full boxes).

My current plan for a first run, is to grep anything that looks like an e-mail address from the dump file, into a new report.

The next step will be to work on obtaining the phone info from the database and including that in the report.

Lastly, I may work to include a search of the dump file, for fraises that denote soft errors (box full or the like). And mark those addresses in the report (this way customer service can decide what to do with it (wait until the next month or call the person right away).

This will give the customer service department something that they can use at each step.

This all sounds pretty straight forward, I may still be back for help but I think you have all given me a great foundation to start with.

James