Append to a PDF file using VB (1 Viewer)

[DataMinerHome]

I want to combine several reports, and also some query outputs, into one pdf file. I can do this currently by running each report or query, using PrimoPDF to print it, and then manually selecting the "append" option to append the next report to the existing file. However, this is cumbersome because there are 7 different reports I want to append to one pdf file, multiplied by about 30 different reporting options.

Rather than peform 210+ manual operations, I would sure like to be able to write some code to do this. However I don't see that PrimoPDF makes anything available through VB. So... any ideas?

The pdf writer that is integral to MS Access does not seem to be able to append to an existing pdf file.

Is there a way to do this? Or is it just a wrong-headed approach? Ideas?

 

[sxschech]

This thread has code for merging pdfs into one file, not sure if it would work for a non Adobe pdf creation tool such as PrimoPDF.
http://www.tek-tips.com/viewthread.cfm?qid=1648313

Another example is on this forum
http://www.access-programmers.co.uk/forums/showthread.php?t=212734&highlight=mergepdf

 

[DataMinerHome]

Thanks, but I am really looking for a way to do this without buying a full version of Acrobat, as this is just a one time project for a volunteer organization (ie, no money available).