Ĭreate mailing labels by using mail merge Complete Merge, choose Merge to New Document. To create a document that contains your merged envelopes that you can save, in Mail Merge Manager, under 6. To print your envelopes immediately, in Mail Merge Manager, under 6. To finish creating your envelopes, do one of the following: In your main document, edit the envelope's address box to add spaces and carriage returns where you want them. Repeat Step 4 for all the fields that you want to appear on your envelopes. Insert Placeholders, choose Contacts.ĭrag a field name from the Contacts list (for example, FirstName) to the envelope's address box. Select Recipients List, choose Get List, and then select the source for the mailing list (for example, an Excel spreadsheet or a Word document). On the Tools menu, choose Mail Merge Manager. Under Printing Options, confirm the correct print settings for your envelopes are selected. If you can't type inside the Return address box, clear the Use my address check box, and then try again. In the Header Record Delimiters dialog box, choose a field delimiter to separate each data field and a record delimiter to separate each data record, and then choose OK.Īt this point, you shouldn't type anything (including spaces) in the Delivery address box. 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. In the list of contacts, select the contacts you want to include in the mail merge, and then choose OK. In the Query Options dialog box, next to List mail merge recipients by, choose Complete record. Leave Cell Range blank to use the entire worksheet.Įnter a cell range for the data you want to use.Ĭhoose Filter Recipients to select the recipients you want to include. In the Open Workbook dialog box, select the sheet you want to use, and then do one of the following: When all fields are set up as you want, choose Create to make a new list.īrowse to the file you want to use and choose Open. 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.

Mail merge from excel on a mac computer