VBA search specific user in Outlook GAL

642 Views Asked by At

I want to search a specific user (e.g. Clinton, Bill) in the GAL and get all the information like e-mail address, phone, street etc. in Excel.

How do I do that in VBA?

1

There are 1 best solutions below

0
On

Call Application.Session.CreateRecipient passing the name as a string, then call Recipient.Resolve on the returned Recipient object. Use the Recipient.AddressEntry property (e.g. you can call AddressEntry.GetExchangeUser).