Hello,

Im trying to do a mail merge from excel into word and I can get a page per person, however the excel contains the same person multiple times. For Example the excel contains "The recipient" and then the "Account Number" columns, some people have multiple accounts. So I would like all of those accounts (different rows in excel) to be included in a single letter to the person.

So something like the below;

Dear XX,

Your accounts details are:

Account1
Account2
Account3

Regards,
Me

The account numbers are all in the same column, and the number of accounts per person varies, so I cant convert them into individual columns without alot of manual work (over 300 recipients)

Does anyone know if this is possible and if so how?

Thanks.