Skip to main content
DarrenFMc17167703
Known Participant
January 18, 2024
Answered

Indesig 2024 Data Merge start position issue

  • January 18, 2024
  • 1 reply
  • 280 views

Is there a way to start a Merged Document from the position of the first one? The issue I have is I am using a master page that has a header section and it covers about 15% of the page at the top. When I test the Create Merge Document, it automatically shifts the Records to fit the full page so instead of getting 3 records on page 1 with the header, and then 4 per page thereafter, I am getting 4 records per page on page 1 and the top record blends over the Header. If I put the header directly on the page, then the Merge Documents will automatically include it in every record. So it seems that the position of the first record is irrelevant on the page as Merge Document will auto shift it.Is it possible to set the Data Merge creation to start at the position of the first one?

This topic has been closed for replies.
Correct answer Peter Spier

The short answer is Data Merge can't do that, but that doesn't necessarily mean you can't use Data Merge to start and then do other things to your merged data to reconfigure it.

I used to do an annual directory that was basically a Data Merge project that had listing of various lengths, so it was a single record per page, then thread the listings together, copy the threaded text and reflow into a new document.

Ten years ago there was a post on this forum about deleting blank lines and having paragraph styles change in a multiple record merge (Multiple record data merge into paragraph style... | Adobe Community ). It is quite long, but it has some useful information, including scripts for removing blank fields (and discussion of why it is better to do that and then use find change  than use Data Merges remove blank lines) and a script to stitch frames together if the first paragraph is a sequential number, which allowed me to automate my directory threading. I've done a quick search to see if I could find a similar script that doesn't require numbers, but had no luck. My recollection is that I added a field to my merge template for a line number which was added to my sorted records in Excel, put that into its own paragraph with a unique style as the first line in my template frame, then ran a find/change to remove that paragraph after stitching all the individal pages into one threaded story. you can do the same, or perhaps someone else has a script that would work without numbers.

https://www.rorohiko.com/wordpress/indesign-downloads/textstitch/ is a possibility here, I think.

1 reply

Peter Spier
Community Expert
Peter SpierCommunity ExpertCorrect answer
Community Expert
January 18, 2024

The short answer is Data Merge can't do that, but that doesn't necessarily mean you can't use Data Merge to start and then do other things to your merged data to reconfigure it.

I used to do an annual directory that was basically a Data Merge project that had listing of various lengths, so it was a single record per page, then thread the listings together, copy the threaded text and reflow into a new document.

Ten years ago there was a post on this forum about deleting blank lines and having paragraph styles change in a multiple record merge (Multiple record data merge into paragraph style... | Adobe Community ). It is quite long, but it has some useful information, including scripts for removing blank fields (and discussion of why it is better to do that and then use find change  than use Data Merges remove blank lines) and a script to stitch frames together if the first paragraph is a sequential number, which allowed me to automate my directory threading. I've done a quick search to see if I could find a similar script that doesn't require numbers, but had no luck. My recollection is that I added a field to my merge template for a line number which was added to my sorted records in Excel, put that into its own paragraph with a unique style as the first line in my template frame, then ran a find/change to remove that paragraph after stitching all the individal pages into one threaded story. you can do the same, or perhaps someone else has a script that would work without numbers.

https://www.rorohiko.com/wordpress/indesign-downloads/textstitch/ is a possibility here, I think.

DarrenFMc17167703
Known Participant
January 18, 2024

Thanks for the quick answer. I will look at those links and see if anything helps. Thanks again.

Peter Spier
Community Expert
Community Expert
January 18, 2024

You're welcome