email form for data import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to email a form (word, excel, html, whatever works) to users that they
can input data and i can import it into an access database after they return
it.

the form needs to be as standalone as possible. i can't just use a web-based
input form to dump into a server-resident database because not all users have
web access (can you believe it?). i thought about using a word mail merge
document, but i don't like the idea of having to send a separate input
document and a data file document (can these be tied together somehow--or the
same document?)

i would like my user to just be able to import into access with a minimum of
conversion, etc.

any ideas?
 
Hi Drew,

I'd think in terms of a Word document, protected, with formfields to
constrain user input. Make sure you name each formfield.

When you get it back, it's easy to use Automation to open the document
and iterate through its FormFields collection to get the values, then
use recordset operations or single-record append queries to put them
into the Access tables.
 
Back
Top