0

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?

Metabinary
  • 171
  • 1
  • 2
  • 11

1 Answers1

1

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).

Dmitry Streblechenko
  • 62,942
  • 4
  • 53
  • 78