A table appears.
The insertion cursor should be blinking in the upper-leftmost cell, which will be the only empty cell in the table. You may have to drag the bottom scroll bar to see the blinking cursor. Navigate to the Excel. Select the worksheet or range that has the names and addresses for the data source, and then click OK. Your Word mail merge document is now linked to the worksheet or data range data source in the Excel workbook.
The Mail Merge popup menu has a ton of options that will make for an easy data import from Excel. From this menu, click the Create New button to start a new Mail Merge.
You'll be prompted to select a document type: a letter, label, envelope, or catalog. For this tutorial, we'll be using labels. Select the printer you'll be using to print these labels. You can do this by looking under the Printer Information option. You can select the type of paper you'll be using in the Label Products option.
You'll then be prompted to select your Excel document containing addresses from your Mac's file structure. You can now customize the rest of the options as necessary: adding placeholders, filters, and customizing other options.
Press the Return key on your keyboard to initiate the Mail Merge, and voila! For just an address, select Address block. For more info, see Insert Address Block dialog. For other merge fields, select Insert Merge Field. For more info, see Insert mail merge fields.
Format the fields in the first label so it looks the way you want the rest of your labels to look. Select Update labels when done if you make changes.
To create a page of labels with graphics, see Add graphics to labels. To add barcodes to your mailing list labels, see Add barcodes to labels. In the Label Options dialog box, choose your label supplier in the Label products list.
If you don't see the outline, go to Table Layout and select View Gridlines. Choose Preview Results again to view, add or remove merge fields. Create and print labels. Create a data source for a mail merge. When you perform a mail merge, Word inserts the records from a data source, or recipients list, into your main document.
Use mail merge to quickly create a sheet of address labels in Word for Mac to send a mass mailing to your address list. There are three files involved in creating and printing letters or emails or labels or envelopes using the mail merge process.
A recipients list for a mail merge operation can be an Excel sheet, the Office Address Book, a FileMaker Pro database, a Word document, or a delimited text file. For more information about how to set up a recipients list, see Create a data source for a mail merge.