How to get property details of Outlook "Global Address List" By Alias name From Excel

[npravee]

[h=2]Hi ALL,[/h]

I have list of Alias name in excel in Column A from range A2:XXX how do i get the details of contacts example "department"
from the global Address List.

Request all of you kindly help me in getting this done, it will simplify my work 50%.

Thanks in advance.

Praveen.N​

 

[npravee]

Can anyone please help me

 

[HenkDePoema]

This is an old topic, but someone still might find the answer helpful!
I found it here, it does exactly what you need: Retrieve Outlook Address Book Data Using Custom Excel VBA Function