

- #How to make mailing labels from outlook for mac contacts how to#
- #How to make mailing labels from outlook for mac contacts full#
Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.īelow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature. Prepare Excel spreadsheet for mail merge.

Today let's see how you can leverage this feature to mail merge and print labels from an Excel spreadsheet. Last week we started to look into the capabilities of Word Mail Merge.
#How to make mailing labels from outlook for mac contacts how to#
You will learn how to prepare your Excel address list, set up a Word document, make custom labels, print them and save for later use. That’s it! Most of the work comes in selecting people, making sure their addresses are right, and updating those that have changed-actually printing labels takes only a few minutes.The tutorial explains how to do a mail merge from an Excel spreadsheet for labels. Once you’ve fixed addresses for everyone who has moved recently and verified your positioning, you can print for real on your label stock.If not, make sure you’ve chosen the right label in the Print dialog, and if all else fails, create a custom label with your own margins and gutters to make it work.

You should be able to see whether the positioning is right-it should be in most cases. You’ll use this draft for two things-checking the addresses for accuracy and verifying that the labels will print properly on the label stock.To check if the labels will print correctly, stack a page from the draft on top of a sheet of blank labels, and then hold them up to a bright light or sunlit window. It’s time to print, but not on your label stock just yet! Click the Print button to print a draft of your labels on plain paper.Although the defaults are fine, if you want, you can change the color of the label text, select a small image to print next to each contact, and change the font.You can also choose to print company and country here, and if you print country, you can exclude your own country, which makes it easy to include overseas friends and relatives without printing the country for most people. Home is likely the most appropriate if you choose All, Contacts will print both Home and Work addresses if available. From the Addresses pop-up menu, choose the type of address you’re using. Click Label to switch to the Label view.(Avery 5160 is the most common label type and is readily available at office supply stores and online.) Beneath the Style pop-up menu, make sure Layout is selected, and then in the Layout view, from the Page pop-up menus, choose the manufacturer of your labels and the number associated with the labels.Then from the Style pop-up menu, choose Mailing Labels. You also need to see the special controls for Contacts, so make sure Contacts is chosen from the pop-up menu underneath the page range fields. To set up your cards, you need to see details in the Print dialog, so at the bottom of the Print dialog, click the Show Details button (if it’s already called Hide Details, you’re all set).

Once the Holiday Cards group is populated with all your recipients, click its name in the sidebar, and then choose File > Print to open the Print dialog.This doesn’t move contacts out of All Contacts-you’re just adding them to the Holiday Cards group, which functions much like an iTunes playlist. You can drag contacts one at a time or select several at once and drag the entire selection. Note that you have to click and hold briefly before Contacts lets you start dragging a contact if you drag too soon, Contacts assumes you want to select more contacts.
#How to make mailing labels from outlook for mac contacts full#
