DISPLAY OPENING DIALOG WITH SETABLE PREFERENCESĭisplay dialog "This script will perform a Mail Merge between a Pages tagged-template and a chosen Contacts group." & return & return & "Contact data requirements for the sender are: First Name, Last Name, eMail Address, Mailing Address, and phone." & return & return & "Contact data requirements for recipients are: First Name, Last Name, and eMail Address. Property recipientFullAddressPlaceholder : "RECIPIENTFULLADDRESS"
How to mail merge outlook mac for mac#
At first, you need to create a new email message in Word for Mac and use the Mail Merge feature to send an email to multiple email accounts. Property recipientLastNamePlaceholder : "RECIPIENTLASTNAME" Based on my experience, you need to open Word for Mac or Excel for Mac to use the Mail Merge feature. Property recipientFirstNamePlaceholder : "RECIPIENTFIRSTNAME" Property senderPhoneNumberPlaceholder : "SENDERPHONENUMBER" Property senderFullAddressPlaceholder : "SENDERFULLADDRESS" Property senderEmailAddressPlaceholder : "SENDEREMAILADDRESS" Property senderLastNamePlaceholder : "SENDERLASTNAME" Property senderFirstNamePlaceholder : "SENDERFIRSTNAME" TIP: If you want to use this script often, install it into the system-wide Script Menu. Open the script in the AppleScript Editor application and run the script. The only requirement for their design, is that a placeholder must be a unique continuous string of text characters, not found as part of other words, and that a placeholder not contain spaces, numbers, hyphens, punctuation, or word delimiters. 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.
How to mail merge outlook mac pdf#
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. This solution I have used with some success after trial and error.