![]() ![]() 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.How to Use InDesign Data Merge for Text and Image Automation ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |