How do I automate creating multiple PDF's from one folder?

[orchidlisa]

I have an Access Report coded to output a PDF file for several customers sell information. The PDF's are stored in a folder with the customers ID #.

There are 800 customers that I need to create single PDF's for.

I want to reference the customers folder and combine all PDF's in the one folder into one PDF and save it as the customer's ID # (folder name).

Is this possible?

I saw something that might have worked on this thread thread705-1272718 but the thread was closed before the Acrobat 7.0 issue was resolved.

Please help!

Thank you!

Orchidlisa

 

[kjv1611]

Not sure about the dealing with the PDF files part, but what about using the [blue]FileSystemObject[/blue] to possible get at all the folder/file names you want, and work with them? Have you already tried looking into that?

--

"If to err is human, then I must be some kind of human!" -Me

 

[orchidlisa]

I have already created all the folders and files. They are sitting there staring at me waiting to be joined.

 

[kjv1611]

Don't know how to do it in PDF files from VBA, but I have tried a free program for at least splitting out files. It might work for joining them as well - seems I saw that option, but just no reason to try it - for me.

http://www.pdfill.com/

The Pdfill PDF Tools piece is free, the editor is shareware or either you have to pay for a license to use it the firs time - I forget.

For copying out one page to a new PDF file, and for converting things TO PDF, the tool has been priceless.


--

"If to err is human, then I must be some kind of human!" -Me