BUG: "Field Count Mismatch" Error with Word 2.0 Mail Merge

 Last reviewed: June 27, 1995
Article 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.

MORE INFORMATION

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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 27, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.