Do more with your Apple gear
Apple’s iWork apps lack mail merge but it’s possible in Pages and Numbers
If you’ve ever had to send a letter to multiple recipients, each displaying the recipient’s name and address, possibly with a personalised greeting, you’ll understand the value of mail merge.
Mail merge allows you to write a letter once, select the group of people you want to send it to, and allow whatever software you’re using to create and save individual instances of the letter. It’s a lot quicker and less labour intensive than copying and pasting yourself.
Microsoft Office has the ability to mail merge, but Apple’s iWork apps don’t have it built-in. Fortunately there’s a way to create letter templates in Pages, and a table of names and addresses in Numbers, and those will mail merge – thanks to iWork’s support for AppleScript.
Pleasingly, you don’t have to write the script yourself, thanks to the OS X Automation spin-off website, iWork Automation (iworkautomation.com). Here you’ll find a tool, Pages Data Merge, which uses placeholders
Mail merge is a lot quicker and less labour intensive than copying and pasting them all yourself
you define in Pages and table rows you specify in Numbers, to generate mail merged documents.
So firstly, visit iworkautomation.com/ pages/script-tags-data-merge.html and download the Pages Data Merge tool. Double-click the archive and drag the app to Applications. Kenny Hemphill
With a table of recipient data in Numbers and defined placeholders in Pages, you can mail merge in iWork.