Merging Pdf docs using access 2007 vba

[ianclegg]

Hi

Has anyone any simple code that merges multiple pdf documents that they are willing to share. I don't seem to be able to find anything that works so far.

Thanks in anticipation.

Regards

Ian Clegg

 

[Galaxiom]

Install the server version of pdf toolkit.

Then use the Shell function to run it via command line.

 

[ianclegg]

Thanks Galaxiom

I followed you suggestion, my final code is posted below.

Set objShell = CreateObject("WScript.Shell")
strcommand = "PDFTK c:\doc1.pdf c:\doc2.pdf c:\doc3.pdf cat output OutputF1.pdf"
objShell.Run strcommand


Thanks to all who viewed, maybe this will help you.

Regards