Save reports as PDF then merge into 1 PDF

[tgall]

Short trip: I want to save an individual Access report as a PDF and store in a folder.
When all reports are in the folder, I want to combine all reports into one PDF. How
do I pull this off with VBA?

Scenic View: I'm trying to automate a PDF print process:

FIRST, I receive a request (RequestID). One request can have one or more tests
(TMID) associated with it. When each test is completed, I save the report as a PDF. I can build the VBA


to open the print dialog box. Once the dialog box is open, however, then I'm back
into manual to select PDF and save it to a folder entitled with the RequestID.

SECOND, via a query, I keep track of the completion of the tests. The query is the
record source for a report I call the Table of Contents (TOC).

THIRD, when the RequestID folder contains all the individual PDFs, I wanted a button
that activated VBA to combine all the PDFs in one PDF.

My laptop is installed with Adobe Acrobat XI Standard. My mind can't pull the VBA to
connect Acrobat to the folder.

Suggestions? {Please}

[rpeare]

this wouldn't necessarily be a function of vba, does adobe acrobat have command line capability? If it does you could create a shell command to combine two adobe files or at least determine what the command line switches/capabilities are.

https://helpx.adobe.com/acrobat/how-...tals--edit-pdf

This seems to indicate you can but through adobe acrobat, not through command line.