Need help in pulling out an Exchange Sender's email address in excel

[nasin123]

Hey everyone,

I am trying to pull email data from outlook to a spreadsheet using below code and this code is working fine. Only issue is that email address is coming in a weird format..

like this : /O=EXCHANGELABS/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF3423SPDLT)/CN=RECIPIENTS/CN=B84F931A97994560ADA287ED4C4BD5- XX


Can someone please help with this so that i can get the email address exported in the desired format (EG: [email protected])

Please Login or Register  to view this content.

[6StringJazzer]

I use this in my own code, so it should work for you:

Please Login or Register  to view this content.

The case that will give you a problem is if it is an old email from a person who was in your Exchange system but is not anymore. You'll get a blank email address.

[nasin123]

Thanks So much. This works.