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

When choosing Outlook to link or import data/ choose link/ dialog box closes/ nothing happens
No objects to choose and no error message
DAveB_LDSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Helen FeddemaCommented:
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
DAveB_LDSAuthor Commented:
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
bonjour-autCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DAveB_LDSAuthor Commented:
Nothing in Add-ins. I did it with VBA code.
0
bonjour-autCommented:
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
DAveB_LDSAuthor Commented:
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
bonjour-autCommented:
>>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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.