PDA

View Full Version : Outlook 2013 Global Address List Alias to Excel Document



ShiftTab
05-08-2017, 04:39 PM
Issue: I am finding myself doing repetitive actions at work and I'm trying to find a solution to speed up this process as I do this daily. I am unable to install Outlook Spy or Office Spy. I am not very code savvy or VBA savvy at all.

Current Workflow: I search for a user's alias from Outlook 2013 in the Global Address list using the first and last name of a user. Once finding the name, I right click the name to get to properties to copy and paste their alias into excel.
Question: Is there a way to automatically do this from excel by using a macro? If put in the first name in Column A and Last in Column B, can a macro produce the Alias in Column C from the Outlook Global Address List? If so, how would I go about doing this?

I know I need to create an excel document that is macro enabled. Insert a module and save it and run it, but all of the examples I've found online have some kind of exception error. I am unsure how to make this work.
Thank you all for taking the time to read my request!