Printing multiple copies of a name and address in a database won't normally print on all the labels on a label sheet. The printer will usually try to print each name and address on a separate page. Here's a workaround that will let you print multiple copies of a name and address, such as for a return address, using all the labels on a sheet.
The secret is to put the return address information directly on the label layout, and then create the appropriate number of "blank" records for a single sheet of labels. When you print the blank records, you'll be printing the return address that is on the layout.
1. Create a new database, called "Return Address Labels." It is best to do this in a new database file. This way you do not add blank records to your main database.
2. Define a single field, of type Text. Name it "Place holder."
3 From the Layout menu, select New Layout.
4. From the New Layout dialog box, select Labels. Choose the appropriate Avery label number for the labels you plan to use. For this example, we will assume the Avery 5160, which come 30 to a sheet, in three columns of ten.
5. In the Specify Field Order dialog box, choose the Place holder field and move it over to the right. Click OK.
6. From the Layout menu, select Layout. This will bring you into Layout mode, which will let you edit the label layout you have just created.
7. Click on the Place holder field. Press the Delete key to delete the field.
8. Click on the Text tool (the letter "A") and draw a text box in the label area. Do not move the small box with the word Body in it; draw on top of this box if necessary. (Moving this box will change the size of each label on the sheet.)
9. Type your return address information within this text box.
10. From the Layout menu, select Browse. We now need to create 30 records to correspond with the 30 labels on a sheet of Avery 5160s. (For other labels, create the number of records equal to the number of labels on a single sheet). In Browse, hold down the Apple key (*) and hit the letter "R" (*+R) in Windows use the Ctrl key and the letter "R" (Ctrl+R). This will create a new record. The idea is to create 30 blank records (one for each label). Keep creating new records until the Records indicator in the Status Area (the bar on the left side of the screen) reaches 30.
To print your return address labels, select Browse from the Layout menu, then choose Print from the File menu.
If you want to print more than one sheet of labels, use the Print dialog box to specify the number of copies desired.