The information in this article applies to:
- Microsoft Excel for Windows, versions 3.0, 4.0
SUMMARY
Microsoft Excel versions 3.0 and 4.0 includes a database application called
Q+E that allows you to manipulate and update database files. You can use
Q+E to create mailing label files that you can print to create mailing
labels.
To use Q+E to create a mailing label file:
- Save your Excel database file as a dBASE (DBF) file.
- Open Q+E and load your DBF file.
- In Q+E, from the File menu, choose Save As.
- From the Destination list, select Mailing Labels.
- Choose the Options button.
- Fill in the information in the Label Destination box. Type the
fields in the database that you want to appear on each line of the
mailing label. To enter multiple fields on a line, separate each
field with a plus sign (+). To separate the fields, use single
quotation marks with a blank space or text string between them, as
in the following example:
City+','+State+' '+Zip
- Enter the number of blank lines you want between labels.
- If there is more than one row of labels on a page (as is the case
with laser printer labels), fill in the Column Start Position
boxes. The column start positions tell Q+E where to start each
column of labels.
- Choose the OK button and name your mailing label file.
- To print your file, open it in a text editor such as Notepad.
REFERENCES
"Q+E for Microsoft Excel User's Guide," version 4.0, 29-30
|