Mac|Life

HOW TO Merge contacts in Pages

-

Create a group

In Contacts on Mac, click File > New Group, give it a name and drag contacts onto it in the sidebar. You can’t create groups in iOS and iPadOS, but in Contacts on icloud.com, click “+” and New Group to create one.

A Numbers source

In Numbers on Mac, iOS or iPadOS, create a new document and add a table to it. Give the column headers the names of the fields you want to use in your document, such as first name, last name, street, postcode.

Populate table

Once you’ve created the table, add the details for the contacts you want to merge with your Pages document. You can type them manually or copy and paste. Save the document to iCloud when you’re done.

Create a letter

In any version of Pages, choose a letter template in the Template Chooser and click or tap Create to create a new document. Type the content of the letter, leaving the recipient’s details blank.

Mail Merge on Mac

In the right–hand sidebar, click on Document and then the Mail Merge button at the bottom of the window. Select Merge in the window that opens and then choose your new Contacts group from the menu. Click Merge.

Merge on an iPad

In Edit mode, tap the “…” icon and then Mail Merge. Tap Merge, then tap Contact under Sender and choose a sender. Tap Contacts under Recipient Informatio­n and choose the group you created earlier. Tap Merge.

Merge spreadshee­t

Click Document > Mail Merge > Merge. Choose “Add from Spreadshee­t”, navigate to the Numbers file and click Open. If the spreadshee­t contains multiple tables, make sure the table you want is selected.

Finish up

You’ll see two columns, Merge Field and Populate With. Click Select in the latter and choose which column from your spreadshee­t you want to use to populate that field. Or, click Don’t Use. When you’re done, click Merge.

Add fields

Letter templates have fields already in position. To add fields to any document, go to Document > Mail Merge and position the cursor where you want to add it. Click Add Merge Field and choose from the menu.

 ?? ??
 ?? ??
 ?? ??
 ?? ??
 ?? ??
 ?? ??
 ?? ??
 ?? ??
 ?? ??

Newspapers in English

Newspapers from Australia