Hi Team,
I am in need of a macro which should take the alias which is after the backward slash that is a123456 and it should look it up in Outlook Global address list and paste their name and email address in their respective cell.
Below is an example just for one instance:
Creator
abcd\a123456
should show up like
Creator
Tom Johnson<[email protected]> and this has to be done for the rest of the rows with different alias under creator as shown in attachment
Kind Regards,
4gurus
Bookmarks