Macro for Generating Letters from Excel List

Hello,

I need help in creating a VBA macro for generating letters from Excel list.

Please check the example sheet attached. I need to generate letters for each company in column C. The column C is the primary key. The number of rows for each company will vary.

The format of letters (word document) is attached as "Example Output" and the column references is also attached. From the example sheet, 3 letters will be generated and saved to a folder.

I need to automate this task as we do this exercise on a daily basis. I know this can be done through mail-merge but my team is not much computer-proficient so I need a solution where they can just copy-paste the data in excel sheet and click the button for generating letters.

Thanks in advance for your support.