kascecreditcard.blogg.se

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











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

Lastly, and VERY IMPORTANT, save this file as a template. Your labels will appear as they should 6, 10, 30 per page.

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

FIND/REPLACE section breaks from the now multi-page document created after mail merge.I'm assuming you've already connected your numbers document and mapped field data. It will be created, 6, 10, 30 times, as needed. I copied and paste, the box and contents. Insert the textbox into the first column insertion point, as if you were typing.Design a textbox to the label size specifications from Avery.Create a document with the appropriate number of columns you need: one, two, three.If design isn't an issue, then the MOST IMPORTANT thing to remember is NOT to use tables. The quick find and replace, then had each name tag stack six per page, as expected. 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. 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 2008 on a mac