Every quarter I have to generate invoices (261 and growing quarterly).

The invoices are interactive PDF documents.

For each invoice, I am supposed to go in to 5 different software systems/ databases to hand type the information in to the PDF, then rename the PDF using a naming convention. All-in-all, it's about 10 minutes per form. This is ALMOST the most inefficient, retarded, process I've ever seen!

I have figured out how to export the required information from all the software/ databases in to one Excel 2010 worksheet, so now I have a table containing all the information in one place. Doing so cut the time in half...

Now, I need to figure out how to tell Excel to open the blank invoice form (located on the server), then import the corresponding cell values in to the PDF form fields. After that, tell the PDF to save the completed form using another Excel cell. If this could be figured out, it would take this whole mess down to about 15 minutes.

I already know how to make Excel create PDF's and save the PDF as a certain cell value. The problem is these forms need to be interactive so the accountants on the other end can edit/ update information on the invoice; I can't just send them a static PDF.

Can anyone please please please provide some assistance?????