GAL Hierarchy export vba

[nitrorat]

I am in need to export the hierarchy of a contact. Basically a manager contact will have a list of contacts (direct report) listed via the organization tab. any help would be appreciated and thanks...

[SamT]

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

[nitrorat]

I get a compile error: user defined type not defined for objSession As MAPI.Session... not sure what this means

[SamT]

Did you also try late binding?

[skatonni]

I am in need to export the hierarchy of a contact. Basically a manager contact will have a list of contacts (direct report) listed via the organization tab. any help would be appreciated and thanks...

I cannot, but if you can install CDO or Redemption try pulling this together:

"The Outlook ... object model does not provide programmatic access to the nodes of the hierarchical address book." http://msdn.microsoft.com/en-us/library/cc513843(v=office.12).aspx

"CDO 1.21 (optional installation for Outlook 2000 and later) or Extended MAPI (C++ or Delphi only) or Redemption (www.dimastr.com/redemption (http://www.dimastr.com/redemption))." http://www.pcreview.co.uk/forums/get-all-global-address-book-info-t1841195.html

CDO info http://www.outlookcode.com/article.aspx?id=20

"Read Direct Reports and Distribution List Membership" http://www.cdolive.com/cdo5p2.htm

"Debug.Print "-- The following users report to " & AddressEntry.Name
for each AE in AddressEntry.Reports
Debug.Print AE.Name
Next"
http://www.dimastr.com/redemption/RDOAddressEntry.htm