Getting data from Outlook

[bruce]

Hello

Ive just completed an article on picking up data from the outlook
global address list and populating and Excel sheet. See below for
details and example.

http://ramblings.mcpher.com/Home/excelquirks/data-from-outlook

However, I spent a huge amount of time trying to figure out the schema
parameters for .PropertyAccessor.GetProperty() , and in the end never
found a definitive list - it was pretty much a little bit of
information here and there on various forums.


Does anyone know where to find this?

Bruce

[bruce]

Thanks to Richard Clark who provided this link to a 3rd party .Net add-
in abstraction tool for Outlook.

http://www.add-in-express.com/products/mapi-store-events.php

I'm still looking for the mapping of the exchangeuser.details method
to underlying properties, if anyone has it

regards
bruce

[poko...@gmail.com]

Hi Bruce,

I tried to use your Excel downloaded form for tests, but it returns with Error (translated) : Execution Time Error (8004010f): 

Object not found.

Module outlookData :

Set od = New cOutlookAddressbook

        If od.Init(oa, sBook) Then

A am using Office 2010 portuguese (Brazil) Version.
Can you help me on this, or what  i have to change ?

Thanks.

[bruce]

I dont know much about how this is represented in non- English configurations. However , I notice this in the example application .. is your global address list called something else

Const sBook = "Global Address List"