Can't export to email from Access 2010


I have a user who cannot export from Access 2010 to email. The option under the External Data tab is grayed out no matter what file he opens or creates. All other options are still available to him and all other Office programs can export to email. I have tried repairing the Office installation and a full re-install with no change. User is running on Windows XP and is trying to export to Lotus Notes 8.5.3.
Who is Participating?
Pancake_EffectConnect With a Mentor Author Commented:
So I figured it out.

Apparently Access needed certain registry files from Outlook to activate the Email button under the External Data tab. So I initially installed Outlook and tried to export to email but Access decided it wanted to use Outlook instead of Lotus Notes no matter what I changed to try and convince it to use Lotus Notes as the default email program. After a little more digging I came across a registry edit that activated the option under the External Data tab without having to install Outlook:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Messaging Subsystem]

So I ran this as a .reg file. From there Access said that it couldn't find an email client when I clicked on the Email button. So I went into the registry editor and located HKEY_LOCAL_MACHINE\SOFTWARE\Clients\Mail and changed the default value to "Lotus Notes". From there all exporting worked perfectly.
Hi there Pancake_Effect,,

Is he/ She the only user having this problem ?
Is there a way to make the user try to export from Access2010  to Lotus notes8.5.3 on another PC and check ?
I would like to ask if this is the first time you are doing this exporting ? have you ever done this activity ?

Best Wishes
Pancake_EffectAuthor Commented:
I currently have both Access 2010 and Lotus Notes 8.5.3 on my machine and I can use the feature. I am running Windows 7 however. I am setting up a spare XP machine now to test on.
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

One more thing to mention over here ,, could you make sure that the user is and Administrator on the machine ???
This could be one of the causes ??
Pancake_EffectAuthor Commented:
Took a look and yeah he is.
Pancake_EffectAuthor Commented:
I tried setting up Lotus 8.5.3 and Access 2010 on several other XP machines I have around I cant use the feature there either. Not sure if this means it's an XP related issue or not.
What I  can see here is ,,, if this feature works on W7 can't you provide the user with a W7 PC ?
Pancake_EffectAuthor Commented:
After trial and error I came up with this solution and it worked for me.
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.

All Courses

From novice to tech pro — start learning today.