Retriving a Failed Recipient' email address

[Art]

I am just wondering if there is a small VBA routine for Outlook 2003 that
will help me to automatically "reterive" (saving in it on an EXCEL file) a
Failed Recipient' email address. The bounced emails will be "manually"
re-located on a separate Inbox' folder. Thank you.

 

[Ken Slovak - [MVP - Outlook]]

Usually the body of the NDR will have the original target address, but the
format of that or even if it's there at all depends totally on the server
returning the NDR. So it's not constant or even very predictable. You'd have
to aggregate a bunch of NDR's to see what you get from them.

Some may be "official" NDR's which would be MessageClass ==
"REPORT.IPM.Note.NDR. Other cases will be just standard email MessageClass
== "IPM.Note". So you can't even rely on any ReportItem properties being
there.

The From address of the sender of the NDR won't help because it comes from
the server which has its own address it uses for NDR's.

So about all you can do is try to come up with some algorithm to extract the
many possible ways the address is there or use manual intervention.