[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
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
Medium Priority
?
278 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

650 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