Personal info from Global Address book

[wnazzaro]

I am trying to pull information into Excel from our corporate Global Address book. However, I've only had success with Name and Manager and a few others but not Phone Number or Address.

I am pretty sure this is possible with Contacts, but I don't want to have to pull our Global Address Book into my Contacts just to do this (seems like a bigger hassel than it's worth).

Can anybody help?

Thanks,
Bill

[Rico]

Try this:

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

Regards Rico

[wnazzaro]

Thanks for locating that. It works well. Now I just need to edit to search for a single user instead of pulling all.

Kind regards,
Bill

[rabaker]

I am a dark green newbie who is also working with the Outlook GAL. THis code works well however I wanted to post it to more than one sheet since I have a large GAL to work with....Could someone help me adjust this code to extract the data to multiple sheets instead of stopping at the end of the first sheet.

Thanks in advance,

Rich:dunno