email data - import into access form

[keiserc]

I have a detailed access form. Client info & order detail stuff. I need to have salesmen in the field be able to e-mail me data which can then be imported into access - which will handle the printing & record keeping.

What is the best vehicle for the salesmen to enter & email their data from? easily imported? Can I build an excel or word document with "fields" for them to fill out?

I'm looking into getting (and building) an access run time.(too expensive to give full program to complete sales staff) If we go this route, will this allow them to fill out the actual form and then email it in to the office? will it be easily imported into the main database?

I have already set up a cmd button to email data from the form (thank you tek-tips, nathan1967) this fills in the body of the email with the data, formatless, now I don't know how to import it back into access?

I appreciate all the help from everyone at tek-tips. I've learned a lot, thank you "in the know" folks, for taking the time to help those of us "in need".

 

[DougP]

What is the app you are using in the field? if not Access

DougP, MCP, A+

 

[PHV]

If you use the DoCmd.SendObject method, you may consider to play with the OutputFormat argument to send a spreadsheet, i.e. OutputFormat:=acFormatXLS

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884