Handling Multiple Incoming eMail Formats

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

   I am trying to build a process to handle bounced e-mails.  At this point, I just need Email2DB to generate a csv containing the original e-mail addresses of recipients that resulted in a failure/bounce.
If the e-mails come in different formats and I'm trying to parse the original recipient e-mail address, how do I setup Email2DB to look at more than one format.  Here is an example of the various kinds of e-mail returns I get:

Sample A: 
Subject: Delivery Status Notification (Failure)
Body: 
This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
achawla@veraznetworks.com

Sample B:
Subject: Returned mail: see the transcript [FAILED(1)]
Body: 
This is a collection of reports about email delivery process concerning a message you originated.
Some explanations/translations for these reports can be found at:
http://zmailer.org/delivery-report-decoding.html

If you are our customer, further help is available at email address: ____ @ ______ (TO BE FILLED IN)
Reporting-MTA: dns; swip004.ftl.affinity.com
Return-Path: <scunningham@minecorinc.com>
Arrival-Date: Wed, 11 Mar 2009 10:55:07 -0400
Local-Spool-ID: S752585AbZCKOzH

FAILED:
Arrived Recipient:
rfc822;Amanda_Anderson@adaptec.com
Original Recipient:
rfc822;Amanda_Anderson@adaptec.com
Final Recipient:
RFC822;Amanda_Anderson@adaptec.com
Status:
5.1.1 (bad destination mailbox)
Remote MTA:
dns; mail-gw4.adaptec.com (162.62.92.163|25|172.31.2.103|44986)
Last Attempt Date:
Wed, 11 Mar 2009 10:55:18 -0400
X-ZTAID:
smtp[5182]
Diagnostic Code:
smtp; 550 (#5.1.0 Address rejected Amanda_Anderson@adaptec.com)
Control data:
smtp adaptec.com Amanda_Anderson@adaptec.com 99
Diagnostic texts:
<<- MAIL From:<scunningham@minecorinc.com> BODY=8BITMIME SIZE=48075
->> 250 sender <scunningham@minecorinc.com> ok
<<- RCPT To:<Amanda_Anderson@adaptec.com>
->> 550 #5.1.0 Address rejected Amanda_Anderson@adaptec.com
Following is a copy of MESSAGE/DELIVERY-STATUS format section below.
It is copied here in case your email client is unable to show it to you.
The information here below is in Internet Standard format designed to assist automatic, and accurate presentation and usage of said information.
In case you need human assistance from the Postmaster(s) of the system which sent you this report, please include this information in your question!
Virtually Yours,
Automatic Email Delivery Software
Reporting-MTA: dns; swip004.ftl.affinity.com
Arrival-Date: Wed, 11 Mar 2009 10:55:07 -0400
Local-Spool-ID: S752585AbZCKOzH
Original-Recipient: rfc822;Amanda_Anderson@adaptec.com
Final-Recipient: RFC822;Amanda_Anderson@adaptec.com
Action: failed
Status: 5.1.1 (bad destination mailbox)
Remote-MTA: dns; mail-gw4.adaptec.com (162.62.92.163|25|172.31.2.103|44986)
Last-Attempt-Date: Wed, 11 Mar 2009 10:55:18 -0400
Diagnostic-Code: smtp; 550 (#5.1.0 Address rejected Amanda_Anderson@adaptec.com)

Following is copy of the message headers. Original message content may be in subsequent parts of this MESSAGE/DELIVERY-STATUS structure.
Received: from [199.227.30.163] ([199.227.30.163]:2531 "EHLO DELLC400")
by swip004.ftl.affinity.com with ESMTP id S752585AbZCKOzH;
Wed, 11 Mar 2009 10:55:07 -0400
From: "Steve Cunningham" <scunningham@minecorinc.com>
To: "'Amanda Anderson'" <Amanda_Anderson@adaptec.com>
Subject: Minecor Surpasses Client's Quota During Economic Crisis
Date: Wed, 11 Mar 2009 09:53:43 -0500
Message-ID: <4E909005306B44C781D11C24760715D5@DELLC400>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_00C5_01C9A22F.6EFFCBB0"
X-Mailer: Microsoft Office Outlook 11
Thread-Index: AcmiWPA0dA3mFRvbQKaVxIjUfYhgKg==
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-Mail-Filter-Gateway: Not scanned
X-Mail-Filter-Gateway-SpamDetectionEngine: not spam,
SpamAssassin (not cached, score=1.417, required 10,
autolearn=disabled, HTML_MESSAGE 0.00, RDNS_NONE 0.10, URI_HEX 1.32)
X-Mail-Filter-Gateway-SpamScore: 1
X-Mail-Filter-Gateway-From: scunningham@minecorinc.com
X-Mail-Filter-Gateway-To: amanda_anderson@adaptec.com

Thanks for your help! (I am a beginner at using this software)

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
aviator143 Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 18 Mar 2009 Posts: 2	Post Options Post Reply Quote aviator143 Report Post Quote Reply Topic: Handling Multiple Incoming eMail Formats Posted: 18 Mar 2009 at 8:12pm
	I am trying to build a process to handle bounced e-mails. At this point, I just need Email2DB to generate a csv containing the original e-mail addresses of recipients that resulted in a failure/bounce. If the e-mails come in different formats and I'm trying to parse the original recipient e-mail address, how do I setup Email2DB to look at more than one format. Here is an example of the various kinds of e-mail returns I get: Sample A: Subject: Delivery Status Notification (Failure) Body: This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. achawla@veraznetworks.com Sample B: Subject: Returned mail: see the transcript [FAILED(1)] Body: This is a collection of reports about email delivery process concerning a message you originated. Some explanations/translations for these reports can be found at: http://zmailer.org/delivery-report-decoding.html If you are our customer, further help is available at email address: ____ @ ______ (TO BE FILLED IN) Reporting-MTA: dns; swip004.ftl.affinity.com Return-Path: <scunningham@minecorinc.com> Arrival-Date: Wed, 11 Mar 2009 10:55:07 -0400 Local-Spool-ID: S752585AbZCKOzH FAILED: Arrived Recipient: rfc822;Amanda_Anderson@adaptec.com Original Recipient: rfc822;Amanda_Anderson@adaptec.com Final Recipient: RFC822;Amanda_Anderson@adaptec.com Status: 5.1.1 (bad destination mailbox) Remote MTA: dns; mail-gw4.adaptec.com (162.62.92.163\|25\|172.31.2.103\|44986) Last Attempt Date: Wed, 11 Mar 2009 10:55:18 -0400 X-ZTAID: smtp[5182] Diagnostic Code: smtp; 550 (#5.1.0 Address rejected Amanda_Anderson@adaptec.com) Control data: smtp adaptec.com Amanda_Anderson@adaptec.com 99 Diagnostic texts: <<- MAIL From:<scunningham@minecorinc.com> BODY=8BITMIME SIZE=48075 ->> 250 sender <scunningham@minecorinc.com> ok <<- RCPT To:<Amanda_Anderson@adaptec.com> ->> 550 #5.1.0 Address rejected Amanda_Anderson@adaptec.com Following is a copy of MESSAGE/DELIVERY-STATUS format section below. It is copied here in case your email client is unable to show it to you. The information here below is in Internet Standard format designed to assist automatic, and accurate presentation and usage of said information. In case you need human assistance from the Postmaster(s) of the system which sent you this report, please include this information in your question! Virtually Yours, Automatic Email Delivery Software Reporting-MTA: dns; swip004.ftl.affinity.com Arrival-Date: Wed, 11 Mar 2009 10:55:07 -0400 Local-Spool-ID: S752585AbZCKOzH Original-Recipient: rfc822;Amanda_Anderson@adaptec.com Final-Recipient: RFC822;Amanda_Anderson@adaptec.com Action: failed Status: 5.1.1 (bad destination mailbox) Remote-MTA: dns; mail-gw4.adaptec.com (162.62.92.163\|25\|172.31.2.103\|44986) Last-Attempt-Date: Wed, 11 Mar 2009 10:55:18 -0400 Diagnostic-Code: smtp; 550 (#5.1.0 Address rejected Amanda_Anderson@adaptec.com) Following is copy of the message headers. Original message content may be in subsequent parts of this MESSAGE/DELIVERY-STATUS structure. Received: from [199.227.30.163] ([199.227.30.163]:2531 "EHLO DELLC400") by swip004.ftl.affinity.com with ESMTP id S752585AbZCKOzH; Wed, 11 Mar 2009 10:55:07 -0400 From: "Steve Cunningham" <scunningham@minecorinc.com> To: "'Amanda Anderson'" <Amanda_Anderson@adaptec.com> Subject: Minecor Surpasses Client's Quota During Economic Crisis Date: Wed, 11 Mar 2009 09:53:43 -0500 Message-ID: <4E909005306B44C781D11C24760715D5@DELLC400> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C5_01C9A22F.6EFFCBB0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcmiWPA0dA3mFRvbQKaVxIjUfYhgKg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Mail-Filter-Gateway: Not scanned X-Mail-Filter-Gateway-SpamDetectionEngine: not spam, SpamAssassin (not cached, score=1.417, required 10, autolearn=disabled, HTML_MESSAGE 0.00, RDNS_NONE 0.10, URI_HEX 1.32) X-Mail-Filter-Gateway-SpamScore: 1 X-Mail-Filter-Gateway-From: scunningham@minecorinc.com X-Mail-Filter-Gateway-To: amanda_anderson@adaptec.com Thanks for your help! (I am a beginner at using this software)
	aviator143