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.
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:
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.
http://msdn.microsoft.com/en-us/library/aa155434%28v=office.10%29.aspx