To add more lines to your label, press Return or Enter and then select another field from the Insert Merge Field pop-up menu.ĭo not click the Insert Postal Bar Code button. When the Edit Labels dialog opens, you see an empty Sample Label with a blinking insertion cursor.Ĭlick the Insert Merge Field pop-up menu and choose the field that will be on the left of the top row of the label. In the Mail Merge Manager, click Edit Labels. Your Word mail merge document is now linked to the worksheet or data range data source in the Excel workbook. Select the worksheet or range that has the names and addresses for the data source, and then click OK. Navigate to the Excel (.xlsx) workbook you’re using as the data source and click Open. In the Mail Merge Manager, click Select Recipients List and then choose Get List→Open Data Source. Section 1 of Mail Merge Manager now displays the name of the Main Document and which type of merge you’re performing. You may have to drag the bottom scroll bar to see the blinking cursor. The insertion cursor should be blinking in the upper-leftmost cell, which will be the only empty cell in the table.
Don’t make any adjustments to the table or click in the table. In the Mail Merge Manager, click Select Document Type and then choose Create New→Labels.įrom the Label Products pop-up menu, choose the product.įrom the Product Number list, select the correct number for your labels.Ĭlick OK to close the Label Options dialog.Ī table appears. To make labels from Excel or another database, take the following steps: Get ready by preparing an Excel workbook with a data range or table that’s set up as a mailing list and a new, blank document in Word. You can use an Excel workbook as your Word 2011 mail merge data source in Office 2011 for Mac. Learn the basics of using Microsoft Excel for Mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. I am using MacOSX High Sierra version 10.13.2 (latest update) on a iMac 21.5' late 2015.
Mail Merge Office 2016 for Mac Mail Merge between Word and Excel is going extremely slow and often opening a document where in the Mailings tab all the options are greyed out.
0 kommentar(er)
