Generating Letters from Excel List

[rockstar1989]

Hello,

I need help in creating a grouping mail-merge 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 don't want to use the add-in. I tried to setup the mail-merge using the instructions in this thread but I was not able to generate accurate results, may be I am doing something wrong https://www.msofficeforums.com/mail-...-tutorial.html

Could anyone please help setting up the mail-merge.



Thanks in advance for your support.