Extrating data from E- Forms

[Groundrush]

Any idea how to go about extracting data from emails & importing into access?

The company I work for is going for a web based e-form type method for logging jobs instead of a help desk taking phone calls & manually inputting job records
I am trying to avoid unnecessary duplication of work as the caller will send a job request with all the info required but then the help desk will have to retype out the same info into the database.

We do not have SQL installed or any web based databases just the standard front & back end on the server with each user having a front end on their PC
The e-Forms will be created on a local government intranet system that I do not have access to but I may be able to instruct what fields are required.

I'm looking for a simple way of somehow copy & pasting the data required

If anyone has any suggestions, info on pros & cons I would be most grateful

thanks

 

[Moniker]

What you are looking to do is use an Outlook Object from within Access. While you cannot directly read emails from within Access (at least I don't think you can), you can take the contents of an email, perform a "SaveAs" on it, save it as plain text, and then read that text file to get your data.

It's sort of a long-winded way to go about it, but to at least see how to make the application connection and then the message specific connections, search this forum for "OLApp". I know I left an example of it in here at some point.

 

[Groundrush]

What you are looking to do is use an Outlook Object from within Access. While you cannot directly read emails from within Access (at least I don't think you can), you can take the contents of an email, perform a "SaveAs" on it, save it as plain text, and then read that text file to get your data.

It's sort of a long-winded way to go about it, but to at least see how to make the application connection and then the message specific connections, search this forum for "OLApp". I know I left an example of it in here at some point.

Thanks for your reply


To make matters worse the data will be an attatchemt rather than the info in the email body.

 

[Moniker]

Attachments are easier to deal with actually. Look into the Outlook Object's methos and properties and you'll see what I mean.