Hello,
Please read before posting.
I am an immigration lawyer.
My clients fill out an excel sheet similar to the one attached.
I need to be able to AUTOMATICALLY extract information when a new client fills out the EXCEL form.
This extracted information must be entered into the PDF file. This PDF file is dynamic and CANNOT be generated from scratch. this PDF is a government PDF form that has a specific button called "VALIDATE" that is on the first page. once the form is completed and the button VALIDATE is pressed, then the form reads the information and generates a BARCODE. This means that you cannot generate this PDF from scratch. You can only fill the PDF in its pure state.
I want to be able to give this program an excel sheet with the exact format as the one attached here and for it to automatically take the pdf in question and populate the boxes. The PDF form has many boxes and they are populated in 1 of three ways:
1- either you write information
2- either its a drop down menu
3- either its a BOX that has to be checked
The excel sheet provides the information about which information is written down, which is selected from a drop down menu, and which is a BOX to be checked.