Hi

I have a list of clients and the person who manages the client along with
the address details and more for that person. (About 15 - 20 columns of data
per row)

I have to mail merge the person managing the client.

I have an issue in that in some instances, 1 person may manage 2 or more
clients (one manages 51 clients) and I need to work out a way to list the
clients in 1 letter to the person managing the clients as opposed to writing
a letter multiple times to a Client Manager. Obviously, one of them would
receive 51 letters.

This obviously means that my current Excel has some instances where there
are multiple rows listing the same Client Manager for different instances of
Clients.

I hope I have made this clear enough to understand.

Thanks in advance

Malcolm