K
kristopher.erickson
I have to correct and organize alot of bad emails and I'm trying to do
it automatically. Some emails ahve a nice message body, and subject
line and I can get those forwarded. Others just come to me and say
"system administrator" and "Undeliverable" with an attachment. For
instance the "view" plane shows this:
Your message did not reach some or all of the intended recipients.
Subject: test
Sent: 11/3/2006 11:50 AM
The following recipient(s) could not be reached:
....etc.etc.
<u>and message options shows this as the header:</u>
Microsoft Mail Internet Headers Version 2.0
From: postmaster@somewhere
To: myemail
Date: Fri, 3 Nov 2006 11:50:12 -0500
....
Message-ID: <[email protected]>
Subject: Delivery Status Notification (Failure)
....etc.etc.
My ideal is that when other people of the company get one of these, it
gets emailed to me automatically (not as an attachment), and is sorted
by a 2nd rule (which works) in my system. For some reason none of my
rules seem to forward the Email. I tried with certain text in the
subject; other rules looked for text in the header etc, and none seem
to work. I'm willing to make some VBA, but I don't know it well enough
and it's easier to make a rule on someone else computer.
I essentially want to take the text I see in the view plane (which I
think is an attachment) and turn it into the message body, which I can
see in "inbox" window and thus I can drag and drop into excel and run
some stuff and pull out the emails and make a pretty list for me to
drop back into access and note as "bad" in our database. So to make a
long story short <u> how do I take an undeliverable email attachment
and turn it into message text</u> like when I forward them individually?
it automatically. Some emails ahve a nice message body, and subject
line and I can get those forwarded. Others just come to me and say
"system administrator" and "Undeliverable" with an attachment. For
instance the "view" plane shows this:
Your message did not reach some or all of the intended recipients.
Subject: test
Sent: 11/3/2006 11:50 AM
The following recipient(s) could not be reached:
....etc.etc.
<u>and message options shows this as the header:</u>
Microsoft Mail Internet Headers Version 2.0
From: postmaster@somewhere
To: myemail
Date: Fri, 3 Nov 2006 11:50:12 -0500
....
Message-ID: <[email protected]>
Subject: Delivery Status Notification (Failure)
....etc.etc.
My ideal is that when other people of the company get one of these, it
gets emailed to me automatically (not as an attachment), and is sorted
by a 2nd rule (which works) in my system. For some reason none of my
rules seem to forward the Email. I tried with certain text in the
subject; other rules looked for text in the header etc, and none seem
to work. I'm willing to make some VBA, but I don't know it well enough
and it's easier to make a rule on someone else computer.
I essentially want to take the text I see in the view plane (which I
think is an attachment) and turn it into the message body, which I can
see in "inbox" window and thus I can drag and drop into excel and run
some stuff and pull out the emails and make a pretty list for me to
drop back into access and note as "bad" in our database. So to make a
long story short <u> how do I take an undeliverable email attachment
and turn it into message text</u> like when I forward them individually?