Also see the "print avery labels.swf" video clip in the videos library
H2OS has several mailing label printing features:
- Print return address labels
- Print name and address labels for all or selected customers (see example below)
In this procedure, we'll re-run a record selection command prepared earlier.
See How to change an SQL Command for an example of changing an SQL command stored in your library.
On the menu, select Print -> Mailing Labels -> Avery labels
The Avery address label printer screen will appear:
Click Select Records, and the Record Selection Manager screen will appear
See Select Records using SQL Select for an example.
When you are finished with record selection, you will be returned to the Record Selection Manager, which will display the number of currently selected records.
Click SELECT
The Avery address label printer screen will re-appear
The number of selected records appears in the lower left portion of the screen
Now we'll set the label printing options and click PRINT (with or without the PREVIEW checkbox)
|
Option |
Comments |
|
Set Font
|
Click to change the font name, size and style using the standard Windows window for this purpose.
When you make a change and click OK, the screen will show the font applied to the same name and address on the screen
|
|
Label format
|
You can select from the available label print formats installed on your computer in the REPORTS folder (files named xxxxx.LBX)
The default format ("Avery_5160.lbx") will print 1-4 line name and address labels with the town, state and zip code (but not the ZIP4 code).
|
|
Printer |
You can select a printer from your installed printers by clicking the ellipsis command to the right of the Printer field.
Use the pulldown menu on the Printer screen to view and select a printer from the list of currently installed Windows printers. When you've selected a printer, click OK.
|
|
Preview
|
Shows the print on your screen for study and, optionally, sending the labels to your printer. An toolbar will appear on the screen with tools you can use to close the view, send to the printer, enlarge the view.
If the toolbar does not appear, right click in the report area and select TOOLBAR from the right-click menu.
The preview screen looks like this.
Use the toolbar on the preview screen to send the labels to the printer or cancel the job. You can also resize the preview screen.
If the toolbar disappears, eight click in the report background area and select TOOLBAR from the menu.
|
|
Append "Or current resident"
|
Check to add the words in the entry field to the end of LINE1 (name field) in printed labels
Joe Jones
becomes
Joe Jones or current resident
|
|
Select Records
|
Click this command to use the Record Selection Manager to select a subset of customers from your database as the source of data for an operation, such as printing mailing labels or sending an e-mailing.
|
