We help IT Professionals succeed at work.
Get Started

Accessing Outlook eMail content via ADO

AndyBarrow
AndyBarrow asked
on
672 Views
Last Modified: 2012-08-13
Using Delphi 2005 Pro and Access 2000 (v9.0.0.2711) 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]
---Calendar
---Contacts
---Deleted Items
---Inbox
Personal Folders
---Contacts
---Deleted Items
---Inbox

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...
"PROVIDER=Microsoft.Jet.OLEDB.4.0;OUTLOOK 9.0;MAPILEVEL=;DATABASE=C:\Temp;TABLETYPE=0;"
...connects successfully to the Outlook data and when enumerating available table names returns...

Personal Folders
Personal Folders1

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.





Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE