Currently Being ModeratedJun 1, 2012 9:20 AM (in response to KathyCurran)
You can mailmerge from either AddressBook or Numbers into Pages.
If you need more fields than AddressBook provides, you can create the list "database" of names and addresses, created in Numbers.
In your Numbers spreadsheet, use the first row to create the named columns "fields" you're going to use for the merge. You can add additional columns "fields" that will not merged.
To make it easier to manage, try to keep the columns you intend to merge among the first few columns.
Currently Being ModeratedJun 1, 2012 10:49 AM (in response to kostby)
I stepped away from the computer for a few minutes and somehow the session timed out and posted before I completed it! Then I couldn't get back in to edit the post.
I 'recycled' an Apple worksheet for this example, adding a few fields, rather than create a real one from scratch.
Note there are additional columns/fields to the right that won't be used for a name/address merge.
Once you've got the database set up in Numbers, open Pages and create your letter.
Then it's time to insert the merge fieldnames into the Pages document.
Enter the field names exactly as you entered the column names in Numbers.
If you're unsure of exact field/column names, you can leave blank spaces where you'll enter linked merge field names and link them in the next step, as shown below. (I let the Inspector show the field names.)
Click on Inspector, Link Inspector (the blue button at the second from right), and the Merge tab.
That asks you to select the merge source, in this case, the Numbers spreadsheet/database you created already.
Click Choose, and select it.
If you have more than one Table or worksheet in the Numbers document, choose the correct one.
Then, place the merge fieldnames into the Pages document.
Move the cursor to the appropriate place in the Pages document.
Click the field names in the Inspector/LinkInspector/Merge pop-up.
It will default to the first fieldname on the left until you click the desired field in the right column.
Once all fieldnames are placed, save your Pages document before attempting to Merge.
That way, if it somehow crashes or doesn't work, you don't have to re-select and link the fields again, you can go back and correct.
To create the merged document in Pages, select Edit, MailMerge.
Again, you specify the Numbers file, Table, and worksheet.
It's a good idea to merge to a new document.
The result should be a new multi-page document, one page for each row in your Numbers file.
If it doesn't work correctly, you can go re-edit the original Pages file.
Currently Being ModeratedJul 17, 2013 9:06 AM (in response to donnafromaddison)
Pages does not have a simple 'next record' mailmerge command like Microsoft Word.
This prior discussion might be helpful.
ElViejo1939's suggestion is to first create the document, load the merge data, save the new merged document, and then search and replace Section Break with null to return the document to multiple 'labels' per page.
NOTE: I did try ElViejo1939's suggestion with an existing Address Book database, but it didn't work as described for me.