Macro to select a pdf template, read data from excel and create selected PDF for each row

Hi All,

I am new to excel VBA...

I work as an HR associate and lot of my work is associated with Excel. I keep getting queries from employees about confirmation letters, address proof letters, visa processing letters, and many HR related letters. I maintain the database of all the employees in excel master sheet.

I get anywhere between 30 - 40 such requests on a daily basis from the employees. Once I get the request, I look for the information in the excel and then create the letters in word template and then take a printout of the same and get it signed from the Head HR. As this is a repetitive task and time consuming, I am trying to figure out if there is a way to automate the entire process.

I have created the existing word format templates into fillable PDF's using Acrobat X enabling the option of digital signatures (to get signature of Head HR digitally) in each of the template.

Now I want a macro to select a PDF template in the folder, and read the data from excel master sheet and create a new PDF for each row as per the information required in the template.

I already found something on the web which I have attached for your reference. But the problem is it has only one PDF template to create, In my case I have multiple templates.

Appreciate if somebody can help me on this which will make my life a lot easier.

Thanks in advance.

Regards
Naresh

Hope somebody understood my question...