Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
AK
New Member
Posts: 24
Registered: ‎05-20-2011

Mail Merge error - "choose table"

[ Edited ]

Sometimes slx users see error message (something like this - see http://www.infotecs.ru/_ak/MailMergeFailBarkanVVisAdminCropped.png ) during Mail Merge.

 

If they press 'OK' - mail merge finished successfully, but this annoing popup make some hurt to everyone.

 

How to fix this bug?

 

 

PS: About enviroment. SLX 7.5.0.1484 runnig on Windows Server 2008 R2 (Terminal users), MS Office 2007.

Employee
Posts: 314
Registered: ‎05-19-2009

Re: Mail Merge error - "choose table"

Can you translate the name of the box that is in Russian?

AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Mail Merge error - "choose table"

sure. Box title is "Table: choose".

Employee
Posts: 314
Registered: ‎05-19-2009

Re: Mail Merge error - "choose table"

Ok, well this doesn't fit any Defects I can find, nor is it something I've seen before.

At this point you should start looking for a pattern:

Certain Users
Certain Templates

Is there anything in Event viewer? You could run SLX Profiler and see if that's throwing up any errors which might help.

Also worth noting that Windows 2008 R2 wasn't qualified until 7.5.2 therefore you're on an unsupported platform which might be contributing.
Employee
Posts: 629
Registered: ‎04-24-2009

Re: Mail Merge error - "choose table"

It looks like the SQL statment we pass to Word's MailMerge.OpenDataSource() method is not being understood in order to open the Microsoft.Jet.OLEDB.4.0 database connection. Is this an x64 box?

 

Try adding the following to the registry:

 

Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\SalesLogix\MailMerge] "DataSourceSQLStatement"="SELECT * FROM `SLXMAILMERGE` WHERE (`SKIP` = 'F') ORDER BY `POSITION`" 

 The default value, the one that would be failing (if this registry value is undefined) is:

 

Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\SalesLogix\MailMerge] "DataSourceSQLStatement"="SELECT * FROM [SLXMAILMERGE] WHERE ([SKIP] = 'F') ORDER BY [POSITION]" 

It could be that the opening and closing brackets are being interpreted differently. 

 

Thanks

 

Mike

 

Employee
Posts: 629
Registered: ‎04-24-2009

Re: Mail Merge error - "choose table"

Just checking if the proposed fix worked or if a workaround was found.

 

Thanks

 

Mike

AK
New Member
Posts: 24
Registered: ‎05-20-2011

Re: Mail Merge error - "choose table"

mcessna, yeap, an workaround was founded: reinstalling MS Office.
Employee
Posts: 629
Registered: ‎04-24-2009

Re: Mail Merge error - "choose table"

Glad you got it working!

 

Thanks

 

Mike