Mar 08, 2018 How to Print Avery Labels in Microsoft Word on PC or Mac - Using Avery Wizard Add-in Open Microsoft Word. Click Blank Document. Click the Mailings tab. Click Labels. Click Options. Click the 'Label Vendors' drop-down box and select an 'Avery' option. Select the label product number and click. If your Avery template isn’t in the Product number list, you can create a custom template in Word. Measure the label, divider, or card and the space between each. Follow steps 1-4 of Find your Avery® product number in Word, but in step 4, in the Product number list, pick the product number that's closest to yours.
You can use an Excel workbook as your Word 2011 mail merge data source in Office 2011 for Mac. Get ready by preparing an Excel workbook with a data range or table that’s set up as a mailing list and a new, blank document in Word.
To make labels from Excel or another database, take the following steps:
-
In the Mail Merge Manager, click Select Document Type and then choose Create New→Labels.
-
From the Label Products pop-up menu, choose the product.
-
From the Product Number list, select the correct number for your labels.
-
Click OK to close the Label Options dialog.A table appears. Don’t make any adjustments to the table or click in the table. The insertion cursor should be blinking in the upper-leftmost cell, which will be the only empty cell in the table. You may have to drag the bottom scroll bar to see the blinking cursor. Section 1 of Mail Merge Manager now displays the name of the Main Document and which type of merge you’re performing.
-
In the Mail Merge Manager, click Select Recipients List and then choose Get List→Open Data Source.
-
Navigate to the Excel (.xlsx) workbook you’re using as the data source and click Open.
-
Select the worksheet or range that has the names and addresses for the data source, and then click OK.Your Word mail merge document is now linked to the worksheet or data range data source in the Excel workbook. The Edit Labels dialog appears.
-
In the Mail Merge Manager, click Edit Labels.When the Edit Labels dialog opens, you see an empty Sample Label with a blinking insertion cursor. Microsoft office 2008 for mac updates.
-
Click the Insert Merge Field pop-up menu and choose the field that will be on the left of the top row of the label.
-
To add more lines to your label, press Return or Enter and then select another field from the Insert Merge Field pop-up menu.Do not click the Insert Postal Bar Code button. The U.S. Post Office changed how it generates postal bar codes, and Word doesn’t conform to the new specification.
-
Click OK to close the Edit Labels dialog.You return to your Word document, and your table grid is now filled with a whole bunch of field names in chevrons. Step 3 of Mail Merge Manager opens, but don’t use anything from Mail Merge Manager Step 3 because the Edit Labels dialog takes care of inserting placeholders when making mail merge labels. Step 2 of Mail Merge Manager now shows the filename of the data source document.
-
(Optional) In the Mail Merge Manager, click Filter Recipients.Filter data and order records.
-
In the Mail Merge Manager, click Preview Results.
-
In the Mail Merge Manager, click Complete Merge.You’re done!
Word 2010 isn’t a label-making program. Word prints on labels just as it prints on any sheet of paper. Basically, Word puts a table on the page, making each cell the same size as the sticky labels. Word then fills the cells with information, which fits snugly on each label. When the sheet emerges from the printer, you have a bunch of labels for your peeling-and-sticking pleasure.
1Click the Mailings tab, and then click the Labels button (in the Create group).
The Envelopes and Labels dialog box appears, with the Labels tab ready for action.
2In the Address text box, type the text you want printed on the label.
Keep in mind that you have only so many lines for each label and that each label is only so wide.
3(Optional) Apply some simple formatting by right-clicking in the Address box and selecting from the pop-up menu that appears.
You can choose Font or Paragraph.
4Select the Full Page of the Same Label radio button.
This button appears in the Print section of the Envelopes and Labels dialog box.
5In the Label section, choose the type of label you’re printing on.
If the stock number that’s displayed doesn’t match up, click the sample label to display the Label Options dialog box, from which you can choose the proper stock number or design of your labels.
6Click the New Document button.
By placing the labels in a new document, you can further edit them, if you like. You can also save them so that you can use the same document when you need to print a batch of labels again.
7Print the labels by pressing Ctrl+P.
Avery Labels Microsoft Word 2007
Ensure that the sheet of labels is loaded into your printer, proper side up.