Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Posted on 2013-11-06
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 41

Accepted Solution

Eoin OSullivan earned 2000 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 - http://www.iworkcommunity.com/content?c=6 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 Avery.com) 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Are you looking to clear some space on your phone for the latest iOS 8 update? Did you switch to Spotify so you no longer need to keep music native on your phone? Run out of space for taking photos while in the middle of vacation? Sometimes the quic…
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
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…

636 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