1 2 Previous Next 19 Replies Latest reply: Dec 17, 2011 1:48 PM by jhstarr Go to original post
  • 15. Re: Mail Merge: Postcards - Merge to the Next Record?
    Douglas Miner Level 1 Level 1 (5 points)

    I tried this and it only import 1 set of data fields. How can I get it to pint the entire database? Thanks.

  • 16. Re: Mail Merge: Postcards - Merge to the Next Record?
    Douglas Miner Level 1 Level 1 (5 points)

    Never mind. They were all there. Thanks.

  • 17. Re: Mail Merge: Postcards - Merge to the Next Record?
    Level 8 Level 8 (41,760 points)

    May you tell us if there are date entries in your Numbers document ?

     

    I explained several times that the Merge tool doesn't accept this kind of datas.

     

    If a merge Field entitled myDates contains date entries, change the column header from myDates to my_Dates,

    insert a new column whose header would be myDates

    and, in the first standard cell of this column, insert the formula :

    =""&my_Dates


    apply Fill Down to fill the other cells ofv  the column.

     

    Back to the Merge tool, check that the merge Field is correctly pointing to the column myDates

    After that I guess that you will get all your labels.

     

    Yvan KOENIG (VALLAURIS, France) jeudi 15 septembre 2011 18:12:12

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

    My iDisk is : <http://public.me.com/koenigyvan>


    Please : Search for questions similar to your own before submitting them to the community

  • 18. Re: Mail Merge: Postcards - Merge to the Next Record?
    jhstarr Level 1 Level 1 (0 points)

    Immensely helpful, ElViejo1939.  Thank you very much.  (I just wish Apple placed the cookies on a lower shelf.)

  • 19. Re: Mail Merge: Postcards - Merge to the Next Record?
    jhstarr Level 1 Level 1 (0 points)

    Summarizing what worked for me...

     

    How to create mailing labels by merging addresses from a Numbers workbook into a Pages mailing label document.

     

    (Credits to Yvan Koenig and ElViejo1939 )

     

    _____

     

    The dimensions given in these instructions are for Avery 8160 which are 1" tall and 2.625" wide, a 3 x 10 grid of labels per page. 

     

    Here's your one-time set up the Pages document.  You don't have to repeat this unless you change to a different sized label.

     

     

      1. Open a new, blank document.

     

      2. Inspector > Left-most tab > Document: Set Margins as in this picture. Ensure headers and footers unchecked. IMG_0451.png

      3. Create 3 columns with dimensions shown in picture below. IMG_0452.png

      4. At the top of the left hand column, insert a text box the width of 2.625 and height of 1".

     

      5. Using the "Wrap" window in the inspector, set the text box characteristics to "Inline," "Object Causes Wrap" and "Extra Space" to 0 (zero) points.IMG_0455.png

      6. Put your merge fields inside the box as they do in this apple video tutorial . If you get the error message: "Please select a Numbers document that has one or more named header columns and one or more rows of data," here is the solution from Peggy.

    ______

     

    Each time you want to print labels with the Pages label document you just created, do the following:

     

      1. Update addresses in Numbers Address workbook.

     

      2. Create a column for current year and mark an "x" by those to whom we're sending.

     

      3. Copy this all records (not header) into PrintThisYear sheet. 

     

      4. Sort on "x".  Get rid of all rows without an "x".

     

      5. Open the Pages document you created above.

     

      6. Edit > Mail Merge. You'll get a multi-page document with one label per page.

     

       7. Bring up Find & Replace (Command-F) > Advanced. In the "Find" field use the "Insert" button to insert a Section Break (not a Page Break). Leave the "Replace" field blank. Do a "Replace All."IMG_0454-1-1.png

     

      8. Print out first page and hold up against blank labels with light behind to make sure it will print properly.

     

      9. Print labels out one page at the time.  (Prevents paper jams of label pages.)

    ____

1 2 Previous Next