Skip to main content
T
timothyh70102503
Known Participant
February 14, 2018
Question

Indesign and Data Merge

  • February 14, 2018
  • 1 reply
  • 1320 views

I have a card design double sided, it is for a child sponsorship in Haiti, I need to merge with a spreadsheet that has over 300 kids, I go through the steps and it either puts the same photo and info on every page or just one.

So my question is when I set up the InDesign Document how do I set it up, do I set over 300 Pages? Do I set up the copy on each page or will it place it on every page, do I leave all but the first page blank?

Can someone list the steps in simple language? Every thing I look up starts after the indesign document is created and I am I will add a copy of the layout.

It is a two sided document printed front and back 300 times plus.

    This topic has been closed for replies.

    1 reply

    J
    Community Expert
    Jeffrey_SmithCommunity Expert
    Community Expert
    February 14, 2018

    Is the name of each photo entered into the source data? For your example, the image used is named: child1.jpg. Is there a column in spreadsheet designated for the corresponding photo, along with the other data to be used?

    NameGradeBirthday@photo

    Emmanuel

    		69/14/03child1.jpg
    Maria57/25/05maria.jpg
      T
      timothyh70102503Author
      Known Participant
      February 14, 2018

      Yes there is a column in for each image with corresponding information.

      It changes on the InDesign part on page one but does not flow to the other pages changing it for each child.

      J
      Community Expert
      Jeffrey_SmithCommunity Expert
      Community Expert
      February 14, 2018

      I guess what I need to know is if I have 300 kids that have 2 pages each, one page has interchangeable information (data merge) how should the InDesign be based on the image above.

      1. Do we have the information and picture just on one page? (the second one the back) and have 298 pages with just the background image?

      2. Or do we have 300 kids with a page with info on it for each being 600 pages with the interchangeable information (data merge) on the second page for each.

      3. Or is there only two pages with the info on the second page and it automatically creates a page for each kid based on those two pages?

      I am not sure I have the indesign document right? I tried the data merge and it worked for page one only and the other 300 plus pages stayed the same.

      Help.


      Here is a link to files used in example data merge:

      https://adobe.ly/2BXNSuL

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices