Mail merge from excel to excel???

Hello Excel Gurus.

I have used this site a number of times on things regarding formulas that I thought were impossible and every time someone figures it out. It's been amazing.

This time, I have a question regarding using mail merge to fill in certain spots on a golf scorecard I created in Excel. I currently have 72 scorecards built out on one Excel spreadsheet and I have a separate spreadsheet that I use to pull information from for adding the tee location, the four names of the golfers, their initials, and their handicap. It's been working for years but here is my issue. This year, I have two new course that were added to the event and now I have to go in and change all 72 scorecards for each of the two new courses. Not only that, there is a new game that we are adding to the round and now I have to change the format of the scorecard, as well. If I only ever had to change one scorecard when big changes like this had to be done, it would save a tremendous amount of time. Having the option to merge in the information that needed to change on each and every scorecard and to print them out automatically like envelopes would be awesome.

Does anyone know how this can be done? I appreciate any help.

Thanks and have a great week,

Mike

I have added a couple of sample spreadsheets and a code that I believe would do the trick. My issue now is that I don't know how to fill in the code correctly. Can someone take a look at the samples and help me fill in the code? Thanks so much for your help.

Mike

Sorry about that. I realized I should have put this in the VBA catergory. Can you move this there so it gets seen by VBA specialists? Thanks for your help.