Automate importing Exchange data to new table

Phantek

Registered User.
Local time
Today, 10:21
Joined
Jun 14, 2011
Messages
12
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!
 
Instead of sending the results via email could you just save them straight into an Access db?
 
Sadly, no. The data is coming in from individuals off-site who only have access to the web page on which the form is located. As it is, they have been manually emailing it in and then we have been manually putting it into the database, but the objective here is to save time, and make a more user-friendly experience for the individuals that are submitting the data.
 
I don't have any experience importing from emails but if you can link the file as a table then you could use an append query to add the data to your table with the autonumber. This could be automated quite easily with VBA on a button.

Just link the table, create your append query and use the following code on a button:

Code:
    DoCmd.Hourglass True
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "APPEND QUERY NAME HERE"
    DoCmd.SetWarnings True
    DoCmd.Hourglass False
 
Thanks James, your advice got me on the right track.

I ended up with using a linked table. I then automated the process of creating a new table with an autonumber, and appending the Body field to the autonumber - it works great!

Thanks again!
 

Users who are viewing this thread

Back
Top Bottom