Outlook database

J

Jonas

Hi

does someone know how I can access the internal Outlook db with ADO or DAO.
I want to export my contacts with a macro, so how can I do a "SELECT * FROM
OutlookContacts" ?

I would highly appreciate any idea or web reference !

Thanks.

Regards,

Jonas
 
K

Ken Slovak - [MVP - Outlook]

Using ADO with the Outlook IISAM driver only makes available 44 fields
from a contact item and the names of the fields are different in many
cases than the Outlook property names. You'd be far better off using
the Outlook object model.

For information about accessing Outlook data using database type
methods see http://www.slipstick.com/dev/database.htm

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm
 
J

Jonas

Thanks !

Jonas

Ken Slovak - said:
Using ADO with the Outlook IISAM driver only makes available 44 fields
from a contact item and the names of the fields are different in many
cases than the Outlook property names. You'd be far better off using
the Outlook object model.

For information about accessing Outlook data using database type
methods see http://www.slipstick.com/dev/database.htm

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm


Jonas said:
Hi

does someone know how I can access the internal Outlook db with ADO or DAO.
I want to export my contacts with a macro, so how can I do a "SELECT * FROM
OutlookContacts" ?

I would highly appreciate any idea or web reference !

Thanks.

Regards,

Jonas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top