Hello,
I'm the volunteer registration/scheduling flack for our local soccer team's annual tournament. I'm trying to use a mail merge to print a card with team rosters for each individual game in the tournament. The main mail merge sheet has the game number and both team names. The data sheet has the team names and the players' names and numbers.
I've attempted to use the solution detailed here
https://www.msofficeforums.com/mail-...-multiple.html but I keep getting an "cannot open data source" error message.
I've attached the test excel file and word document that I've been working on. I'm wondering if I've gone down the wrong solution path (I've looked at a bunch of add-ins and other posts) or if I have a bad setting or two. Any help would be greatly appreciated.