Adobe
Sign in My orders My Adobe
More Print tips

Resources
Printable version
Set up records for a smooth merger
page: 1 2
Instantly generate documents, such as mailing labels, form letters, or envelopes, with the new data merge feature in Adobe® PageMaker®. Using data from spreadsheets, databases, or text editors, you can merge multiple records into one publication. These steps explain how to prepare records so that they merge flawlessly in your publication.
main
Set up the data field names.
Determine what fields will appear in your target publication, and make sure your data source has those fields. For example, our auto sales spreadsheet includes data fields such as “Year/Make,” “Model,” and “Base Price.”
Spreadsheet records must be organized with the data fields across the first row. If the spreadsheet data is on multiple worksheets, reorganize it onto one worksheet.
Records from a database file will use the table field names as the data field names. To export the field names in FileMaker Pro, use the existing field names to define the values of the first record.
step1
Check the data field names.
PageMaker is not case-sensitive, so make sure each field name is unique. For example, if there is a field named “address” and another named “ADDRESS,” the second instance of the field name will be ignored, and the entire column of data will not be included in the merge.
A blank field name will not appear as a data field in PageMaker unless it contains a space.
Field names that begin with the “at” sign (@) are reserved for fields containing images. If you’re using Microsoft Excel, type an apostrophe (') before the at sign, such as '@Photo.
step2
Set up the records.
If you’re using a spreadsheet or a text file, each row or block of text that follows the row of data field names represents a record (a).
PageMaker igores blank rows and records (b). Blank fields within a record can appear as a blank line in the record’s publication or be removed, depending upon the option you select later in PageMaker.
Image data is represented by the filename (c), such as BillTucker.jpg, or the full path to the file such as c:\Photos\BillTucker.jpg on Windows, or Mac HD:Photos:BillTucker.jpg or Desktop:Family:dat.gif on the Mac. Use only the image’s filename if the image and the PageMaker publication are in the same location, otherwise use the full path.
step3
back to top
previous next