To reuse the document with other Numbers data, select another Numbers document, and repeat steps 1 through 4.For each merge field, click the Target Name pop-up menu in the Merge window, and select a target.

Choose a Numbers document in the window that appears, and click Open.Choose Edit > Mail Merge, and then click Numbers Document.In the Help window, scroll down to: To insert merge data for one or more contacts using a Numbers document. Under the Pages Help Menu, type merging data.Ĭhoose Merging Data from Contacts, Address Book, or a Numbers Document This may help you to use a CSV file of addresses that you have saved in Numbers. You wrote: 'The last thing I want is a bunch of strangers clogging up my contact list.' The trick, and you only have to do this once if you save the result as a Template, is to design the Pages merge document to have the proper number of columns and the proper label field height so that the result matches your physical print media. Now you will have as many label fields on each page as will fit there. You then collapse the pages document by using Find and Replace to eliminate the Section Break characters.

You will get a number of Sections in the merged document equal to the number of records in your Numbers file, with one label on each Section/Page. When you do a Mail Merge from Numbers, choose to merge to a Pages document, not directly to the Printer. The size of the label field will be the same as one of the labels on your actual label sheet. The basic procedure using Numbers is as follows:ĭesign a Pages merge document with only one label field, and only one set of merge links. Merging from Numbers is a bit complicated to set up, and slightly more complicated to use than merging from Contacts, but it's a good solution for the reasons you stated. You should now have a full sheet of labels ready to print or save.You can avoid contaminating your personal Contacts if you do your business address list in another User Account. If not, select the field and press Command (⌘) + V.Ĭlear the Replace with field if it's not empty, and select Replace All. You should see «Next Record» in the Find what field. Press Shift + Command (⌘)+ H to open the replace dialog. If you see instead, Ctrl + click or right-click and select Toggle Field Codes. On one of the labels, highlight «Next Record», and press Ctrl + C. Select Update Labels to create a full sheet of labels. Select Labels, and then select Cancel (we're not really doing a mail merge.)

This way is more involved than the previous method, but it sometimes works better on some graphic elements.įollow the single label steps and create the label in the first position on the sheet.

How to do mailing labels on a mac