I write reports for legal claims. As part of my report I need to create a single pdf with all of the documents I cite in my report (typically this is in the 100-200 document range). Each of the documents needs to have information about the document in the headers and footers. This includes the source information about the document - that is, where is the document from (for example, an archive name, a file number, and a date).
I have figured out how to do this by manually copying and pasting the information into the footer, but since I have an excel spreadsheet with this information, I would prefer to have the computer automatically match the PDF to the source information and create the footer.
Where is the information in Excel? In the Excel header or footer? In the tab name? In one or more cells?
I have the information for all the documents in a table in excel. The documents are mostly letters, memos, reports, and maps (not excel documents converted to pdf). The the document source information is in a cell in the excel table. Other information in the same row for each document include the pdf name, the docuemnt author, document date, and a html link to the pdf.
So, the excel table acts like a mini flat file database for all of the documents that I collect.
It is easy to take the information out of excel and put into another format, if that helps
I am not a scripter and don't know of a way to put a cell reference into either an Excel footer or an Acrobat footer. Maybe someone else will chime in.
If the document is in Word and you are applying Styles for your formatting (the styles can be redefined), then this method might work to create the footer in Word, which will convert to PDF.
This will create a running footer (or header) with text that changes according to what is in the style. If you need more than one, it might say:
STYLEREF "Heading 1": STYLEREF "Heading 2 .
Test it on a small portion and see if this will work. I don't know exactly what is in your cells. For a quick test, go into Word and type:
followed by Return (or change the numbers: the first number is the number of paragraphs, the second is the number of sentences),
then type in some headings, format them with Styles, and use the StyleRef in the footer to see if it will work for you. Convert to PDF to confirm it works as expected.
Copy link to clipboard
There aren't any tools in Acrobat that will automatically grab info from excel and then place it on a PDF Header/Footer, but such an automation script could be written. This is not a simple tool. As an example, try out the free "File Name Stamper" Action here:
It doesn't get info from an excel file, but it does add header footer info. You could use the script as a starting point for the more complex script that uses the excel data.