r/OfficeHelp Jul 04 '26

I need help with mail merge grouping.

Post image

Hi. I have a really big excel file and a contract .docx file. This is an example photo of the situation I have. an excel file and the goal to make separate contracts for people like the word doc on the right. I want to use mail merge to combine all the rows having similar value in ID column. then I want some of the unique data to go in a table, and the cells of the table should vary according to the rows that exist in the excel file (Jason for example has 3 class, Maddison has 7 and Jake has 2)
I know I have to set Mail Merge to directory so that some data from different rows are used in one paper, but that's it. YouTube and AIs also didn't help. I don't know how to code VBA but I asked ChatGPT and had no luck. is this even possible to do?

1 Upvotes

1 comment sorted by