#APPLE PAGES DATA MERGE APP MAC OS X#
#APPLE PAGES DATA MERGE APP MOVIE#
#APPLE PAGES DATA MERGE APP FREE#

Select the name of the recipient under the first step and then choose Assign For Use With File Naming from this pop-up menu. By default they’re assigned with the Pages’ document name followed by a number- Unsolicited Pitch-1, Unsolicited Pitch-2, and so on.

It’s also within step 2’s pop-up menu that you can choose how your merged documents will be named. The letter M will appear to the right of the selected email address indicating that the addresses in this column will be used as the To address in your messages. If you intend to email the results of your work, select the email address that appears in the list under step 1 and, from step 2’s pop-up menu, choose Assign As Email Recipient Address. In order for this to work you must create a list of email addresses for your recipients in your Numbers document (having an email placeholder in the Pages document isn’t necessary). In step 5 you can choose to email a copy of your merged document to your recipients. When you make a selection in the second step, its name appears under the Assigned Placeholder Tags heading in the first step. Select the one associated with the entry you highlighted in step 1 (in the example you’d choose FIRSTNAME). Click on the pop-up menu next to the second step and you’ll see a list of all the placeholders you’ve created in the Pages document. Select the first item in the list (in my example you’d select Frank). When you do, the information from the first column in the Numbers document will appear in the Data Record Items area. In the area marked with a 1, choose Selection of Numbers Table from the pop-up menu and click the Import button. Launch the Pages Data Merge app and walk through the numbered steps. In Numbers, create a spreadsheet that includes the data you want to merge. (The column header need not match the placeholder names you’ve created.) Now select all the rows that contain the data you want to merge. You then launch Numbers and create a spreadsheet that includes columns for each entry. Select placeholder text and assign a script tag to it. Repeat for each bit of text that you wish to use as a placeholder. Into this field enter the name of your placeholder-FIRSTNAME, ADDRESS, PHONE, MATENAME, or whatever’s most appropriate. A Script Tag field will appear in the Text pane to the right. Now select the first placeholder entry and from Pages’ Format menu choose Advanced > Define As Placeholder Text. If the Format pane isn’t present, click the Format button in Pages’ toolbar and click the More tab. They’ll be replaced later with your merged data.

#APPLE PAGES DATA MERGE APP FREE#

Feel free to insert real or fake names, addresses, phone numbers, email addresses, and so on for placeholder text. You start by creating a Pages document that serves as the template for your merged documents.

#APPLE PAGES DATA MERGE APP MOVIE#

As its name suggests it lets you incorporate data found in a Numbers spreadsheet into a Pages documents.Ī movie on the page describes the process from beginning to end but I can give you the gist. Here you’ll find an AppleScript and Pages page that provides instructions for using the free Pages Data Merge utility (the page also includes a link to that utility).

#APPLE PAGES DATA MERGE APP MAC OS X#

Instead, I’ll direct you to the Mac OS X Automation site. This is possible through the power of AppleScript (don’t worry, I’m not going to ask that you learn AppleScript in order to carry out this job). There is, although it’s not a feature directly built into either app.

Is there a way I can use the two of them to create mail merge documents? Will need to check out Microsoft Office for now but will check back for any updates here.I’ve recently upgraded to OS X Yosemite as well as to the latest versions of Apple’s Numbers and Pages apps. I had been using Microsoft Word 2004 to do all of the above previously and having bought a new MacBook I am surprised it can't be done in Pages. This mainly affects me where some customers have a company name and some don't.ģ) I also need the option to amend the punctuation to either Title Case and/or Upper Case. For this reason combining PDFs wouldn't work and seems a bit of a clumsy solution anyway.Ģ) Also as requested by a few others I need some lines of an address to be ignored if there is no data present in that record. I am using it primarily to print customer labels and as well as for ease of printing on my label printer I need to go through the labels making minor changes. This was close to being a good mail merge solution for me but unfortunately has a few issues.ġ) Like others I would like the ability to produce a multi page (Pages) document rather than multiple individual page documents.

Apple pages data merge app