0 Replies Latest reply on Apr 20, 2017 8:23 AM by Indy2

    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:

            

      CompanyIDCompanynameDepartmentUserUserIDFilename
      111111Baker inc.MarketingJohn4570Brochure_5.pdf
      111111Baker inc.HRMatt6940Brochure_5.pdf
      111111Baker inc.PurchasingPaul9881Brochure_3.pdf
      222222Ferris inc.ProductionLori1145Brochure_3.pdf
      222222Ferris inc.HRJack5448Brochure_4.pdf
      222222Ferris inc.PurchasingDan5677Brochure_17.pdf
      333333Harris inc.MarketingPeter6692Brochure_1.pdf
      333333Harris inc.SalesDarren1114Brochure_9.pdf
      333333Harris inc.ShippingMike2247Brochure_17.pdf