I need a mail merge template in InDesign (CS4) gathering information from a filter on an excel spreadsheet.
The document will be A4 and contain labels. The colour (CMYK) for each label will be defined in the spreadsheet. There are fourpieces of information that need to be includws on the label from the spreadsheet, as shown in the image. The text in the content areas should scale (from a max) to fit the space.
I have a mail merge in word as a basis, but this does not allow me to dynamically alter the colour of each label.
This will be exported to pdf (with 3mm crop and bleed marks)
I don't think this is difficult, it's just a little more than my InDesign knowledge, and I need it quite quickly.
Happy to provide an excel sheet with data on.