Office for mac mail merge

broken image
broken image

NOTE: The default set of text placeholders used by the script, such as SENDERFIRSTNAME and recipientLastName, can be customized by editing the properties at the top of the script. Individual Contacts entries with incomplete required data will be skipped. By default Mailing Address is optional for recipients. The data requirements for the recipient contacts are: First Name, Last Name, and eMail Address. Make the card the default card by choosing Make This My Card from the Card menu.įor testing the script, create small Contacts group containing four to five people. Include First Name, Last Name, eMail address, Mailing Address, and Phone Number. In the Contacts application, create a default card containing the Mail Merge sender’s data. AppleScript with Pages, Contacts and Apple MailĪppleScript automation, involving three OS X applications: Contacts, Pages, and Mail, that will create and mail encrypted PDF files generated from a Pages template containing text placeholders. This answer may not be the best solution, but may be a good starting point and I hope it adds value. :/ This requires scripting, but the script can be saved and used repeatedly.

broken image

This solution I have used with some success after trial and error.