|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
March 8th 09, 10:38 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Read Shared Outlook Contact field in Excel
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. 
|
|
#2
March 8th 09, 05:53 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Read Shared Outlook Contact field in Excel
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" wrote in message ... 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.
|
|
#3
March 8th 09, 07:40 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Read Shared Outlook Contact field in Excel
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" wrote: 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" wrote in message ... 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.
|
|
#4
March 10th 09, 07:08 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Read Shared Outlook Contact field in Excel
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 - "DoctorG" wrote in message ... 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" wrote: 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" wrote in message ... 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.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Read Outlook Shared Contact field in Excel | DoctorG | Outlook - Using Contacts | 1 | March 6th 09 09:23 PM |
| Field NOTES in CONTACT is shorted by export to excel | Vaso | Outlook - Using Contacts | 3 | March 17th 08 05:35 PM |
| excel import into outlook to creates new contact per field rather | Scholz_Outlook_import | Outlook - Using Contacts | 6 | December 17th 07 04:31 PM |
| Add field when importing from Excel into Outlook | LBlake | Outlook - Using Contacts | 3 | June 6th 07 07:10 PM |
| import Excel to Outlook, each field importing as separate contact | ozbrandi | Outlook - Using Contacts | 4 | February 28th 06 05:49 PM |
Hybrid Mode
