Solved

Can I have an email automatically import into access?

Posted on 2011-09-14
3
198 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
Comment Utility
<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
Comment Utility
Thanks for pointing me in the right direction.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
OK
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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

9 Experts available now in Live!

Get 1:1 Help Now