How to do a mail merge with avery labels

How to do a mail merge with avery labels full#

The Find and Replace of all the section breaks, that created multiple documents.

This is where STIR/AGIR's website, linked above, was invaluable. Next, and this was the main issue, after the design was completed and tested, merging the file produces 100+ pages of individual name badges. You'll need to set all the correct margins yourself. Just two columns, with the following grouped items inserted right at the text insert area. My template, for the name tags is a two column document, no tables or table cells. Copied and placed into the document that would be my template. So for the design issue, I created a new document, sized the text box, placed graphics, and added a second text box, also with a merge field, then grouped everything together. 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. This should be quicker than creating 200 new documents.You can avoid contaminating your personal Contacts if you do your business address list in another User Account. You can then split the document using the macro at and having propagated the labels, change the document type to 'Letter' and remove the Next record fields before merging to a new document. That is easy enough to achieve with mail merge, provided you have the data that will go into the labels, stored somewhere in a format that WordД¬an use.

How to do a mail merge with avery labels full#

While it is possible to make minor adjustments to cell dimensions, provided the label formats have the same number of labels per page, it is simply not practical to convert existing tables into new tables and transfer all theДЇrom your description it seems that you are producing full pages of labels with the same content in each label.