Question Emails - extracting data to Access

[matthewnsarah07]

I have a holiday request database which uses a Request Form in the front end for staff to enter their request and the tables held on a server for the back end.

However, one of our locations currently has a very poor (rural) internet connections and sometimes the request form cannot load properly.

When this happens I would like to use a Outlook template for instance that they could use to send all the required details:

StaffName, ManagerName, DateFrom, DateTo

And when it is received in the main office could then be easily imported as a new request.

How would I go about setting this system up?

Thanks for your help

 

[Call_Me_Sam]

When this happens I would like to use a Outlook template for instance that they could use to send all the required details:

StaffName, ManagerName, DateFrom, DateTo

And when it is received in the main office could then be easily imported as a new request.

How would I go about setting this system up?

Thanks for your help

Have you tried building an interface that would allow Access to export the data as an XML file. The file could be attacthed and emailed so your main office could simply import the xml into the database. The fields should line up correct, making your life easier. note i have only tried the receive file and import element. but i believe it to be possible.