Autofill Mailing Label Template (Mail Merge) in Apple Pages from Apple Numbers Spreadsheet

Posted on 2013-11-06
Last Modified: 2013-11-07
I recently received the following request from a client of mine:

"I'm looking specifically for an experienced iWorks-Pages user who can create a Pages template for a pre-printed mailing label I order from VistaPrint. My goal is to be able to easily Mail Merge customer data from Numbers into the new template and print the labels. I'm experienced merging data for letters and envelops but custom labels… not so much."

Sample label with dimensions is attached.

Does anybody have a solution or any ideas for this? I realize the latest version of Pages which Apple released at the end of October (version 5.0) removed many of the features which were included previously in the Pages app.

Any and all thoughts are greatly appreciated. Thank you in advance for your help!
Question by:simdex
LVL 40

Accepted Solution

Eoin OSullivan earned 500 total points
ID: 39629611
Mail Merge is gone from the latest Pages but if you have the previous version Pages '09 (v4) then you can still do it.  You can get Pages templates for Avery labels here - but they are not suited for mail merge with multiple entries per page.

Pages DOES NOT have support for doing labels from a Mail merge .. it is designed to have 1 set of merged data per page.  This is fine for envelopes but doing a 4-up, 6-up or 8-up layout of labels is not an easy thing to achieve - but it is possible with some creative workarounds.

There are 2 ways to do it
First is to create a document the size of ONE label in Pages and use Mail Merge to import the data and create an 8 page document for 8 labels.  Then use Avery DesignPro for Mac (free download on to convert the 8 page document into a 1 page document with 8 labels on it.

Second is to do it within Pages and get a set of labels on the same page.
Change the dimensions to of the document suit your label sheet if it is not US Letter or A4
1. Inspector > Document > Document Margins > set the top & side margins
2. Inspector > Layout > Layout > Columns: 2 > Gutter: 0
3. Click in the top of the left hand column and then insert a TextBox element
4. Toolbar > Text Box > Inspector > Metrics > Size > set the height and width of one label
5. Inspector > Wrap > Object Placement > Inline > Object Causes Wrap : 2nd icon > Extra Space: 0pt - this will force the labels to move inline inside the columns
6. Inspector > Graphic > Stroke > None  - so you cannot see the label border when printing
7. Inspector > Links > Merge > Choose… > browse to Numbers spreadsheet
8. Click inside the box Menu > Insert > Merge Field/Sender Field > Select appropriate fields  also add any other textboxes and elements .. group them together.  Save this document as a TEMPLATE in Pages for future use.
9. Pages generates a multipage document with one label per page  
10. Delete all the Section Breaks separating each label on each page:  Menu > Edit > Find > Find… > Advanced > Find: > Insert > Section Break… > Replace: empty > Replace All
The text boxes then stack into place .. 2 columns and x per page depending on the label size.

A little experimentation may be required to get them to match the label sheets

Author Closing Comment

ID: 39631015
Very helpful and comprehensive.

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question