Using Delphi 2005 Pro and Access 2000 (v184.108.40.20611) located on a stand-alone PC, not an Exchange Server configuration.
I am trying to access the body text of email from Outlook using a TADOTable / TADOConnection but am having difficulty getting visibility of the right data. Firstly, my Outlook Structure looks a bit like this (abridged version).
Outlook Today - [Personal Folders]
I have created a dummy 'Inbox' folder under "Personal Folders" for the purposes of testing here, it was not there by default.
The following connection string...
...connects successfully to the Outlook data and when enumerating available table names returns...
On interrogation of the Table "Personal Folders" I can see "Contacts" and "Inbox" as above but this is just the test inbox I have created. All my eMail is on the inbox under "Outlook Today - [Personal Folders]". Attempting to access "Personal Folders1" results in a "MAPI Folder or Address Book not found" error. I have also tried to access the same folder via the New | Linked table | Access() option in MS-Access but again it just says "The wizard cant access the folder" even though folder is listed. Anyone have any pointers as to how I can see the data under "Outlook Today - [Personal Folders]"????
Many thanks in advance.