• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

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.
0
BFanguy
Asked:
BFanguy
  • 2
  • 2
1 Solution
 
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
 
GrahamSkanRetiredCommented:
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now