Word for Office 365 Word 2019 Word 2016 Word 2013 Word 2010 Word 2007 More. Less If you've been using Avery's step-by-step wizard to format and print Avery labels, business cards, and more in earlier versions of Word, here's a heads-up that Avery is planning to retire the add-in.
Whether you need to perform a mail merge or create labels for CD’s and DVD’s, the Avery Mac Label Expert is the essential desktop tool for all your labelling needs. The quick and easy-to-use Avery Mac Label Expert is an efficient and innovative software tool that can be downloaded directly to your Apple Mac. Suitable for small or large businesses and homeworkers, the software guides you through a series of simple steps for formatting and printing onto all Avery printable products, including Addressing and Identification labels, Business Cards, IndexMaker Printable Dividers and CD and DVD labelling. Stuart McIntyre, assistant product manager, Avery commented in the press release: “We are always looking at providing our customers with new and innovative ways to use our products.
By creating free software for Mac users, we are building on the Mac solutions that we already provide today. I am sure this product will prove to be very popular.” Avery Mac Label Expert features include a brand new user interface, templates for all Avery printable products, support for both printer fonts and Macintosh fonts. Mac users can therefore, create fantastic printable projects direct from their AppleMac including mail merge from Excel, Word, ClarisWorks, FileMaker and AppleWorks. By clicking on the Avery Mac Label Expert, users can select their desired Avery product template, add their own text and graphics, type on the template manually and format the text.
Not only that, you can preview your project and then print it out. More info and download link for Avery Mac Label Expert. How nice of Avery! I used to use the original Avery Label Pro in the System 7 days, and then Avery felt us Mac users were no longer important. They dropped me like a bad prom date. I recall once writing them to ask where the support for their program had gone, and they replied with the suggestion that I should switch to Windows. Now they’re back, which may be a sign of Apple’s resurgent popularity.
But I’m still more than a little bitter. A fair weather friend is what Avery is to me. And don’t get me started on how expensive their labels are.
I guess it’s time to grab my ankles again. I’ve been using the Avery Label Wizard for Mac for about two weeks now and I find it very useful for printing odd one off addresses when I’m in a hurry to get to my local snail mail office before they close, etc. Although the wizard is good at performing higher volume printing of often used addresses, I have Word for Mac set up using the same code provided by Avery to then display a template with all the columns and formatting in place for the more used addresses. In a similar strain if you’re looking to print off your own business cards I would NOT recommend using Avery Label Wizard and instead recommend using Belight Software’s “Business Card Composer” – this will also utelize the Avery coding to ensure your creation fits neatly in place, cutting out all that fiddly formatting as that is now firmly in the past! For Question & Mikal in NYC: I thought I’d clarify a bit more about using Word for Mac and how to use ready made templates – even templates designed for the inferior Office 2003 using either Office Mac v.X or 2004 will work too! I’m using v.X. In Word open “Project Gallery” and select Labels.
A Mailing Wizard window will open and clicking on that will open a dialogue window with fields ready for you to input the address and below that a field where you can choose the type of label you are using, Avery is the most popular, although a few other makes are supported if but minimal. I would avoid using a label sheet made by an unknown local firm of printers unless you are okay with making your own templates by adding in the dimensions yourself, etc. Otherwise to directly answer your question (pun intended) Word already has that feature for label printing using templates. As for Illustrator, I think opening files in Word saved in Illustrator as.PDF and importing that as an image will allow you to then use Word onwards.
Doing a mail merge using may get you confused or stuck, not because it is difficult or impossible to do, but because there are specific steps you need to follow. Missing a step, or doing something out of order may give you unwanted results. I would like to help you out and give you step by step instructions, complete with images, on how to do a mail merge and create mailing labels using. I will also go over how to add a return address to your labels. Let's get started!
Address Labels 1. To start the mail merge for labels, you should have a list of all the addresses. I put all my addresses in an Excel spreadsheet with specific columns for first, middle, and last name, address, city, state, and zip code, saving all 3,000 of my addresses to my desktop with the name of “3000 names.xlsx”. You can see a screenshot of my Excel spreadsheet below. Now let's open up Word 2010 and click on the Mailing tab all the way on top. Click on Start Mail Merge and then select Labels. Please don't worry if your window looks a little different and you have bigger icons on your toolbar.
My Word 2010 window was resized and was not maximized so it was only trying to fit as many options as possible in the space I was allowing. Once you click on Labels, a Label Options window opens. Go ahead and select the Label vendors. In my example I am going to go with the popular Avery US Letter.
Then select the labels you want. I am going to use 8662 Easy Peel Address Labels as I still have a lot of them left from when I did the merge in Office 2007. Once you are happy with your selection, click OK. After you hit OK, click on Select Recipients and then select Use Existing List.
We are going to use that list I mentioned in step 1. Point to the location where the excel spreadsheet is located. As you can see, my list is on a desktop in a folder called Addresses.
Select your spreadsheet and click on Open. Select the appropriate Table – in my example it is the one called 3000$. If you did not rename your table it is probably just called Sheet1$ - so select that one.
Please check the check mark next to the first row of data that contains column headers. You should have column headers otherwise you will only see A, B, C, etc. And it will be very difficult for you to figure out which column is the first name and which one is the zip code.
Once you make the table selection and you check the box, click on OK. After you click OK, your Word 2010 document should look like this. You should see each separate label. There are two ways of adding the addresses to our labels: a. The first one is to click on the Address Block i. When you select the Address Block, you need to make sure the format is what you want and that all the fields you want are included.
In the example below we select the format with the middle initial, but when we scroll down to record 4, for Lisa, we notice that her apartment number is not listed. In order to include it, we need to manually match fields. So if you are in similar situation, go ahead and click on Match Fields. After looking at Address 2 on the left, I noticed that (not matched) is currently selected. I will click on the arrow pointing down and select my AddressLine2 field from my Excel sheet to make sure the apartment number is going to be included in the address. After that I click OK.
Now double check that the format with middle initial is still selected, make sure the apartment number is showing for my record for Lisa – all looks good – click OK. Now you can see Address Block on my first label.
Time to click on Update Labels. On my window all you see is a little icon that, when you point to it, says “Update Labels.” If your Word 2010 window is maximized you will see the icon with the words “Update Labels.” Go ahead and click on it. This is what it should look like after updating labels. Alright, it's time to click on Finish & Merge!
But before you print the documents, click on Edit Individual Documents. Make sure All is selected and click OK. This will make sure all of your records from the spreadsheet are being added to the mail merge. Double check one more time to make sure everything looks good. I am going to look at record 4 and make sure Lisa's apartment number shows up.
I want to point out that my document has 215 pages for my 3000 addresses. Another thing I want to point out in the second image is that my page 2 is different so it is not Page 1 repeating 214 times. You are ready to print your labels! The second way to insert the fields is to do it manually by selecting Insert Merge Field and then clicking on each field. When inserting the fields manually, do not forget about inserting the spaces, periods and commas.
You can also format the fields. In my example I made them centered and bold. You can also do that with the address block as in the previous example. Once you are happy with what the label looks like, it's time to click on the Update Labels button.
On my window all you see is a little icon that, when you point to it, says “Update Labels.” If your Word 2010 window is maximized you will see the icon with the words “Update Labels.” Go ahead and click on it. Once they are updated, they should look something like this. Now let's click on Finish & Merge. Before you print the documents, click on Edit Individual Documents.
Make sure all records are selected and click OK. Double check your results to make sure extra fields are included and then you are ready to print! What if you want to include a return address on a postcard or a big shipping label? How do you do that? Return Address Labels 11.
Go back to step 4 to open up the Labels Option window. Select the label you want. In this example I am going to continue using Avery US Letter for Label vendor and then select 8577 Postcard for the big label. Basically, if you want to include a return address you need to have enough space on the label – that's why I am selecting a postcard – I know it will have enough space for me to include the return address. Type in your address on the first label/postcard.
You can format it however you want it (make it bold, change the font, etc.). Then select it and click CTRL-C to copy it. Hit the Tab key to move to the second label and hit CTRL-V to paste it. Do that for the entire first page of labels. In my example I only have 4 labels per page so I will have to do that 4 times. This is creating a label template that then will be used to create the mail merge. If you want, you can also add an image to each label or some other information.
Just remember to copy and paste it for each label on the first page. Now that we have the label template ready, click on Select Recipients and then Use Existing List.
Pick the excel spreadsheet with all your addresses. Just like earlier, select the table, check the box next to First row of data that contains column headers, and then click OK. Now you have two options to add the addresses to your labels: either use the address block or insert individual merge fields manually, just like in step 10. This time around I am going to use address block. I will make sure all my fields are matched and then click on OK. Once I see the address block on my first label, I will select it and using my indent markers on the ruler I will move it to the position I want the address to appear.
Once I have my address block in the position I like, it's time to update all the labels. Go ahead and click on the icon for Update Labels.
The address block should appear on the rest of the labels. We are almost done. All we need to do is make sure all our records in the excel spreadsheet will be transferred for the mail merge. To do that, click on Finish & Merge and select Edit Individual Documents.
Make sure All is selected, then click OK. It may take a few seconds but you should be able to see the document being created.
Since I am using bigger labels/postcards I have 750 pages created for my 3000 names (which makes sense right? 3000 / 4 = 750).
Make sure the addresses appear the way you want them. In my example I will be checking record 4 for Lisa to make sure her apartment number is showing. You can also go to the second page to make sure the new page starts with a different name.
Now you are ready to print them! Let me know if you would like to see any other tutorials when it comes to mail merge in Word 2010 by leaving your comments below. Ready to test your skills in Excel? See how they stack up with this assessment from. Start this test now. Contributor Gosia Grabowska (MCTS Active Directory, MCTS Vista, Network+, Linux+, Project+, PMP) is an experienced Network Support Specialist and an expert in Windows Server support.
She graduated from DePaul University, Chicago with a Bachelor degree in Network Technologies with highest honors. Gosia has over 8 years of technical and support experience and has worked as Systems Administrator for a high profile law firm, where she managed the Backup and Disaster Recovery plan. Gosia has been a part of the Train Signal team since 2006 as the Product Manager and has written many articles on a variety of topics, including Exchange Server 2007, Windows Vista, Small Business Server, and more.