Mailing Labels For Microsoft Word For Mac 2017

Before labels can be made, the names and addresses must be stored in a CSV file or another format that can be imported into the Mail Merge. See our steps for creating a CSV file if you need to create one.

Office Home; Products. For home Plans & pricing. Create and print labels. See Create mailing labels in Word by using mail merge or Mail merge in Word for Mac. If you want to make return address labels, see Create return address labels. May 24, 2017  Hello I have to merge labels on an A4 paper. 21 Labels per page. The spreadsheet contains 175 records of respective companies. What I need is to repeat the same label for each company 21 times on a single page.

Once a CSV file is prepared, the steps below can be followed to create labels using a mail merge.

Step one and two

1. In Microsoft Word, on the Office Ribbon, click Mailings, Start Mail Merge, and then labels.
2. In the Label Options window, select the type of paper you want to use. If you plan on printing one page of labels at a time, keep the tray on Manual Feed; otherwise, select Default.
3. In the Label vendors drop-down list, select the type of labels you are using. In our example, we are using Avery labels.
4. Select the product number of the labels. The product number is often shown in one of the corners of the label package.
5. Once everything is selected, click OK.

If your label product number is not listed, you can often download the template for your labels from the manufacturer's website. Search for xxxxx template, where xxxxx is the product number you are trying to find.

Step three

6. After the labels are created, click the Select Recipients button in Mailings and then click Use Existing List.
7. In the Select Data Source window, point Microsoft Word to the location of your CSV file and click OK.

If the CSV file inserts properly, you should now have '<<Next Record>>' on each of your labels.

Step four

8. Click the Address Block option in the Ribbon and verify the address is properly formatted.
9. If the address is not being displayed properly, click the Match Fields button and change how the fields are being matched.
10. Once the address is being displayed properly, click OK to place the '<<AddressBlock>>' field into the first label.

Step five

11. Click the Update Labels button to update all fields.
12. The first label should only have the '<<AddressBlock>>' field. All other labels should have '<<Next Record>><<AddressBlock>>' to step through each address field and print the address block in each label.

Step six

13. To make sure everything looks ok, click the Preview Results button, which should show each label and a different address for each label.
14. If you want to preview more than the first page, click the arrow pointing to the right while still in preview mode to show other pages.

Step seven

15. If everything looks ok, click the Finish & Merge button.
16. Click Print Documents to print the labels.

Node for mac install. To help prevent labels from being wasted, we highly recommend you print labels on a piece of paper before printing on the label stickers. After printing the labels on plain paper, with the label paper behind the plain paper, hold them up to a light. Doing so allows you to check if the spacing and formatting of the labels looks good.

Additional information

• See our CSV and mail merge definitions for additional information and related links.

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. 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. Press Ctrl+c to copy the selection to the Clipboard.
4. 4 Display the Mailings tab.
5. Click the Labels tool in the Create group. Word displays the Labels tab of the Envelopes and Labels dialog box. (See Figure 1.)

Figure 1. The Labels tab of the Envelopes and Labels dialog box.

6. Click Options. Word displays the Label Options dialog box. (See Figure 2.)

Figure 2. The Label Options dialog box.

7. Using the Label Vendors drop-down list, choose Avery US Letter.
8. In the Product Number list, choose 5163.
9. Click OK. Word closes the Label Options dialog box.
10. Make sure the Full Page of Same Label radio button is selected.
11. Click New Document. Word creates a new document using the label format you specified in steps 7 and 8.

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. Continue with the following steps to complete the process of creating the new document with your original labels in the new Avery 5163 format:

12. Press Ctrl+A to select the entire new document.
13. Press Ctrl+v to paste the contents of the Clipboard (from step 3) into the new document.