Problem with 'Create E-mail' function in Access 2007

[markhp]

When trying to use the 'Create E-mail' function in Access 2007, I receive the
following message:

"The Microsoft Office Access Outlook Add-in is disabled in Microsoft Office
Outlook 2007. To collect data by using e-mail messages in Microsoft Office
Access 2007, verify that this add-in is installed and enabled from within
Office Outlook 2007."

I've been into Outlook's Trust Center, and the Add-In in question isn't
listed. When going to "Manage COM Add-ins," I select the appropriate .dll
(accolk.dll), but this does not get added to the "Add-Ins available" list of
COM Add-ins.

I'm using 2007 SP2 with all patches applied. The Access Outlook Data
Collection Add-In version is 12.0.6415.1000.

 

[Ken Slovak - [MVP - Outlook]]

Have you checked the Disabled Items list in the Trust Center? You can also
see it from Help, Disabled Items.

If an addin gets disabled it's due to it causing a crash or not handling all
exceptions. Even if you enable it the odds of it becoming disabled
again are high unless whatever caused the original problem doesn't happen
again.

 

[markhp]

Yes, I've checked the Disabled Items list in the Trust Center, but the Add-In
in question isn't even listed as disabled. I'm also unable to add it through
the Add-Ins Add... functionality - when I choose the appropriate file, it
doesn't appear in the COM Add-Ins list.

 

[Ken Slovak - [MVP - Outlook]]

That Add function doesn't really do too much for you. Whether or not an
addin is listed in the COM Add-Ins dialog depends on whether it's registered
correctly. All Outlook addins must be registered as addins in either HKLM
(admin installation) or HKCU (per user installation) at
\Software\Microsoft\Office\Outlook\Addins. Under those keys are the addins.
Each addin must have at least 2 values, usually 4:

FriendlyName REG_SZ friendly name of the addin
Description REG_SZ description of the addin
LoadBehavior DWORD 3 to load on startup, 2 to load on demand (from the
COM addins dialog), 0 to not show up at all.

CommandLineSafe DWORD 0 (optional)

When an addin is disabled by Outlook LoadBehavior is set to 2 and a hash and
key for that addin is added at
HKCU\Software\Microsoft\Office\11.0\Outlook\Resiliency, where 11.0 is for
Outlook 2003 and 12.0 would be for Outlook 2007.

If the addin is not registered then it would never appear in the COM addins
dialog.

 

[markhp]

Thanks for this information. I've managed to get round the problem by
logging on as an Administrator, then I opened the database in question to
start the data collection process. I then closed Access, and went in to the
appropriate part of the registry and exported the key, so I was able to
import the key back into my specific account.

Many thanks for all your help, Ken!