How do I search by user profiles by username?

[Guest]

I'm trying to gather user details such as phone number, department, email
address, etc. and add them to a userform using the windows username as the
search criteria.

What is the best way to go about gathering these user details automatically?
Should I be connecting to the Outlook Global Address List, Network Active
Directory, or are these details available locally like "Application.UserName"
??

 

[Guest]

Yes, you would need to reference the source of the information. If you
maintain it in the registry, then possibly there, but the Global address list
might be the best.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=222