?
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
?
277 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 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