Get user info from AD with VBA

[Dominique Heyler]

Hi,
I,d like to create a Word template that reads current user information (such
as name, addresses, phones, department and so on) from Active Directory. I've
searched the Net without luck for code samples. Do you know where I can find
examples for this kind of solutions?
Best regards,

Dominique

 

[Steve Yandl]

Take a look at
http://www.microsoft.com/technet/scriptcenter/resources/qanda/ad.mspx

The examples are all VBS as opposed to VBA but conversion is very simple.
You might consider doing this from Excel to take advantage of better sorting
and filtering once you retrieve the info but you could certainly set up with
a Word template if you want.

Steve