Mail Merge: Postcards - Merge to the Next Record?

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

Here's how to get Pages 09 to print mailing labels from a Numbers spreadsheet. Example is for Avery 5163 (2 across, 5 down, each label is 2x4 inches). For other labels you'll have to fiddle with the dimensions.

1. Format a document with 0.5 margins all around, and two columns.

2. At the top of the left hand column, insert a text box the width of the column and 2.0 inches high.

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

4. Put your merge fields inside the box.

5. Do your merge. You'll get a multipage document with one label per page.

6. Bring up Find & Replace -> 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."

This will kill all the Section Breaks that Pages puts in (why did they do this?) and the text boxes will all slide into place, ten per page in this case.

Fabulous instructions!
I was able to adapt these for the Avery 5392 Name Tag (3x4").
Set Word Processing document to have 1 inch margins on top and bottom, 2 columns, and .5" side margins.
Created a text box 3.08 wide by 3 high and placed my merge fields.

Worked like a charm. Thanks!

ElViejo1939 wrote:
This will kill all the Section Breaks that Pages puts in (why did they do this?) and the text boxes will all slide into place, ten per page in this case.

Viejo,

I suppose Apple but a Section Break at the end of each Mail Merge record because it's Mail Merge, not Label Printer. It keeps the separate documents in a Mail Merge from running together. Keeps Page Numbering straight, etc.

Never the less, great technique and clear instructions.

Thanks,

Jerry

You are a genius! Thanks so much.

My goodness! I like to think I can work my way around things, but I too was tearing my hair out thinking of a solution/fix/work-around. That was pure GENIUS! Well done and thank-you. Love these forums!

Thank you ElViejo1939

Great example of lateral thinking.

I've added this as a completed tip here:

http://www.freeforum101.com/iworktipsntrick/viewtopic.php?p=402&mforum=iworktips ntrick#402

Peter

I am new to mail merging with Pages and Numbers (Appleworks was a piece of cake!)

I am good w/ your instructions up to 4. Put your merge fields inside the box. - when I click on Edit at that point, the mail merge option is not available to choose??

Printing labels and mail merges are a big part of my business computing!

Help is appreciated.

- Jill

oy, never mind! I'm adding the merge fields! :\

I still need help 😟 I was able to add the merge fields, did the find/replace, but nothing moved?

This is a drag 😟

+Menu > View > Show Invisibles+

Copy and paste what you find between the boxes into the Find/Replace dialog.

You are probably just searching on the wrong characters. If it can't find what is there, it can't delete them.

Peter

I just got it to work doing it a little differently!

Thanks for getting back to me!

- Jill
hoping I can replicate this!

Hallelujah - I did replicate it. The only thing I did differently than the instructions - I did not add any columns. I made my text box roughly the same size as the avery label I will print to (mailing labels). Put the text box in the upper left corner and proceeded as outlined. For me, I ended up w/ 3 columns & 10 rows, which is perfect.

Thanks for these instructions.

- Jill