how to mail merge labels from excel to word on a mac

This was harder to figure out, but I was exploring the idea that each label needed to be its on text box, rather than the table that the imported Avery Labels template generated, then came across this website: It confirmed the idea of text boxes, but made my design issue a little bit more complicated, since the two or three column document approach wouldn't allow for graphics per text box.

I also needed logos to print per name tag. I was doing name tags, not mailing labels, so needed the first name larger than last, but also to be able to split the company name to two lines if necessary. I could of done this in FileMaker pretty easy, but I needed the output to be tweekable. I was able to get Pages to mail merge designed labels.įirst, the issue of design. With a lot of playing around and a fair amount of research as well. I just had a go at this in Pages, and Edit > Mail Merge is greyed out. Sheesh, finding Mail Merge in Help is not easy! On this topic, the Pages09 User Guide is as useless as tits on a bull.

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 can avoid contaminating your personal Contacts if you do your business address list in another User Account.

How to mail merge labels from excel to word on a mac