retrieving the contents from an address book per se is relatively straightforward, eg below (run from XL) would pull the contents of my Contacts address list into my spreadsheet ... unfortunately I'm not on an exchange and don't thus have access to a Global Address List so I'm not sure how easy it is to alter the below ... ie if you can just change the Select Case criteria to be the name of the Global Address List... in the example I'm obviously only returning the actual names and addresses but obviously this could be extended to return multiple fields as you request.
I hope this points you in the right direction if nothing more...
EDIT: Leith - sorry not meant to be treading on toes - your post wasn't there when I began composing mine... to reiterate mine may not even work for GALs.
Bookmarks