home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
database
/
p4w_all.zip
/
TI1433.ASC
< prev
next >
Wrap
Text File
|
1993-04-12
|
6KB
|
199 lines
PRODUCT : Paradox for Windows NUMBER : 1433
VERSION : 1.0
OS : WIN
DATE : April 12, 1993 PAGE : 1/3
TITLE : Mail-merge with WordPerfect for Windows 5.x
Intended Audience
All Paradox for Windows users
Prerequisites
Knowledge of how to perform queries
Knowledge of WordPerfect merge
Purpose of TI
This document will illustrate how to extract data from a Paradox
for Windows table, export it to an ASCII file, and use the data
for the purpose of a merge. It will also illustrate how to save
a WordPerfect file as an ASCII file and import the ASCII file
into a Paradox for Windows table.
Mail-merge with Paradox and WordPerfect for Windows 5.x
There are two easy steps when performing a mail-merge between
WordPerfect for Windows and Paradox for Windows: exporting your
data from Paradox and merging your document with WordPerfect.
This allows you to couple the data management power of Paradox
with the word processing power of WordPerfect.
From Paradox for Windows:
1. The first step is to extract your data from Paradox. Ask
yourself what data you wish to perform a mail-merge on.
If your data is within a single table and you wish to use
all the data in the table, you can skip to the next
paragraph. If your data exists in more than one table, or
you wish to select fields and/or records from your table,
you will need to perform a query. This will allow you to
output only the information you want in your mail-merge;
this is not something easily done when trying to manage
all your data within a WordPerfect secondary merge file
alone. For more information on using queries, see
Chapters 6 and 7 in the Paradox for Windows User's Guide.
2. Export your data by choosing File | Utilities | Export
from the Desktop.
3. Choose the table to export (if you did a query, make sure
to choose your Answer table), pick Delimited Text as the
PRODUCT : Paradox for Windows NUMBER : 1433
VERSION : 1.0
OS : WIN
DATE : April 12, 1993 PAGE : 2/3
TITLE : Mail-merge with WordPerfect for Windows 5.x
File Export Type, and click the OK button. The Table Name
and New File Name should be filled in, change them if you
wish.
4. Click the Options... button. The "Fields Separated By"
option should be Commas, the "Fields Delimited By" option
should be Quotes, and the "Delimited Fields" option should
be All Fields. Click both OK buttons to export the file.
From WordPerfect for Windows:
1. The next step is to perform the merge. When creating the
primary merge file, keep in mind that {FIELD1}1~ will
correspond to the first field in the table you exported
from Paradox, {FIELD}2~ will correspond to the second
field in the table, etc. For more help with the powerful
mail-merge feature of WordPerfect, refer to Merge in the
WordPerfect for Windows Reference manual.
2. After creating and saving your primary merge file, choose
Tools | Merge | Merge... from the menu.
3. Enter your primary merge file (you can click the button at
the right to browse) and the text file you exported from
Paradox for your secondary merge file.
4. Make sure the ASCII Delimited Text (DOS) check box is
checked. Click the OK button.
5. Make sure the "Field Delimiters Begin" option is a quote
("), the "Field Delimiters End" option is a quote followed
by a comma (",), the "Record Delimiters Begin" option is
blank, and the "Record Delimiters End" option is a quote
followed by a carriage return. You can enter a carriage
return, tab, line feed, or form feed character with the
button to the right of the typein box.
6. Click OK to perform the merge.
7. If you wish to set up your default Merge Preferences,
choose File | Preferences | Merge... from the menu. You
PRODUCT : Paradox for Windows NUMBER : 1433
VERSION : 1.0
OS : WIN
DATE : April 12, 1993 PAGE : 3/3
TITLE : Mail-merge with WordPerfect for Windows 5.x
will still be prompted when performing a merge, but you
will not have to change anything.
Exporting a WordPerfect Secondary Merge file to a Paradox table
1. Open your secondary merge file in WordPerfect.
2. Choose File | Save As... from the menu. Give your file a
name and choose ASCII Delimited Text (DOS) as the Format.
3. Start Paradox for Windows, choose File | Utilities |
Import from the Desktop, select your ASCII text file, and
choose Delimited Text for the Type.
4. Click the OK button. The File Name and New Table Name
should be filled in, change them if you wish. You can
choose between a Paradox or dBASE table, then click the
Options... button. The "Fields Separated By" option
should be Commas, "Fields Delimited By" option should be
Quotes, and "Delimited Fields" option should be Text
fields only.
5. Click both OK buttons to import the ASCII text file to a
Paradox table.
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.