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.
- Free Word For Mac Downloads
- Free Word For Mac 2011
- Word For Mac 2011 Avery 5931 Labels 8160
- Word For Mac 2011 Avery 5931 Labels Label
- Word For Mac 2011 Avery 5931 Labels 8160
I am trying to create address labels using Mail Merge Manager in Word 2011 for Mac. I am using a downloaded template from Avery. I add the address fields I wish to use and then I set the alignment to Center Right. I then insert a graphic/picture to the left side of the label. I format the picture to be in front of text. At Avery.com, you'll find office supplies and products such as labels, dividers, notetabs and binders. You can also browse our website to find ready-made templates. Avery ® Media Labels 1 per sheet. Template 8696, 1 per Sheet. Avery® CD Labels - 8696 - Template ×. While Word® is ideal for simple text editing and address labels, if you would like to be more creative in your label design, we recommend using Avery Design & Print. Blank Word Templates Simply enter the software code of your Avery product, then you'll be transferred to a. .WorldLabel.com does not sell Avery® labels. The Avery® brand, its product names names, and SKU trademarks are owned by CCL Label, Inc. Does NOT sponsor or endorse any products made or sold by WorldLabel.com.
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.
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!
Free Online Template Software
Free Word For Mac Downloads
To get the most out of your Avery products we recommend using our Design & Print Software. It’s a free and easy way to design, edit and print Avery labels, cards and more.
- Choose from hundreds of designs and templates
- Add text, colours & graphics
- Import contacts and data with mail merge
- Save projects online or to your computer
Free Word For Mac 2011
Sign up to the Avery newsletter for tips & inspiration
Sign up for our newsletter and get news, inspiration and information about our products and ranges, software, templates, tips & tricks.
Word For Mac 2011 Avery 5931 Labels 8160
Your advantages:
Word For Mac 2011 Avery 5931 Labels Label
- New designs and pre-designed templates
- Information about new products and software
- Tips & ideas for work and home
Word For Mac 2011 Avery 5931 Labels 8160
We do not spam you. In general, we send out the newsletter when we have something at heart, and rarely more than once a month. You can of course unsubscribe at any time. At the bottom of each email is a link to unsubscribe.