PRB: Mail Merge Wizard Limited to 3 Memo Fields with Word 6.0

ID: Q119634

The information in this article applies to:

• Microsoft FoxPro for Windows, version 2.6

SYMPTOMS

You are limited to a maximum of three memo fields when you are using the FoxPro for Windows Mail Merge Wizard to create a mail merge with Microsoft Word 6.0 for Windows.

If more than three memo fields exist in the .DBF structure, only the first 3 memo fields are merged with the Word document; all subsequent fields are omitted from the merge.

CAUSE

This is a limitation of the Word 6.0 ODBC driver. The same limit applies when you are using memo fields from a Microsoft Access table.

 For additional information, please see the following article in the
 Microsoft Knowledge Base:

   ARTICLE-ID: Q122752
   TITLE     : Word Sees Limited Memo Fields Using ODBC Drivers

WORKAROUND

Change the memo field to a character field, which has a 254 character limit.

MORE INFORMATION

Because the ODBC option of the Mail Merge Wizard is the only option that supports memo fields, there is no way to work around this limit using DDE.

Additional reference words: FoxWin 2.60 winword KBCategory: kbinterop kbtool kbprb kbusage KBSubcategory: FxinteropOdbc

Last Reviewed: June 26, 1995