How to get ALL Global Address Book Info

[Guest]

Hello,

For each entry in the Global Address Book, in the Properties of each
address, there is the General Tab, Organization Tab, Phone/Notes Tab, Member
Of Tab, E-mail Address Tab & with in each Tab there are many fields.

How can I get ALL thisOutlook Address Book info into an Excel
Worksheet or an Access Table ?

Can this be done with VBA code or is their some way to export all
that info directly to Excel or Access ?

Any help would be greatly appreciated.

Thank you,
Jeff

 

[Ken Slovak - [MVP - Outlook]]

To get the actual details you need to use CDO 1.21 (optional installation
for Outlook 2000 and later) or Extended MAPI (C++ or Delphi only) or
Redemption (www.dimastr.com/redemption). The information is in various MAPI
properties and isn't exposed directly in the Outlook object model.

The best way to see which properties you want and what their property tags
are is to download OutlookSpy (www.dimastr.com) and use the AddressBook
button. If you navigate the hierarchy of AddressBooks to the GAL you can
open one of the AddressEntry objects and look at the properties and data in
them.

www.cdolive.com/cdo10.htm has a list of many property tags, documented and
undocumented, for an AddressEntry object.