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
Solved

Can I have an email automatically import into access?

Posted on 2011-09-14
3
208 Views
Last Modified: 2012-05-12
Dear anyone,
I know very little to actually having no prior knowledge of access or how to do this.
But anyway,  I have a client who has an Access DB that can directly email a customer complaint form to a supervisor.  They want to be able to have the supervisors resonse to that email flow back into the Access DB complaint form, thus creating a "trail" of the customer complaint inside Access.  Is this possible?  And, if so, how?
0
Comment
Question by:marnoble
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 36539307
<I have a client who has an Access DB that can directly email a customer complaint form to a supervisor.>
You will have to first clearly explain how this system works...

But in a general sense, sure, ...in Access 2007 or higher you can use the "Email Data Collection" functionality:

http://office.microsoft.com/en-us/access-help/demo-collect-data-in-access-2007-by-using-e-mail-HA010252713.aspx
http://video.google.com/videoplay?docid=1458200794441986235

Obviously you will have to have the proper links from Complaints to Responses in place...

JeffCoachman
0
 

Author Closing Comment

by:marnoble
ID: 36574042
Thanks for pointing me in the right direction.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36575089
OK
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.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

860 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