BFanguy
asked on
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.
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.
ASKER
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
I wonder if I could set up an email address that automatically would import the data from word when something comes in.