Microsoft KB Archive/112317

{| = BUG: "Field Count Mismatch" Error with Word 2.0 Mail Merge =
 * width="100%"|

ID: Q112317

The information in this article applies to:


 * Microsoft FoxPro for Windows, version 2.6

SYMPTOMS
When you are using the Mail Merge Wizard with Microsoft Word 2.0 for Windows, you get the following error message from Word:

Field count mismatch.

CAUSE
If a field in the database contains a quoted string, a merge to Word 2.0 for Windows causes Word to display a field length error on the record containing the quotation marks. For example, if the COMPANY field contains the words

Gadgets "4" You Word 2.0 will stop the merge and generate a "Field count mismatch" error for this record. This problem occurs because the COPY TO command that the Mail Merge Wizard is executing outputs strings delimited with quotation marks by default.

RESOLUTION
To work around this problem, do one of the following:

 Use single quotation marks (') instead of double quotation marks ("). -or- Use Microsoft Word 6.0 for Windows or Microsoft Word 6.0 for MS-DOS; the problem does occur with these versions of Word.

STATUS
Microsoft has confirmed this to be a problem in FoxPro version 2.6 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Steps to Reproduce Problem
1. Create a table that uses quoted strings. 2. Select the Mail Merge Wizard. 3. Output the merge to Word 2.0. 4. Drop the merge fields onto the document. 5. Perform the merge.

Additional reference words: FoxWin 2.60 MailMergeWizard MailWizard print merge mis-match errmsg err msg buglist2.60 KBCategory: kbinterop kbtool kbprg kberrmsg kbbuglist KBSubcategory: FxtoolWizother
 * }