home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Simtel MSDOS 1992 September
/
Simtel20_Sept92.cdr
/
msdos
/
database
/
reflexex.arc
/
MAILLIST.RXR
< prev
next >
Wrap
Text File
|
1986-06-21
|
4KB
|
107 lines
.HE HOW TO CREAT A REFLEX TO CREATE A 3 COLUMN MAILING LIST
The following procedure describes how to use the REFLEX Report
View and Translate utility to create column style mail lists.
1. An example of a blank Form:
Name:
Title:
Company:
Address:
City:
State:
Zip:
2 Run REFLEX2, enter the REPORT View. Retrieve your database
and create a Report Design to print the information needed
for the labels to an ASCII file. Put each of the above field
name on a separate Body Row like below:
Body| Name
Body| Title
Body| Company
Body| Address
Body| City
Body| State
Body| Zip
Using the VARIABLE WIDTH attribute set each of the field
names to be 'Wide As Needed'. Delimit each of the field
names with Quotes using the EXPORT attribute.
3. Choose Change Printer Settings from the Print/File menu and
set the following parameters:
Print to Disk = Yes
Enter a file name
Top Margin = 0
Bottom Margin = 0
Left Margin = 0
Right Margin = 254
Print With Page Breaks = No
4. Choose PRINT.
The REPORT View will create an ASCII text file which will
be translated into a new REFLEX Database.
.PA è6. Quit out of the REPORT View and select Translate.
Create a Translation Spec with the following field names in
the Reflex field name column:
Name1
Title1
Company1
Address1
City1
State1
Zip1
Name2
Title2
Company2
Address2
City2
State2
Zip2
Name3
Title3
Company3
Address3
City3
State3
Zip3
Make sure that the file name in the To File cell is
DIFFERENT than your original Reflex database. This
Translate spec will create a record that contains three
records from the original mail list file.
7. Select TRANSLATE. REFLEX will translate the file and create
a new Reflex database.
8. Run Report and retrieve the newly translated database.
Create a Report Design to print the names 3 across.
REPORT DESIGN
Name1 Name2 Name3
Title1 Title2 Title3
Company1 Company2 Company3
Address1 Address2 Address3
City1 City2 City3
State1 State2 State3
Zip1 Zip2 Zip3
.PAè TRICKS/TRAPS:
The original data file must have a number of records that is
equally divisible by the number of columns that you want in the
final mail list report. If you want a four column mail list
report then your preliminary database must have 4,8,16,20,24,...
number of records. If it does not have the correct number of
records as many as three records at the end of the preliminary
database will be lost when the translation occurs. You should
sort the original database in the order that you want the names
to display in the final mail list report then add empty records
to the end of your database until the total number of records in
the database is divisible by the number of columns you want in
your final report.