Morning,
I have 2 excel documents that I'm trying to create a "mail merge" with. One worksheet (my template scorecard) has 3 cells that would have the variable information: name, club, division. My second document has 3 columns with this information, with each row being a different person (i.e.: 1st row - Sue Jones, Pozo, Novice; 2nd row - Jay Smith, Edna, Junior; ...) with a total of 110 rows. I was hoping to find a way to merge these 2 documents together so each row would have its own scorecard - final result 110 scorecards to print.

Is it possible? We're on Excel 2007.
Thanks, Tamara