Copy data from excel to letter template (Word doc)

[Manish Sharma]

Hi friends,

I want to develop a code for automatic letter generator, by taking data from Excel file and putting it is letter template. When I googled for this I found many codes which can do my job, by copying the data from Excel’s each row and pasting it in letter template (in other words for each row of data, one letter is generated).

But in my case, the data to be copied is in multiple adjacent rows, hence those codes are not working for me. I tried for last two days, but of no use, can you please help me on this.

My requirements: -
• Copy data from sheet (Transfer), and paste in letter template (both sample excel file and letter template are shared for easy understanding)
• For each employee ID, one letter will be generated. Hence for this sample file, total of 3 letters will be generated and saved in the same folder. In actual scenario more than 30 letters will be generated
• In letter template, employee’s full name will go in {SALUTATION} {FIRST NAME}

I have attached one filled letter template as it should be created by taking the data from excel file.

Thanks & regards,

 

[Manish Sharma]

The same question is also posted in another forum, link is as below
https://www.excelforum.com/excel-pr...-to-letter-template-word-doc.html#post4880971