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

How do I use Mail Merge to print Address labels from a Numbers spreadsheet of names.

I have a Numbers spreadsheet of 31 contacts. I can set up the label with the headings just fine. But when I do the Mail Merge in Pages, I end up with 31 pages with one label on each separate page! How do I get all of the labels on one sheet? (Meaning a sheet of labels of different names and addresses, not a sheet of labels of one person's address) - I have used Avery.com for a Numbers mail merge, and it is not the ideal solution for my needs. If you know how to do this mail merge in Pages, that is ideal for the project I am working on. Thank you in advance!

Windows, Windows 10

Posted on Jun 3, 2023 4:29 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 3, 2023 4:59 PM

Here's one potential method to accomplish this ... but it does rely on purchasing a third-party app.


Pages on its own doesn't directly support Mail Merge functionality like Microsoft Word does. However, you can create a workaround using the Data Merge app, which is available on the Mac App Store.


Data Merge takes a CSV file (which you can export from Numbers) and merges it with a Pages document.


Here's a step-by-step guide on how to do this:


1. Prepare your Numbers document:

- Ensure your Numbers spreadsheet is correctly formatted. The first row should contain the 'field' names (e.g. "First Name", "Last Name", "Address", etc.)

- Each row underneath should contain the corresponding information for each contact.

- Save and close your Numbers document.


2. Export the Numbers document as CSV:

- Open your Numbers document, click on 'File' and then 'Export To'.

- Choose 'CSV' and then 'Next…'.

- Choose where you want to save your file and then click 'Export'.


3. Prepare your Pages document:

- Create a new Pages document with the desired label format.

- For each field you wish to include (e.g. Name, Address, etc.), type the field name exactly as it appears in your Numbers document, enclosed in angle brackets. For example, "<First Name>".


4. Use Data Merge:

- Install and open the Data Merge app.

- Click on 'Choose' under 'Data Source' and select your exported CSV file.

- Click on 'Choose' under 'Pages Document' and select your prepared Pages document.

- Under 'Output', select 'Multiple Pages' if it's not already selected.

- Click 'Merge'.


5. Print your labels:

- Open the newly created Pages document.

- Check that all of the data has transferred correctly.

- Now you can print your labels.

Similar questions

1 reply
Sort By: 
Question marked as Top-ranking reply

Jun 3, 2023 4:59 PM in response to AriZari018

Here's one potential method to accomplish this ... but it does rely on purchasing a third-party app.


Pages on its own doesn't directly support Mail Merge functionality like Microsoft Word does. However, you can create a workaround using the Data Merge app, which is available on the Mac App Store.


Data Merge takes a CSV file (which you can export from Numbers) and merges it with a Pages document.


Here's a step-by-step guide on how to do this:


1. Prepare your Numbers document:

- Ensure your Numbers spreadsheet is correctly formatted. The first row should contain the 'field' names (e.g. "First Name", "Last Name", "Address", etc.)

- Each row underneath should contain the corresponding information for each contact.

- Save and close your Numbers document.


2. Export the Numbers document as CSV:

- Open your Numbers document, click on 'File' and then 'Export To'.

- Choose 'CSV' and then 'Next…'.

- Choose where you want to save your file and then click 'Export'.


3. Prepare your Pages document:

- Create a new Pages document with the desired label format.

- For each field you wish to include (e.g. Name, Address, etc.), type the field name exactly as it appears in your Numbers document, enclosed in angle brackets. For example, "<First Name>".


4. Use Data Merge:

- Install and open the Data Merge app.

- Click on 'Choose' under 'Data Source' and select your exported CSV file.

- Click on 'Choose' under 'Pages Document' and select your prepared Pages document.

- Under 'Output', select 'Multiple Pages' if it's not already selected.

- Click 'Merge'.


5. Print your labels:

- Open the newly created Pages document.

- Check that all of the data has transferred correctly.

- Now you can print your labels.

Reply

How do I use Mail Merge to print Address labels from a Numbers spreadsheet of names.

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