I’ll start with a new blank form (see Creating a New Form). To automatically create a form for printing labels, I choose Mailing Label from the Construct menu. This opens a dialog sheet that lists all of the fields in the database. I edit the list to arrange it into the format of a mailing label (including adding the comma between City and State), and also remove the fields I don’t want to include on the label. When done, I simply press the Construct button.
That’s it – the form is done! You can switch to data entry mode and start printing mailing labels immediately.
Here is a close-up at the final result.
You can, of course, manually modify the form objects after they have been generated. But you can also modify the template and regenerate the form. For example, I can edit the template to add Attn: in front of the person’s name.
As long as you don’t modify the generated objects individually, you can go back and make additional modifications to the template at any time.
There are about two dozen tags that you can use to customize the generated form objects. There is complete documentation for all of these tags below, but if you just need a quick reminder while using the dialog, click the tag icon in the upper left. This displays a pop-up menu with all the available tags. When you select a tag from the menu, that tag is automatically typed into the template. In this example I use the tag menu to change the label type to Avery 5162.
Once they are generated, you can manually modify individual objects by dragging them, resizing them, or using the object properties panel to modify their appearance and operation. Once you do that, however, you probably want to avoid running the constructor dialog again – doing so will undo any manual changes you have made.
You may want to generate objects using more than one template in a single form – however, you can’t do that. But all is not lost – simply create each template in a different form, and then copy the finished results into the same form. Each form has its own separate constructor template.
The template parameter allows you to customize how form elements are generated. You can specify which fields (or variables) are included, the size, alignment, etc. The remainder of this page describes the details of the available tags.
To include a field on the label, type in the name of the field surrounded by « and » characters (Option-\ and Shift-Option-). Here’s an example of a typical mailing label with 5 fields:
As you can see, this example also includes punctuation: spaces, carriage returns, and a comma. Here’s the finished label:
You can type in any extra text you want, including complete words and phrases. In this example,
Attn: will be printed in front of the name.
Here’s the modified label:
Note: Any spaces or line breaks before or after the text will be ignored.
If a line is completely blank, it will collapse when printed. For example, for records where the Organization field is blank, the Address line and the City, State Zip line will move up just below the Name line.
Here are two finished labels – one with the Organization line, and the second with this line missing. The line containing Organization has “collapsed” since there is no organization name to include.
This collapse will only happen if the field is on a line all by itself. If that is not the case, you would need to use a formula (see below) to ensure that the line “collapses” when needed.
In addition to single fields, you can embed an entire formula into the label by enclosing it with
} characters. This example uses formulas so that only the first initial of the name will be printed, and so that the City will be printed in all upper case letters.
When the label is displayed or printed, the formula results are calculated and merged into the label.
To customize the generated form objects you can include one or more tags. Like HTML tags, these tags start and end with
The most common mailing labels are from Avery. Using the
<avery:type> tag, you can easily specify the most common Avery labels:
Here’s what this 5163 label looks like:
There are five Avery labels supported, 5160–5164. If you don’t specify any label or label dimensions, the default is Avery 5160.
If you’re using something other than an Avery label, you can specify custom label dimension with the
<leftmargin:distance> tags. The measurements are normally expressed in points (1 point = 1/72 inch) but you can also specify values in inches (
1 in or
2.5 inch or
0.75") or centimeters (
Here is what this custom label looks like:
Many labels have multiple columns on a page, for example Avery 5160 labels are 3-up. Panorama normally calculates the number of columns from the label width, but you can also explicitly specify from one to four columns with the
<labelcolumns:count> tag. You can also specify whether labels are printed across or down with the
The text is normally inset on the label by 8 points (one 9th of an inch). Use the
<inset:distance> tag to specify a different inset.
The size (height) of the text is normally calculated automatically so that the text vertically fills the label, but you can override this.
<lines:count> tag to specify the number of lines in the text (normally this is counted for you). In this example, the automatic line count would be 3, but what if the Address field contains 2 lines? By manually setting the lines to 4, the text height is reduced to leave height for the extra address line.
<lines:4> «Name» «Address» «City», «State» «Zip»
You can also explicitly set the text height with the
<labelfontsize:height> tag. When this tag is used, the number of lines is ignored.
<avery:5164><labelfontsize:18> «Name» «Address» «City», «State» «Zip»
Labels text is normally Helvetica. Use the
<labelfont:name> tag for a different font.
<labelfont:Papyrus> «Name» «Address» «City», «State» «Zip»
You can embed RTML tags (see richtextdisplay() into the text to make a word or phrase bold, italic, a different font or color, etc. This example will print the person’s name in bold, and the zip code in italic.
Here is the finished label:
See Rich Text to learn more about the options that are available for creating different styles, colors, etc.
Note: If you use rich text tags, empty lines won’t collapse automatically. Instead, you’ll have to use a formula to get them to collapse.
If the very first item in the template is the
<zapform> tag, the form will be cleared before generating the new objects. Be careful with this tag – it will destroy everything in the form before adding the new objects!
Note: Even if you don’t include the
<zapform> tag, this statement will clear any objects that were previously generated by this statement. In other words, even if you use this statement multiple times you’ll only end up with one set of generated objects.
|10.0||New||New in this version.|