The Mail Merge Engine encountered an error and cannot continue

[SLX_User]

Hi all.

I have SLX LAN v7.2.1. When trying to do a mail merge I get the following error:

The Mail Merge Engine encountered an error and cannot continue. There was an error in CreateDataSource(). Error: Class not registered. ErrorCode: -2147221164

I'm testing it for one contact, it's an email template.

Any idea what it can be?

Thank you in advance!

[mcessna]

It is related to the JET database engine not being available. This can be mitigated in other ways, depending on your version of Office. What version of Office are you using? Did you ever solve this?

Thanks

Mike

[SLX_User]

Hi Mike.

I have not been able to solve this issue. We are using Office 2007.

[mcessna]

The Office database connectivity drivers may have not been installed when Office was installed. If they have, and it is still not working, please try the following:

1. Create a REG_SZ value named Provider under: HKEY_CURRENT_USER\Software\SalesLogix\MailMerge

2. Set the Provider value to: Microsoft.ACE.OLEDB.12.0

Example:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\SalesLogix\MailMerge]
"Provider"="Microsoft.ACE.OLEDB.12.0"

Note: the Provider defaults to Microsoft.Jet.OLEDB.4.0 if this registry value does not exist.

You may need to install the "Microsoft Access Database Engine 2010 Redistributable" (in order to make Microsoft.ACE.OLEDB.12.0 avaiable): http://www.microsoft.com/en-us/download/details.aspx?id=13255. This should work for both Office 2007 and 2010; however, the "2007 Office System Driver: Data Connectivity Components" can be downloaded from: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=23734. Both will install the Microsoft.ACE.OLEDB.12.0. There may also be updates to install after the primary install.

Thanks

Mike

[Paul_Barnes]

We have a customer who is receiving the same issue

SLX8.0 (all patched to latest and greatest)

Office 2010

IE 10

Full error they are getting is

The Mail Merge Engine encountered an error and cannot continue.

Word did not save the document

Any ideas?

[mcessna]

I know the previous post is old, but for the sake of anyone else please see:

http://support.microsoft.com/kb/2479169

Thanks

Mike