Microsoft KB Archive/113004

{| = File Formats Created by Mail Merge Wizard =
 * width="100%"|

ID: Q113004

2.60 3.00 | 2.60

WINDOWS  | MS-DOS kbtool kbinterop kbprg The information in this article applies to:


 * Microsoft Visual FoxPro for Windows, version 3.0
 * Microsoft FoxPro for Windows, version 2.6
 * Microsoft FoxPro for MS-DOS, version 2.6

SUMMARY
FoxPro version 2.6 contains a Mail Merge Wizard to create data files that can be used by a variety of word-processing programs.

MORE INFORMATION
Step 2 of 5 in the Mail Merge Wizard asks "Which word processor will you use for your mail merge?" The table below shows the available choices, whether memo fields are supported, and what type of file will be created for each choice.

FoxPro for MS-DOS Word Processor Choices
Word processor          Memo? File format created ---

Word for MS-DOS         No          ASCII comma-delimited file WordPerfect             No          WordPerfect version 5.0 or later merge file Other                   No          ASCII tab-delimited file

FoxPro for Windows Word Processor Choices
Word processor          Memo? File format created ---

Word for Windows 6.0    Yes         None; uses Word's ODBC driver Word for Windows 2.0    No          ASCII comma-delimited file Word for MS-DOS         No          ASCII comma-delimited file WordPerfect             No          WordPerfect version 5.0 or later merge file Other                   No          ASCII tab-delimited file Visual FoxPro Word Processor Choices Word processor            Memo? File format created ---

Word for Windows 6.0      Yes        None; uses Word's ODBC driver Comma Delimited Text File No         ASCII comma-delimited file Note that Word 2.0 for Windows and Word for MS-DOS create files with identical formats. The first record of an ASCII comma-delimited file consists of the names of the fields. Subsequent records contain data, terminated by a carriage return/linefeed (CR/LF) combination. Each field within the record is separated with commas, and character fields are enclosed in double quotation marks.

For additional information about the format of the files produced for the "Other" word processor choice, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q114963 TITLE: Mail Merge Wizard's "Other" Word Processor File Format Only the Word 6.0 for Windows mail merge recognizes memo fields. This behavior is by design. The ODBC drivers allow Word to directly use the FoxPro .DBF file and access the corresponding memo fields in that file. If any other mail merge format is chosen, the memo fields will be ignored. For all other word processor choices, a file will be created after the Finish button is chosen. A Save As dialog box will appear, allowing a specific filename and path to be entered. Unless a different filename is entered, the file will be stored in the default directory with the name MMRGDATA.TXT.

NOTE: None of the word processors listed above support a general field in a mail merge.

Additional reference words: VFoxWin 3.00 FoxDos FoxWin 2.60 KBCategory: kbtool kbinterop kbprg KBSubcategory: FxinteropOdbc

Keywords         : FxinteropOdbc Version          : 2.60 3.00 | 2.60 Platform         : MS-DOS WINDOWS
 * }