InDesign Data Merge - Advanced Tutorial (Multiple records per page)

Most mentioned InDesign Data Merge Limitations:

- Cannot group products;
- Cannot use multiple product templates;
- Cannot insert a page break when the category changes

[mdnwt]

You saved my day! It has been years that I haven't used data merge and that helped me create multiple tags for our storefronts saving the day. Cheers to you and the team that developed this material!

[MarkSubramaniam]

The fixed dimensions of the template can be solved by applying an 'Object Style' to the text frame. In the Object Styles options you can use the 'Auto Size' feature to automatically set the height of the width of the text frame.

[eldesarrollador_]

I love you!! You save like 100 years of manual work

[SpacePigeon]

This saved me A LOT of time and struggle thank you so much!

[franktielemans]

Another datamerge restriction is that you can't add paragraphs with bullets and numbering.
When you choose to remove blank lines from empty fields, the record is gone, but the bullets or numbers are not!

[carolynquanart]

Thank you so much! I really needed this tutorial for a new job I’m starting soon 😅

[mosesmurali]

Thank you sir for your effort to make understanding easier. God bless you si\r

[pagination.com-databasepub]

Most mentioned InDesign Data Merge Limitations:

- Cannot group products;
- Cannot use multiple product templates;
- Cannot insert a page break when the category changes

[SEANCmedia]

This worked for me! Thank you so much!!!

[ccpipe]

Now that's interesting, will definitely give it a go, thanks a lot :)

[hannablom]

I'm totally new to data merge and have only started trying to use it today. I was trying to make a data merge from an excel file (csv) where the short text within a single box was about to change. I ran into some problems though and I don't know exactly why, I only have a theory. In my document I have 14 pages, but there was only one of them that had a placeholder with the data merge header drawn into it, and I wanted the other pages to remain still and not being altered or copied. Is that possible to do in some way?? Or is every single page inside the document always copied or altered with data merge?

The thing that happened was that the entire document, the 14 pages, multiplied for each time the page with the data merge variable created its new page, meaning I ended up with a 5010 page document 🫤
Do you have a fixer for this?

Really appreciate it- and thanks for a great video 🙏🌸

[andreshiwa]

I'm using the latest AdobeIndesign CC on a Mac, in my tests, after the select the data source (csv) even choosing ALL RECORDS to merge the option RECORDS TO MERGE still disabled, and I can not select multiple records. I tried several times, but the option to select multiple records remain disabled. 🙁

[prasad]

very nice tutorial .... Thank you brother

[paulomfernandes]

Muito bom a explicação, por mais que eu não entendi nada do que você falou. Obrigado pelo vídeo!

[anneschoffelmeer]

Thank you for this advanced tutorial, really helpfull!
Since it's been a while that this video was published... Is it still not possible to do product grouping with Data Merge? If not, do you have a tip or advise how to tackle this with Data Merge, or would you use a third party plugin for Indesign?

[zohirulislam]

Thanks you very much its very helpful Video, But i want to know how to make any barcode layout by using Data Merge.

[nemesisfirst]

The problem is, if an image is out of the bounds of the page, the merged file will contain the image out the bound... How can we ask to the soft to CUT these images to the boundaries of the page ?

[lindsaydane]

I am putting together a program for a rewards ceremony. each page has two columns, which contain 15 names each. below the name is the department name. the dept name can be up to 3 lines. when the dept name is 1 line, I end up with two empty lines of space in that text field, instead of the text field auto resizing. how can I fix this?

[NismoTNR]

VERY GOOD TUTORIAL! thank you very much!!!

[alfredvos]

Hi, thanks for this helpful video. Is it possible to link to a PDF (and page in that pdf) in the excel sheet instead of linking to an image? Thanks!