Next time I have to send out my personalized bookplates, I’ll be glad to be able to let Pages do the heavy lifting. Sure, not everybody needs Mail Merge, but for those who do, having it built in and no longer requiring you jump through a series of hoops is a huge relief. It’s been one of the missing features most often pointed out when comparing to other word processors, like Microsoft Word. This is hugely useful for anybody who not only needs to print and send out large amounts of mail (such as envelopes or even holiday cards), but also anybody creating large numbers of customized documents. (The feature’s also available for the first time in the iOS and iPadOS versions of Pages, under the three dots menu: tap Mail Merge to start the process.) On the Mac, just create a template with the File > New command or open an existing one, and then choose File > Mail Merge to step through the process.
Version 12.1, released today, brings a brand new implementation, however, which lets you populate a template document either from your contacts or a spreadsheet. In the interim, Mail Merge remained possible only via workarounds like Sal Soghoian’s Pages Data Merge app. The feature was originally included in Apple’s word processing software, but got the axe in 2013’s version 5.0, when Apple redesigned its iWork suite to give even footing across the iOS, iPadOS, and macOS platforms. Mail Merge in Pages for the first time on iOS. Because, yes, Mail Merge has returned to Pages. Pages’s reimplented Mail Merge feature on macOS.Īfter almost a decade, I guess it’s time to pack in my posters, stickers, and Tim Cook and Craig Federighi phone call scripts for the “Bring Mail Merge back to Pages!” campaign 1 and declare victory. For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge.Mail Merge returns to Pages after nine years Connect and edit the mailing listĬonnect to your data source.
The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. The first thing you do is create an Excel spreadsheet, creating a header. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. Mail Merge is a handy feature that incorporates data from both Microsoft Word. Here are some tips to prepare your Excel spreadsheet for a mail merge.
0 kommentar(er)
