-
All replies
-
Helpful answers
-
Oct 12, 2014 2:23 PM in response to Brian1355by Peggy,iWork '09, as well as iWork '08 & '06, work in Yosemite. Just be sure they are updated to the latest versions.
-
Oct 19, 2014 12:39 PM in response to dirkt68by dirkt68,Well... someone did an Apple Script for doing mail merge via a Numbers document
http://iworkautomation.com/pages/script-tags-data-merge.htm
Haven't tried it myself, for I have yet to reinstall the new iWork apps, but judging from the video, it looks ok
-
Oct 27, 2014 7:15 PM in response to dirkt68by Sal Soghoian,Here are the links for performing Mail merges with Pages 5.5:
Using AppleScript and a Contacts group:
<http://iworkautomation.com/pages/examples-mail-merge.html>
USING NUMBERS OR OTHER SPREADSHEET DATA:
<http://iworkautomation.com/pages/script-tags-data-merge.html>
-
Nov 3, 2014 6:36 AM in response to Sal Soghoianby dafid,Pages 5.5, which was installed on Oct 17 says in the release notes "AppleScript support for Mail Merge"
Any idea what that means?
-
Nov 3, 2014 7:35 AM in response to dafidby Sal Soghoian,Pages 5.5 includes new scripting support for locating and replacing text placeholders. In addition, text placeholders can be "tagged" in the application interface, with script identifiers by selecting the text placeholder to tag and entering its "script tag" in the the new Script Tag field available at the bottom of the More tab in the format sidebar. With this new ability, scripts can replace the text placeholders in a document with data from other sources, including Numbers spreadsheets.
But you don't have to write scripts to take advantage of this new feature!
To make it easy for non-scripters to perform Mail merges, and other automated data merging tasks, there is a free application, the Pages Data Merge application, available at: http://iworkautomation.com/pages/script-tags-data-merge.html
Watch the movie, follow the instructions, and give it a try!
In addition, if you want to work with contacts from the Contacts (Address Book) application instead of a spreadsheet, here's a link to an automation script for doing that:
<http://iworkautomation.com/pages/examples-mail-merge.html>
Cheers!
-
Nov 4, 2014 3:52 AM in response to dafidby peterehre,in response to Sal Soghoian
This is a good, but a little cumbersome solution and not as good as the solution in Pages 4. I miss also the possibly to use fields under some conditions. In your examples it would be useful to name the placeholder in the „scripttag“
I miss also a feature to indicate, if a template contains placeholders. It would be useful to identify this situation, for example by a comment in the template.
Remark: You are doing a great job with your automator work.
-
Nov 4, 2014 4:33 PM in response to John P.by Julius CJ,More than a year later nothing has changed. I was planning to step up with the new pages/numbers. Need mail merge for my invoices.Just keep om using Word/excel
-
Nov 4, 2014 10:51 PM in response to peterehreby Sal Soghoian,Open this script in the Script Editor and save it to the system-wide Script Menu. Anytime you want to check to see if the front document contains text placeholders, select the script from the Script Menu:
tell application "Pages"
tell front document
set placeholderCount to the count of every placeholder text
display dialog "This document contains " & placeholderCount & " text placeholders."
end tell
end tell
For information about how to turn on the Script Menu, visit: <http://iworkautomation.com/script-menu.html>
Thank you for noticing the Automator work. The new Keynote collection was a lot of fun to develop: <http://iworkautomation.com/keynote/automator/index.html>
-
Dec 20, 2014 7:36 AM in response to dirkt68by raoflorida,I never thought I'd say this but I'm getting more and more impressed with Microsoft every day and less impressed with Apple. They keep making things harder to do and keep removing features. I couldn't believe it when I went to do a mail merge today and I found out they removed the feature.
-
Dec 20, 2014 8:03 AM in response to raofloridaby peterehre,Although I am not satisfied with pages 5.0, but Microsoft Word is much, much worse: The Mac version does not run despite several Microsoft support on my iMac. In the Windows version of the operation is a disaster.
-
Dec 20, 2014 2:21 PM in response to Sal Soghoianby Jerrold Green1,Sal,
I just came across a reference to your iWorkAutomation site in another thread on Mail Merge. Thank so much for your work.
Regards,
Jerry
-
-
Jan 12, 2015 10:17 PM in response to CD MANby PeterBreis0807,But this is different! This is Apple!
Peter
-
May 10, 2015 5:50 PM in response to dirkt68by Dirtybigfoot,Hi all,
Please remember that the best thing you can do to request this feature be added back, is to go to apple.com/feedback and submit the complaint requests there. In the future, this may be added back.
-
May 20, 2015 2:24 PM in response to dirkt68by fcpmac,From: https://tidbits.com/article/14299
Print Mailing Labels and Use Mail Merge -- Most people are surprised to learn that Contacts can print mailing labels and envelopes using standard formats from Avery and Dymo, and that you can even create your own layouts for custom labels. Apple doesn’t trumpet the functionality, but instead buries it in the Print dialog.
To print labels or envelopes, first highlight the contacts to include in the print job. Then, choose File > Print, and click Show Details. Next, from the Style dropdown, choose a style: the choices include Envelopes, Mailing Labels, Lists, and Pocket Address Book. Once you have chosen a style, use the Layout and Label panes in the Print dialog to refine the layout and content of the mailing labels or envelopes. In the Layout pane you can set label dimensions, choosing from various standard sizes. In the Label pane you can specify a logo or other image to use, and choose a font.
If, however, you need to add barcodes or intricate graphics to your labels, look to other applications. For example, Labels & Addresses ($49.95) from BeLight Software gives you much more printing flexibility, including personal and corporate templates, creative fonts, hundreds of images, and the capability to print postcards and a variety of label shapes. As an added bonus, the software can begin printing mailing labels in the middle of the page, so you can make use of partially used label sheets.
Labels & Addresses also solves the problem of how to create a single address label for multiple contacts who share an address, such as married couples, a need that often arises when printing labels for holiday cards. For more information about that, read Jeff Carlson’s “Labels & Addresses Restores Holiday Card Sanity” (12 December 2008).
Dedicated label printers, such as the LabelWriter printers from Dymo and Smart Label Printers from Seiko, print your labels in long strips, so that you don’t wind up wasting unused labels at the bottom of the sheet. They support a vast array of label sizes, and while they come with their own software, it’s often better to rely on Labels & Addresses.
If, instead of using labels, you frequently need to print directly on envelopes, I suggest you take a look at Ambrosia Software’s EasyEnvelopes ($9.99), which also integrates with Contacts.
You can also create mailing labels, envelopes, and directories inside your favorite word processor. Both Pages ’09 and Microsoft Word recognize Contacts as a data source for mail merge — unfortunately, the just-released Pages 5 no longer supports mail merge. Any fields on a contact card can be included in form letters and phone list directories as well.