Solved

Can I have an email automatically import into access?

Posted on 2011-09-14
3
201 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will show you how to use shortcut menus in the Access run-time environment.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

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