I have a sheet with the person's 1st name in Column A & Last name in Column B - I would like a button with a code that will look at their names in Outlook global list and pull their email address and put it in column C on the same page. When I click on the button, I would like for it to update any new ones that may be there or overwrite the ones that are gone. Is this possible - any help would be greatly appreciated!
Bookmarks