I have setup a system that allows users to fill out an online form, with the results being submitted via email to Outlook. I then use the Access "Get External Data" to "Import" the form emails to a new table using the default format, but with an added Primary Key.
The result is that I can scroll through the data using a form of mine which parases the emails.
Is there a way to automate the "Get External Data" to Import Exchange emails from a specified Outlook directory? I wish to be able to push a button, and have all of the "Get External Data" steps be automatically completed, so the user just sees the data as the end result.
Any ideas on how to do this? I am using Office 2003.
Extra details:
- I cannot use linked tables, as my code requires a primary key
- I recognize that this entire process would be easier with something like PHP and mySQL, but the company servers do not have these available.
Thanks!
The result is that I can scroll through the data using a form of mine which parases the emails.
Is there a way to automate the "Get External Data" to Import Exchange emails from a specified Outlook directory? I wish to be able to push a button, and have all of the "Get External Data" steps be automatically completed, so the user just sees the data as the end result.
Any ideas on how to do this? I am using Office 2003.
Extra details:
- I cannot use linked tables, as my code requires a primary key
- I recognize that this entire process would be easier with something like PHP and mySQL, but the company servers do not have these available.
Thanks!