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"
??

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

--
Regards,
Tom Ogilvy



"E Anton" wrote:

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"
??