I have an excel file that is laid out as follows:

Doe John 123456789 Jimmy Doe
Doe John 123456789 Jack Doe
Doe John 123456789 Mary Doe
Doe Jane 987654321 Brian Doe
Doe Jane 987654321 Timmy Doe

For each time John Doe is listed I want Jimmy, Jack and Mary to show on the
mail merge document. The mail merge document would look something like this:

Dear John Doe:
We haven't received information on the following individuals:
Jimmy Doe
Jack Doe
Mary Doe
Thanks for your prompt attention.

Will the layout of the file work for this?