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.
Continue with Step 3 until all labels are filled with your information.Position the cursor in the next label, right-click and select Paste.Highlight all the content in the first label, right-click and select Copy.Insert your information on the 1st label.How to create a sheet of all the same labels: Then click Text Wrapping and select In Front of Text in the drop down list.
Select your image in the template and click the Page Layout tab in the Ribbon Toolbar. Highlight the text you entered and use the tools in Microsoft Word to format the text.Ĭlick the Insert tab in the Ribbon Toolbar to insert your own image, clip art, shapes and more. Once the file is open, type your information into the template. If the template looks like a blank page, select Table Tools > Layout > Show Gridlines to view the template layout. Double-click the Avery Word Template file you downloaded and saved to your copmuter.
0 kommentar(er)
