Note: Some of the content in this topic may not apply to some languages. There are three documents involved in creating and printing envelopes using the mail merge process: • Your main document This is the document you use to set up the layout of the envelopes in the mail merge. You can also set up any content—such as a company logo or your return address—that you want repeated on each envelope. • Your mailing list Your address list is the data source that Word uses in the mail merge. It's a file that contains the addresses to be printed on the envelopes. • Your merged document This document is a combination of the main document and the mailing list that is used to print individual addresses on the envelopes. The address list can be an Excel spreadsheet, a directory of Outlook contacts, or an Apple Address Book.
Mail Merge is an absolute godsend when it comes to printing labels and sending. Best photo organizer for mac. To start, launch Microsoft Word on your Mac and click into the Tools menu from. Menu has a ton of options that will make for an easy data import from Excel. This tutorial explains how to mail merge and make labels from Excel data. You will learn how to prepare your Excel address list for mail merge, set up the Word document, make custom labels, print them and save the file for later use.
It contains the records Word pulls information from to build the addresses for the envelopes. • If you don’t yet have a mailing list, you can create a new list in Word during mail merge. Before you start the mail merge process, collect all of your address lists. • If you're using an Excel spreadsheet, make sure the column for ZIP Codes or postal codes is so that you don't lose any zeros.
• If you want to use your Outlook contacts, make sure Outlook is your default email program. • On the Mailings tab, choose Start Mail Merge > Envelopes. • In the Envelope dialog box, leave the Delivery Address blank, and under Return Address, do one of the following: • Choose Use my address to use your address from your email contact list. • Choose Omit to leave the return address blank. • Choose both options ( Use my address and Omit), and type the return address you want to use. • Format the Return Address by choosing Font or Position, and then make the changes you want.
• In the Envelope dialog box, under Printing Options, choose Page Setup. • In the Page Setup dialog box, in the Paper Size list, choose the option that matches the size of your envelope. Tips: If none of the options match your envelope's size, do the following: • At the bottom of the Paper Size list, choose Manage Custom Sizes. • Click + (plus symbol) to add a new list item. In the Page Setup dialog box, double-click Untitled, and then type a name for your envelope. • Enter your envelope's dimensions in the Width and Height boxes, and then choose OK.
![Data Data](https://edg.uchicago.edu/tutorials/making_labels/2.png)
• In the Page Setup dialog box, next to Orientation, choose Landscape > OK. • Choose OK to close the Envelope dialog box. • On the File menu, choose Save.
• On the Mailings tab, choose Select Recipients. Tip: To change the order of the fields, choose the field you want to move, and then use the up or down arrows to move the field.
• When all fields are set up as you want, choose Create to make a new list. • Use an Existing List • Browse to the file you want to use and choose Open.
• In the Open Workbook dialog box, select the sheet you want to use, and then do one of the following: • Leave Cell Range blank to use the entire worksheet. Or • Enter a cell range for the data you want to use. • Choose from Outlook Contacts • Choose Filter Recipients to select the recipients you want to include. • In the Query Options dialog box, next to List mail merge recipients by, choose Complete record. • In the list of contacts, select the contacts you want to include in the mail merge, and then choose OK. • Apple Contacts • Choose Filter Recipients to select the recipients you want to include. • In the Query Options dialog box, under Apple Group Contacts, choose the group you want to include in the mail merge, and then choose OK.