Access Exchange data from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write an application that will pull email information from our
exchange server for analysis. With a very short suspense.

Specifically, we want to track all messages sent or received, the senders
ID, time sent, recipient(s), Attachment(s), level of importance, etc.

The goal is to be able to extract this data from the Exchange Server and
write it into an Access database so that we can run a number of queries to
determine usage patterns and that kind of thing.

Does anyone know how to do this?
 
AIUI the simplest approach is to enable Message Tracking in Exchange and
link to the text files in which it logs the messages, one file per day.
See the Exchange Server documentation for more.

I'd expect file locking problems if you link to a current log file: so
you may need to make a copy of the file and link to that, or use a
Unix-type 'tail' utility to return a snapshot of the most recent
records.
 
Back
Top