Double click gLabel (this is the only field you need on your layout). Choose the label type (for instance, Avery 5160), click OK. Go to Layout Mode, the create a New Layout, choose Label, name the layout 'Labels', click OK. In order to create multiple labels with the same piece of information, let's create a label layout. This is very handy for us, because we want to use the same information for each label (that is, for each record).įor each of your records in the database, you have a calculated field which has pre-formatted text (the LabelCalc) which looks like a label. This is because for every record, the Global field's contents are the same. This Global field is a very different type of field from any others you may have used. Next, create a Global field (Type is Text): Be sure the include all the ampersands (&) as shown (there must be one ampersand between each 'component' of the calculation). This field concatenates your fields with appropriate spaces, commas, and hard returns. This is a Calculation field (Text Result) with the following calculation: Let's say your database has the following fields (it doesn't matter if these are text, number, or calculation fields):Ĭreate a new field which will serve as the label's content: This is done by designating two options in the print dialog box: Print Records Being Browsed, and Print Range from page 1 to 1.
For instance, you can print one page for 33 labels on a 33 label layout. If you would like to print 45 labels, you will need to have 45 records in your found set (same information is printed for each record, so it doesn't matter what the record contents are, just how many are found.) Depending upon how many records you have in your database, it may be easier to simply decide to print as many pages as you want labels. With this solution, one label will print out for every record in your found set. You should be familiar with ScriptMaker in order to complete this solution. F you would like to print multiple labels for a single address, here's a way to accomplish this quickly.
0 kommentar(er)
