Datamerge with multiple input PDF's

[Indy2]

I have an Excelsheet (8900 records, 70 different companies, 30 different brochures) containing the following fields

CompanyID

Companyname

Department

Username

UserID

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;

    CompanyID

    Companyname

    Department

    Username

    UserID

- 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:

CompanyID	Companyname	Department	User	UserID	Filename
111111	Baker inc.	Marketing	John	4570	Brochure_5.pdf
111111	Baker inc.	HR	Matt	6940	Brochure_5.pdf
111111	Baker inc.	Purchasing	Paul	9881	Brochure_3.pdf
222222	Ferris inc.	Production	Lori	1145	Brochure_3.pdf
222222	Ferris inc.	HR	Jack	5448	Brochure_4.pdf
222222	Ferris inc.	Purchasing	Dan	5677	Brochure_17.pdf
333333	Harris inc.	Marketing	Peter	6692	Brochure_1.pdf
333333	Harris inc.	Sales	Darren	1114	Brochure_9.pdf
333333	Harris inc.	Shipping	Mike	2247	Brochure_17.pdf