Read Shared Outlook Contact field in Excel

[DoctorG]

Hi,

I wish to retrieve an Outlook Contact field from within Excel. The Contacts
Folder is in a shared Outlook data file. Is this possible? I have written
code in Excel VBA but I have never tried inter-app data exchange.

Thanks in advance.

 

[Dmitry Streblechenko]

Shared Outlook data file as in "a PST file shared by several users" (which
is nto supported)?
Or as in "delegate Exchange mailbox"?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[DoctorG]

Dmitry hi and thanks for answering,

I am working with an Exchange Server. I have been maintaining a Contacts
file in my regular Exchange mailbox and I would like to use it from within an
Excel Application in order to avoid re-entering the same data and having to
maintain two separate instances of the same info.

I have stated a "Shared" Contacts file simply because (a) I am sharing this
Contacts file within the office and (b) the Excel application is shared, so
anyone should be able to retrieve the Contacts info from my Contacts file
whenever they use the Excel app.

Have I answered your question? Can you suggest a solution with this scenario?

 

[Dmitry Streblechenko]

Use Namespace.GetSharedDefaultFolder method to open a Contacts folder from
another mailbox.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-