Hi all, thanks for your help in advanced.

I run a basketball competition and am trying to use a mail merge to help generate the team sheets automatically.

I have an excel sheet which has every player in the competition and the team they play in. I have used a mail merge already to fill in the team name each week based on who they are playing, but what I now want to do is automatically populate the sheet with each of the players names who play in that team.

Is there a way to write to find 10 players names, who all play in the same team, for example 'Team A' and then put them in a column, 1 name per row:

Team A:
Joe Blogs
Super Man
Bat Man

and so on.

I'm hoping that makes enough sense that someone might be able to help.

Cheers
Helmszee