Read Data from Exchange Server

[Thomas Kroljic]

All,
Can I read data (emails in various folders such as InBox) from an
Exchange Server database via VBA from within an Access form?
I currently have an Access application that my users use to enter new
contacts into. One of the fields on this form is an email text field where
they can enter the persons email address if they have one. I know how to
send email out from my Access form. What I would like to do is to be able to
read (query) the Exchange Database for a specific mailbox to see if the
contact responded back. Is this possible? Or should I be looking at using
the Outlook reference model?

Thank you,
Thomas Kroljic

 

[Guest]

Access has an Exchange/Outlook IISAM: you can link
to Exchange/Outlook as a table. Security warnings and
restrictions can be a problem: I don't know if this feature
has been dropped.

Using code, you can also connect to Outlook, or to a
CDO object.

There are many ways, but those are the most common.

(david)

 

[Thomas Kroljic]

David,
Thanks for your thoughts. I had used the Outlook reference in the past but
thought that maybe there was another way that I could directly read the
Exchange database without going through the Outlook model.
I'll take a look at the CDO object model. I haven't use this in the past,
but maybe it'll work for me in the future.

Thanks,
Thomas