

TIP: Here’s an easy way to combine PDF documents exported using the Pages Data Merge application into a single PDF file.
#Pages data merge app movie
The ZIP archive linked below contains the Pages Data Merge application and example Pages document and Numbers spreadsheet.ĭOWNLOAD the Pages Data Merge application and example files shown in the movie above. Your browser does not support the video tag. Follow the instructions outlined in the movie below:.Don’t select any row or column headers, just select the data to be merged. Switch to Numbers, and select a range of rows from the table containing the data you wish to import.IMPORTANT: The Pages document used as the merge template must NOT be password protected. Save the Pages document to be used as the template, and leave it open.Assign a unique Script Tag to each of the text placeholders, by. Each text placeholder will be associated with the contents of a row. You can name the Script Tags anything you like, they don’t have to match the headers from the source table or data file. Before running the Pages Data Merge application, make sure you have followed these steps in preparation: Add text placeholders to the document to be merged. Assign a unique Script Tag to each of the text placeholders, by selecting a placeholder and entering its related Script Tag in the text input at the bottom of the More tab view in the Pages document window.NOTE: Text placeholders used within tables or charts are not “visible” to scripts and cannot be used for data merging. Each text placeholder will be associated with the contents of a row cell from the imported spreadsheet data. Add text placeholders to the document to be merged.The Pages Data Merge application uses this specialized scripting support to make it easy for you to merge spreadsheet data with tagged Pages documents.īefore running the Pages Data Merge application, make sure you have followed these steps in preparation: While the ability to merge data with documents in not a feature available within the user-interface of the application, Pages includes scripting support for performing automated replacement of the content of text placeholders. A Mail Merge is an example of this process. Its use requires the approval of three security dialogs, similar to this one:Ī task often performed using productivity software such as Pages, is to create multiple documents based upon a template, where text placeholders in the template are replaced with data from a row of a spreadsheet. IMPORTANT: You can DOWNLOAD a beta version (1.7) of the Pages Data Merge application designed to work with macOS v10.4 Mojave. Placeholder Text, Script Tags, and Data Merge
