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
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