Shine a spotlight on sagacious solutions to your most maddening Mac maladies
Sage advice for the worst Mac maladies
Mail merge made easy
Q Can I do a mail merge using Apple’s Pages, or is there a better way? by Don Wilson A You used to be able to mail merge to print from Pages, but in recent years this has become increasingly difficult and you probably won’t get it to work now.
Major office suites normally still feature mail merge to print. It has always been an important benefit of Microsoft Office, and Microsoft has a series of excellent tutorials at https://support.office.com/en-gb/article/ Mail-merge-507b5468-f771-485d-9ef027857168a266, which shows this being performed in Word 2013. The current Word version 15 for macOS can be used similarly. OpenOffice.org, which is free for macOS, supports this, with a complete tutorial at bit.ly/office_mail_merge. That suite includes a wizard which steps you through the process, and provides previews. Essentially, you store details of the addressees in a spreadsheet or database, using standardised field names. Those match marked up insertion points in your word processor document: for example, the field ‘title’ might be marked up as <title>. When you perform the merge, copies of the document are generated which substitute personalised information for the mark-up, in the required number of pages. Address labels should also be produced ready for printing.
If you want to send merged email messages rather than printed letters, two apps from the App Store which you should consider are Mail Merge and SerialMailer. There’s a demo version of Mail Merge available from its support site, while a Lite version of SerialMailer from the App Store should give you a good idea of how that works.