Changing Label Sizes

Veronica has a document that contains labels, with names already in place. The document is intended to be printed using Avery 5162 labels, but Veronica wants to change the document so it uses Avery 5163 labels. She wonders if there is a way to change label size without the requirement of recreating the entire document.

There are a couple of ways you can approach this problem. It is important, though, to remember that a label document is nothing but a large table that is formatted to match the dimensions of your labels. Understanding this, you could easily examine the table settings used in creating Avery 5163 labels and then change the table settings in your old document to match them. Because you change the table settings to match what is required for the new labels, you should be able to print on them with no problems.

Another idea is to create a new document consisting of empty Avery 5163 labels and then copy the data from the old Avery 5162 document to the new document. As long as you don't copy the table structure—just the data—you should have no problem.

If your labels are all the same, then the easiest method of converting to the desired label format is simply to use much of the same process you used to create the labels in the first place. If you are using a version of Word prior to Word 2003, then follow these steps:

1. Open the existing document, the one that contains your labels in the Avery 5162 format.
2. Press Ctrl+A to select the entire document.
3. Choose Tools | Letters and Mailings | Envelopes and Labels. Word displays the Envelopes and Labels dialog box and your first label should be displayed in the dialog box. (Click here to see a related figure.)
4. Click Options. Word displays the Label Options dialog box.
5. Using the Label Products drop-down list, choose Avery Standard.
6. In the Product Number list, choose 5163 - Shipping.
7. Click OK. Word once again displays the Envelopes and Labels dialog box.
8. Make sure the Full Page of Same Label radio button is selected.
9. Click New Document. Word creates a new label document, using the label type you specified in steps 5 and 6.

At this point you should have two documents—one that is your original (Avery 5162 format) and one that is your new document (Avery 5163 format). The new document contains a full set of labels based on the first label in your original document.

If you are using Word 2007, then you can accomplish the same task by following these steps:

1. Open the existing document, the one that contains your labels in the Avery 5162 format.
2. Press Ctrl+A to select the entire document.
3. 3 Display the Mailings tab.
4. Click the Labels tool in the Create group. Word displays the Labels tab of the Envelopes and Labels dialog box.
5. Click Options. Word displays the Label Options dialog box. (Click here to see a related figure.)
6. Using the Label Vendors drop-down list, choose Avery US Letter.
7. In the Product Number list, choose 5163.
8. Click OK. Word closes the Label Options dialog box.
9. Make sure the Full Page of Same Label radio button is selected.
10. Click New Document. Word creates a new document using the label format you specified in steps 6 and 7.