Outside Sales fills out a Form, emails to home office and it creates a record in an access database

Looking for the easiest way for our outside sales personell (who don't sign in to our WAN) to be able to fill out a prebuilt form (sales lead) and send it to an email address that pulls the data from the form into access 2003.
BFanguyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
Yes that would be easiest. I expect that there are several examples on this site (I've probably supplied one or two myself), but here is a Microsoft article:

http://msdn.microsoft.com/en-us/library/aa155434%28v=office.10%29.aspx

0
 
GrahamSkanRetiredCommented:
By prebuilt, do you man that it already exists? If not, you could create a Word Forms document and use a VBA procedure to save the data in the editable fields to your database.
0
 
BFanguyAuthor Commented:
I was thinking of using a word form,  infopath form or pdf form - something to capture the data,  then it would get emailed to an inside salesperson and they could import the data to an access database (using vb or something)
0
 
BFanguyAuthor Commented:
thanks,  this will work

I wonder if I could set up an email address that automatically would import the data from word when something comes in.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.