Solved

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

Posted on 2011-03-16
4
270 Views
Last Modified: 2012-05-11
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
Comment
Question by:BFanguy
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 35151540
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
 

Author Comment

by:BFanguy
ID: 35151560
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
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 35151609
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
 

Author Comment

by:BFanguy
ID: 35151698
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now