Using FoxPro Data in a WordPerfect Mail Merge

• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SUMMARY

To print form letters from WordPerfect using data from FoxPro, you must export the data into a standard WordPerfect mail merge file. To create this file, use the label generator in FoxPro.

MORE INFORMATION

A standard .SDF or delimited file is not compatible with a mail merge file in WordPerfect. A WordPerfect mail merge file marks the end of a field with a ^R character and the end of a record with a ^E character followed by a hard page break.

The easiest way to create a text file for a WordPerfect mail merge is to use the FoxPro label generator. The following label format generates a standard WordPerfect mail merge file:

   ALLTRIM(fname)+ALLTRIM(CHR(18))
   ALLTRIM(lname)+ALLTRIM(CHR(18))
   ALLTRIM(address)+ALLTRIM(CHR(18))
   ALLTRIM(city)+ALLTRIM(CHR(18))
   ALLTRIM(state)+ALLTRIM(CHR(18))
   ALLTRIM(zip)+ALLTRIM(CHR(18))
   CHR(5)+CHR(12)

   Label size:    4" x 1 7/16"
   Number across: 1
   Left margin:   0
   Height:        7
   Width:        80

• The label definition must not contain any blank lines.
• No spaces are allowed between labels.
• One label should be on each line.
• Using the ALLTRIM function is critical to generate the correct file for mail merge in WordPerfect.
• Specify one field per line. WordPerfect interprets each line as a field.

   LABEL FORM <filename> TO FILE <text filename>

Make the following five modifications to the imported file:

1. At the top of the file, delete the first carriage return/linefeed (CR/LF).

   press F2.

This procedure searches for, and removes, an extra carriage return inserted after each page break. Save the resulting file in standard WordPerfect format. The file is then ready to be merged into a WordPerfect primary merge file.

After the modifications, the mail merge file looks like the following:

   Dr. David^R
   Fulton^R
   One Microsoft Way^R
   Redmond^R
   WA^R
   98052^R
   ^E
   ======================================================================
   William H.^R
   Gates III^R
   One Microsoft Way^R
   Redmond^R
   WA^R
   98052^R
   ^E
   ======================================================================

   ^F1^ ^F2^
   ^F3^
   ^F4^, ^F5^ ^F6^

   Dear ^F1^,

   This could be your lucky day! ^F1^ ^F2^, your name has been chosen
   as a finalist in our newest contest...

   Dr. David Fulton
   One Microsoft Way
   Redmond, WA 98052

   Dear Dr. David,

   This could be your lucky day! Dr. David Fulton, your name has been
   chosen as a finalist in our newest contest...