Microsoft KB Archive/119634

{| = PRB: Mail Merge Wizard Limited to 3 Memo Fields with Word 6.0 =
 * width="100%"|

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
 * }