Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Mail Merge: Postcards - Merge to the Next Record?

Good Afternoon -
I have created a postcard document, and there are 4 postcards to one page. When I create a mail merge from a numbers document, it makes all 4 postcards on one page the same addressee. How can I make it move tot he next record in the same document. (I assume this is an issue for people creating labels as well).
I've scoured help and these forums and haven't figured it out.
Any suggestions would be much appreciated!
Lindsay

MacBook Pro Core i7, Mac OS X (10.6.4)

Posted on Sep 10, 2010 10:16 AM

Reply
Question marked as Best reply

Posted on Sep 10, 2010 10:26 AM

Pages only merges one set of data per page.

1. You can reduce the page to just one postcard and then export the set to pdf and drag the individual postcards back into Pages.

2. You can let the merge run and then delete the page breaks between the sets of merges to bring them back onto one page.

3. You can print the postcard designs as blanks, then reprint the address information on them directly from *Address Book* where you can merge multiple addresses to one page.

Peter
19 replies

Sep 15, 2011 9:12 AM in response to Douglas Miner

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

Dec 17, 2011 1:48 PM in response to Lindsay West

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. User uploaded file

3. Create 3 columns with dimensions shown in picture below. User uploaded file

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.User uploaded file

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."User uploaded file


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.)

____

Mail Merge: Postcards - Merge to the Next Record?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.