Skip navigation

Mail Merge-creating same label multiple times

2362 Views 7 Replies Latest reply: Apr 29, 2013 6:18 AM by irishpat RSS
Josh in Guelph Level 1 Level 1 (0 points)
Currently Being Moderated
Jul 8, 2012 9:33 AM

Hello I am trying to create a mail merge froma pages template that has four invitations per page.  Whn I do the merge each page, so all four invitations has the same person and their information.  each page then has a new person.  I do not need four inviations for everyone, just one with each page containing four individual invitations.

 

Any suggestions

 

Thanks

iMac, Mac OS X (10.7.2), upgraded to 4GB of Ram
  • fruhulda Level 6 Level 6 (14,760 points)
    Currently Being Moderated
    Jul 8, 2012 10:57 AM (in response to Josh in Guelph)

    Sadly that is the way Pages works. What you can do is in the Page Setup create a custom page size of one invitation card.

  • PeterBreis0807 Level 7 Level 7 (27,360 points)
  • Geoff Holt Level 1 Level 1 (15 points)
    Currently Being Moderated
    Oct 19, 2012 1:39 PM (in response to PeterBreis0807)

    Peter, thank you so much for this post! This makes it truly a mail merge function. For those of you that haven't checked it out, follow the instructions in the link Peter posted. It's essentially doing the full mail merge, which creates a new document with one record per page, and then using the Find and Replace function in Pages to delete the section break.

     

    Thanks again!

    PeterBreis0807 wrote:

     

    There is a way round Pages default:

     

    http://www.freeforum101.com/iworktipsntrick/viewtopic.php?t=245&highlight=labels &mforum=iworktipsntrick

     

    Peter

    Pages, Mac OS X (10.7.5)
  • Saliente Level 1 Level 1 (0 points)
    Currently Being Moderated
    Nov 25, 2012 9:19 AM (in response to Josh in Guelph)

    I was having the same issue and found an even more simple way to fix it. This is likely the way pages was intended to be used. When you mail merge your addresses, each addressed document will be its own page. For example, I have a postcard with the mail merge fields I require and 4 contacts. I click merge and I get a new document with 4 seperate pages. When you go to print under layout you will see "Pages per Sheet". I put this to 4 pages per sheet and I get seperate contacts on the same sheet! It works awesomely. I'm using the "A6" page size which is post card size. You can go up to 16 pages per sheet and change the layout. I hope this helps.

     

    Tom

     

     

     

    Screen Shot 2012-11-25 at 12.07.01 PM.png

  • irishpat Level 1 Level 1 (0 points)
    Currently Being Moderated
    Apr 28, 2013 10:43 AM (in response to Geoff Holt)

    I am new to Pages '09 and am trying to do labels.  I used an Avery 8161 as a template and created a separate list in Contacts.  I used the mail merge and all is well except that each address appears on a separate page.  I am trying to do the find and replace to delete the section breaks but it does not find any or I am not doing something correctly.  I followed the instructios from that iworkstipsntrick but nothing happens.  I did the show invisibles but I do not see anything that looks like a section break.

     

    I know that I can do labels from Contacts but I would prefer to set up labels with image and fonts selected and save it so that I do not have to do that each time.  This is why I am trying to get it set up in Pages '09.

     

    I have included a screen shot-hope this helps. Thanks for any suggestions.

    Screen Shot 2013-04-28 at 1.38.30 PM.png

  • irishpat Level 1 Level 1 (0 points)
    Currently Being Moderated
    Apr 29, 2013 6:18 AM (in response to irishpat)

    Well-I finally found a way to fix this.  I still couldn't find section breaks to delete but what I did was cut and paste into each label and then deleted the extra pages as I went along.  It was only 29 labels so it wasn't that much of a big deal.

     

    I certainly wouldn't want that as a work around if I had a huge label list.

     

    The labels now appear to be all on 2 sheets of labels and I was able to change the font and add a small picture so I am good to go.  I didn't actually print them but they look like they should print OK.  This way I do not have to remember what font and picture to use if I used Contacts.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (1)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.