One Click Import of Outlook Email into Access

G

Gino

Question:
Is there a way to set up a one click import from Outlook?
_____________________________________

Background:
I programmatically import certain formatted eMail messages into Access 2003
from a specific Outlook folder. I then parse the data and populate all fields
in an Access Table.

To initiate that, I created a button in Access to start the process with a
"DoCmd.RunCommand.acCmdImport". The Import dialog box opens, I choose Outlook
as my file type and proceed with all sequential steps until I reach the
Outlook folder I need.

This is simple enough but, for a client, I would like to instruct Access to
fetch the messages directly from the specific Outlook folder without each
time having to drill down step by step into "Personal
Folders/Inbox/Events/Volunteers...." and then having to continue with the
selection of an existing Access Table, etc. etc.

I know that when importing Text file type into Access it is possible to set
a "specification" which remembers all these details so that a single click,
performs the entire sequence. Is there anything similar for Outlook file
types?

Inputs from this estimeed community are very much appreciated.
Thank you
 

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