The field should display ^# Configure your PDF settings with desired settings (i.e., bleed, crop, compression, destination color, etc.), you can save it as a Preset for future use and then click Export. If you want to create separate files per record, under the Pages section, check Create Separate PDF Files and select the Suffix to be Incremental Numbers. You will now see the Adobe PDF save window. The rest of the settings under Multiple Record Layout and Options can remain at default. You will want to merge All Records and to save all versions. Uncheck the Preview, and then click on the menu icon of the Data Merge window and select Export To PDF. This is good to check if there are any unwanted line breaks or missing images. Click on the Preview checkbox to view the changes, and you can click on the right left arrow to view each version of the design. For the image you can follow the same steps. For Age we will only highlight the number ‘5’ in the text. Then left-click on Name in the Data Merge window and it should replace it with > in the text box. Starting with the Name, go to the text box where the name data will be changed and highlight the name. After opening the file you will see the Name, Age and image labels in the window. On the top-right-hand corner of the window, click on the menu icon and click Select Data Source and choose the data-merge.csv file. You can find it under Window -> Utilities. In your InDesign file, make sure there are no broken links or missing fonts. Go to InDesign and open Data Merge panel.Save the spreadsheet as its ready to be used in InDesign. You should now have the file path for each image.Ĭopy the file path from Column F and paste special ‘Values Only’ to cell C2. Then drag the corner of that cell down the column so it repeats the formula. In cell F2 type the formula ‘ =E2&D2’ and click the check mark (i.e., hit enter) to accept the formula. In cell E2 type the name of the folder of the images to define the file path and copy the same name down the columns. The list of image file names should now be pasted in the column. Then Select All and copy the files, then go to your spreadsheet and select cell D2 and paste. If your image files are not labeled sequentially, you can go back to sort your text fields by A-Z (i.e., Name) and do the same for the images in the folder. The folder of the images, should be ordered to match the text fields you pasted into the spreadsheet. Open the list of the text to be changed spreadsheet and copy and paste the data in the correct columns.
The apostrophe will disappear when you click the checkmark.) In cell A1 add the label Name and in cell B1 add the label Age, and in C1 add label (you will need to type in an apostrophe in the field, so the cell is treated as text. Each column will represent a layer within InDesign that you want updated with text or an image. Make sure the Images folder is within the same folder level as your InDesign file.Ĭreate a new Google Sheet or Excel Workbook in the same folder name the file data-merge and save it as a. – A folder of the images, preferably in the same format. – A list of the text to be changed, preferably in spreadsheet. To start, you will need the following three files: – The final InDesign file (do not outline or flatten any layers).
Locate the data to be used for data merge.
#INDESIGN AUTOMATION DATA MERGE HOW TO#
How to Use InDesign Data Merge for Text and Image Automation
0 kommentar(er)
