Customize a Word document to use your Avery® sheet

The Edit Labels dialog appears. 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.


  1. descargar sqlite manager para mac.
  2. Customize a Word document to use your Avery® sheet;
  3. how to reset usb ports on mac pro;
  4. Word for Mac: Making Labels by Merging from Excel - dummies.

In Label Options , check the measurements shown under Label information to help with selecting the label size that best matches your product. Word displays New Custom laser or New Custom dot matrix , depending on the type of printer specified in Label Options. After you have the correct measurements, click OK twice to return to Labels. When you click OK in Labels , Word creates a new document with the information from Delivery Address laid out for printing to the type of labels that you configured.

Find your Avery® product number in Word

After you have Word configured to use your Avery product, you have a few options:. Print the same or different addresses, or other information, on all or some of the labels on a sheet, as described in Create and print labels. Use the information in the contacts list on your Mac to fill out and print labels, as described in Mail merge in Word for Mac.

Merge information, such as names and addresses, in an Excel spreadsheet with a document to print that information to labels, as described in Create mailing labels in Word by using mail merge.

Add a Logo to the Envelope

Expand your Office skills. The address looks good, but notice that we are missing the state. It's not listed here but when we check back in our Excel document, it's there.

Well this is ok, we can fix it. Go ahead and click on the Match Fields button. Now in the left column find State and in that row click on the arrow pointing down, then select your header name for the State column. Mine is called State, so I will select that and click OK. Now we see that the state is showing and the address looks good. Go ahead and click the OK button. If you decide to print your labels now, you will only get that first address in the first label.


  • User reviews;
  • mac superior bread knife review!
  • Download Free Avery Wizard for Microsoft Office, Avery Wizard for Microsoft Office Download?
  • Office 2011 for Mac All-in-One For Dummies!
  • How to print labels in Microsoft Word 2008 for Mac.
  • Use Avery templates in Word for Mac - Word for Mac?
  • To do that you need to click on Update Labels option on the ribbon. Once you click on that button, all labels will update. And you are almost done!

    Avery Wizard 3.0/3.1 for Microsoft Word for Windows Frequently Asked Questions

    Make sure All is selected and click OK. TA DA!!! Now all you need to do is print your labels.

    Mail Merge for Dummies: Creating Address Labels in Word 2007

    Another Way to Merge with Word and Excel 1. Another way to do the merge is to pick the fields manually. To do that you will need to select the Insert Merge Field option on the ribbon and select one field at a time. To start out, insert First Name , hit the space bar and then insert Last Name. After that, hit the enter key and insert Address. Hit the enter key again, insert City , hit the comma key , and the space bar , insert State , hit the space bar again, and insert Zip Code. This way all of your spacing and punctuation will be correct and your first label should look something like this.

    You can also format the first label any way you want it. For example, you can change the font, you can center the text, make it bold, etc. Once you are done making edits to the text and formatting, don't forget to go back to your Mailings tab on your ribbon and select the Update Labels button. This will make sure that all your formatting and changes that you made to the first label are copied over to all the other labels.

    Now you're ready to view and print your labels.

    Avery Wizard / for Microsoft Word for Windows Frequently Asked Questions - PDF

    Now isn't this much easier than typing the names and addresses on the labels, over and over, and over again? And merging works just as well with letters, invitations, thank you notes, or anything else you do in Word. Try it out!