I have a list in Excel with some of our company user's aliases. e.g. I log into COMPANY\user in windows, I have the user alias in excel in a column, userA, userB, userC, etc...
In column B, I'd like to resolve the full name from Outlook/Exchange, from the "Display Field" (double-click a name in Outlook and the full name of that person is in this field).
In column C, I'd like the field "Title"
In column D, I'd like the field "Office"
I have no idea where to start, I am hoping it would be possible through macros?
Many, Many thanks - This will save me a massive amount of work (I have 700 users in the list!)