When a user accesses the SQL Database from BCM 2010 and wants to send a Mass E-mail to selected BCM Contacts by performing the below steps:
1. Select Contacts from the BCM Contacts Database
2. In the Ribbon go on Marketing – Mass E-mail
3. Select the content source in the new Mass Email as being Word Mail Merge
4. Select a Word file that is to be used
5. Click on Launch to send the Mass Email
They encounter the following Error Message :"Business Contact Manager for Outlook could not complete your last action or actions. Please try again".
Note : This issue happen with a new database as well.
When you start a Word 2010 Mail merge from BCM 2010, the Office Access Component is being used by BCM as a temporary buffer to store the Information from the SQL Database before using the data in the Word 2010 Application.
When Launching the Activity of Mass Email from BCM 2010 a new Access File is being created under C:\Users\Username\AppData\Local\Microsoft\Business Contact Manager, as you can see below. If BCM does not find the component, then this indicates that wither the Microsoft Office Access Component is not registered or missing.
We were able to resolve the issue by downloading and installing the Microsoft Access Database Engine 2010 Redistributable
Below is the Excerpt from the BCM Log files :
[E] [11:32:31.5005373]BCMRes:The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
[E] [11:32:31.5005373]BCMRes: at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at Microsoft.BusinessSolutions.eCRM.OutlookAddIn.CSUtils.CampaignWrapper.ExportMailMergeRecipients(String RecipientListName, MailMergeApplicationEnum App)
at Microsoft.BusinessSolutions.eCRM.OutlookAddIn.CSUtils.CampaignWrapper.MailMergeWithUI(MailMergeApplicationEnum app, MailMergeDestinationEnum dest, String RecipientListName, Boolean IsLaunch)
at Microsoft.BusinessSolutions.eCRM.OutlookAddIn.CSUtils.MarketingInspectorBase_General.OpenContentDocument(String recipientListName)
at Microsoft.BusinessSolutions.eCRM.OutlookAddIn.CSUtils.MarketingMailMergeBase_General.CurrentItem_NewDocumentCreated(String contentFile)
Additional Information on the Microsoft Access Database Engine 2010 Redistributable
This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
Thanks & Regards