Back to Blog
![]() csv or the final merged InDesign file, if you still hapen to have double or tripple word spaces. Select the graphic frame you created on the page, and then click on the word images in the Data Merge panel. sure that you merge all your documents into a single file before uploading). create only one page, merge your data here and after generating merged document you can add the other pages at above and below of the document. Import with Data Merge Next, open the Data Merge panel (Window > Utilities > Data Merge), choose Select Data Source from the panel menu, and choose that CSV file (it’s in the same folder as the images you want to import). Data Analytics and Research Interns for the Migration and Remittance team. Sounds complex, but it is pretty fast and easy once you get the hang of it.ĮDIT: Do a find/replace for multiple spaces and convert them to single spaces in the. with data merge, indesign generates the whole document for each line, that's why you have to merge your data on one page. Then you can just datamerge this single column. Then delete the original colum A/B/C as the new column D has the merged title/name. ![]() One can then copy the formula and paste special (formula only) onto all the records (row 2 to 1300 etc). This formula will put a word space between each column. (Presuming that A1 is the title and B1 is the given name and C1 is the family name). Use the formula to combine row 1, column A/B/C into the newly inserted working column. So insert a new column to work in (say column D). In Excel/OpenOffice/NeoOffice the formula to merge three columns together is as follows: (For demo, to print mailing labels. Choose Multiple Records to create more than one record per print. Another way that I have dealt with this is to combine the title and name fields in the spreadsheet, before doing the data merge. Choose Single Record so that each record starts at the top of the next page.
0 Comments
Read More
Leave a Reply. |