How to input in bulk excel cell remarks in scanned pdf file as text box.

[Kumar Shanmugam]

I have a list of Loan account no's and remarks in excel file. I have to insert remarks in the scanned pdf file. Is there any way I can insert in bulk remarks value of the particular loan account in the scanned pdf automatically without manual intervention.

Please find attached the sample file.

 

[Kumar Shanmugam]

I have a list of Loan account no's and remarks in excel file. I have to insert remarks in the scanned pdf file. Is there any way I can insert in bulk remarks value of the particular loan account in the scanned pdf automatically using file name as reference.


Use of Macro desirable.


Background:

We have a scanner machine where we scan the application form and save in pdf file. We have a file save type option as bitmap, jpeg, pdf and pptx. We have an excel data having loan account no in column A and remarks in column B.


Column A Column B

Loan Account no Remarks

L2WABD03997714 Account no in front page mismatch with second page.

L2WHSP04002135 Carried forward transaction mismatch


I wanted to insert remarks (column B) inside the scanned pdf file using file name (Loan Account no) as reference. Note: Scanned pdf file will be saved with the loan account no.





If it’s not possible with pdf file can we do with word, jpeg, excel.


Note: Third party installation software not permitted. I cannot use adobe acrobat. Only Adobe reader.

 

[Marc L]

Hi !

Here it is the Excel formulas forum !

As Excel neither Acrobat Reader can't mod any existing pdf file !
See on a specific pdf forum …
​