Indesign data merge only one record per page

This way InDesign will read the path and pull in the image directly. We donвЂ™t paste the actual image into our spreadsheet, merely include the path to them on our local drive.

The only tricky part is including images. Then we go through and write the actual values for each employee on a new row. In the first row of your spreadsheet we use these fields as our column headers. WeвЂ™ll have First Name, Last Name, Job Title, Email, Portrait. For the sake of this example we will use Microsoft Excel.Дecide on the fields you will need on your business card. Perhaps a mugshot of each employee or a QR-code for example. That is, all the names and email addresses and job titles etc. Create a spreadsheetДЇirst you will need a data source. Updates to either design or content are then a breeze. By using the powerful data merge features of InDesign you can set up just one template file and have InDesign read the employee information from an external spreadsheet. You will end up with 130 files though (or 260 if you make a new one for both front and back) and a nightmare of a scenario if the boss suddenly says he wants to change the font/color/logo at the last minuteвЂ¦ДЇear not. Time consuming, but it will get the job done. Your initial plan may be to create a template file and then use that as a master to create a new file for each employee. One side in Japanese and the other in English. Have I confused you totally and you now wish she had ignored my post? I hope not.The problem: You have been asked to prepare company business cards for all 130 employees working at ACME Multicorp. I wonder this since the process seemed closer to working right when I typed a few lines in and then did the Next Record marker again. One thing I am wondering, if it would make a difference it I typed those 18 lines from scratch into my new card form file instead of trying to paste them in.

When I did a print preview to see how it would really print, it shows one card per page again. Then, as I scroll down through my merged results, it says / 27 for the first page, /27 for the second, /27 for the third, then for the fourth it says 5/27. To be more specific, I told the program to merge 24 records. They all appeared on separate sheets again, and the Page counter showed each to be a separate page. Thinking maybe it would still put three 'cards' on one sheet when printed, even though it did not appear that way, I ran another short merged. However, when I copied and pasted the original 18 line card document on that same page after the Next Record marker, it puts it on a separate sheet. This only seemed to work when I manually typed a few lines after that Next Record marker and then put another marker and typed a few more lines. Running a short merge, it seemed that the marker did allow three different data file records to be listed on one page. But I closed out and tested a merge, and apparently it did put some marker at the end of my 18 lines of information in that card form file. Nothing seems to happen, so for a long time I thought nothing did. So I picked my most recent one, highlighted it, and Insert button lit up and I clicked it. The original data base file I used when setting everything up the first time is not even in the list anymore and apparently does not need to be. First, when looking at that Next Record screen, my database source is there of course and under it are all the most recent dbase files I have been merging each week. Ok, I am making progress but some things still are not working right.

Indesign data merge only one record per page