Hi All
I have this problem I’ve been working on for far too long.
I need to extract the E-Mail addresses from the “To” line of an E-Mail.
I’ve been using:
However, if the E-Mail is in my contact list, the “To” line convert the E-Mail address to the name of the contact – and when I try extract the E-Mail I only get the contact name.
See picture: 6-27-2013 9-44-17 AM.png
Additional info:- I have been programming VBA for Excel for about a year now.
- We am using Office 360 as our mail provider
- There are not always a logic in the E-Mailing naming convention. Therefore I can’t use makeEmailFunction(“Carlsson, Martin”) => [email protected]
- I am running 2013 – but the macro should work on 2007 and 2010 as well. Therefore, if your solution only covers one of versions, it will be cool as well.
- I need the E-Mail address to be put in: "ReplyRecipients.Add"
Bookmarks