I have an Excelsheet (8900 records, 70 different companies, 30 different brochures) containing the following fields
Filename (the brochures)
The following needs to be done:
- On the first page (same location on each brochure) the following variables need to be placed;
- the output needs to be bundled by company. (boxed items)
I would like to datamerge this as 1 file and then split by companyname.
Alternatively I could split the sheet per company but for bundling purposes I need to generate each company in one run.
My main issues are;
- Multiple brochures per company
- Bundling by company (Not an issue If the sheet is split by company first)
Here is an example of the excelsheet: