Microsoft Access OLE DB — Microsoft Outlook

From database24
Jump to navigation Jump to search

Microsoft Exchange

It is possible to query Exchange / Outlook folders and address books as follows:

SELECT *
  FROM Inbox 
    IN 'c:\temp\'[Exchange 4.0;MAPILEVEL=Account - Paul Stevens|;TABLETYPE=0;];

where Account - Paul Stevens has to be replaced by the exact name of the Inbox followed by the pipe (|). This works for Contacts, Calendar and other folders too.