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.
Look in the Print dialog box of Address Book it has templates for a wide variety of labels in: Layout/Label. You can import data from tab delimited text files, which you can export from Excel. See Importing contacts from other applications in Address Book Help. For years I have used DesignPro from Avery to do labels on my old PC. However, it is “toast,” and I have struggled to do the labels in various softwares on my Mac. Your tutorial was accurate, clear and concise and led me to get my mailing out in just a couple minutes.
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.
This product requires a valid product activation key for download. • After the product key is verified, select a product language from the menu. • Sufficient data storage available on a Computer, USB or external drive for the download. Follow these steps to download Office • Enter the 25-character product key that came with your product purchase in the field below. Please refer to the following link for available upgrade options: To download and install Office 2013 for a single PC, Office 2016 for a single PC and Office 2016 for a single Mac go to Before you begin Make sure you have • Your Office product key (xxxxx-xxxxx-xxxxx-xxxxx-xxxxx). Older version of microsoft office for mac.
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. June 2017 apple promo codes for refurbsihed mac macbook pro.