Solved

When I try to link to Outlook in Access 2010. Nothing happens. No dialog box comes up for me to select emails

Posted on 2014-11-06
8
257 Views
Last Modified: 2014-11-14
When choosing Outlook to link or import data/ choose link/ dialog box closes/ nothing happens
No objects to choose and no error message
0
Comment
Question by:DAveB_LDS
  • 3
  • 3
8 Comments
 
LVL 31

Expert Comment

by:Helen_Feddema
Comment Utility
What technique are you using?  If it is the built-in feature, it is very limited (even when it works).  You may need to use VBA instead.  To see what happened, I tried to link an Outlook email folder to Access, and got the attached error message.  I checked the list of Add-ins, and no disabled ones were listed.

If you want to try VBA, let me know what you are trying to do, and I will post some code.
Wizard-error.jpg
0
 

Author Comment

by:DAveB_LDS
Comment Utility
I have a code solution in place that works.
 All I wanted to do was link to the inbox. I successfully linked on another computer.  I can attach other types of files, Excel, text...
0
 
LVL 18

Expert Comment

by:bonjour-aut
Comment Utility
Linking an outlouk folder is done via an Add-In. In standard installation this is not installed. Go to Options >> Add-In's : Look in deactivated Add In's. If nothing is there you might have to reinstall Access and choose the respective installation option.
0
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.

 

Author Comment

by:DAveB_LDS
Comment Utility
Nothing in Add-ins. I did it with VBA code.
0
 
LVL 18

Expert Comment

by:bonjour-aut
Comment Utility
Fine, I prefer VBA myself for this purpose.
Anyway, you could get "missing" Add-Ins installed by running Office setup again and choose desired options in the installer. Of course, this option will be better tu use, if you need real time data in your access application. Otherwise VBA gives you more grip on the data. If you need VBA code to get also at the attachments, i can provide.
0
 

Author Comment

by:DAveB_LDS
Comment Utility
I thought that it would be very simple to link to the Inbox. Actually using VBA was fine and made it easy to move the message to the deleted folder, The other thing that I discovered was that saving the message body as a text file gave me the ability to then reopen it and read each individual line so that I could parse the data.
The other interesting method was the ability to convert the body to "plaintext" dropping HTML coding.
0
 
LVL 18

Accepted Solution

by:
bonjour-aut earned 500 total points
Comment Utility
>>I thought that it would be very simple to link to the Inbox.
As already mentioned, with the Add-In installed it cab be done in a simple way.
>>Actually using VBA was fine and made it easy to move the message to the deleted folder,
Can be done throght VBA, but needs to put the information in a temporary table, so you can select there, which mail to delete
>>The other thing that I discovered was that saving the message body as a text file gave me the ability to then reopen it and read each individual line so that I could parse the data.
if you add the messag body in the temporary file, yes
>>The other interesting method was the ability to convert the body to "plaintext" dropping HTML coding.
yes

so what exactly you would expect as answer to your initial Q?
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Use email signature images to promote corporate certifications and industry awards.
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

744 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

21 Experts available now in Live!

Get 1:1 Help Now