Help with mail merge using DATABASE command with excel file.

dcdonnelly · #1 05-31-2024, 10:03 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file	sureshbvs	Word VBA	1	03-12-2021 05:42 AM
Use only blue cells in database in mail merge	coopfab	Mail Merge	2	10-02-2019 06:18 AM
Mail Merge with integrated Database	CarlCarl2	Mail Merge	1	01-24-2017 05:53 AM
Mail merge only sends some email from Access database	rsakai2	Mail Merge	4	10-30-2013 10:32 PM
mail merge - database server	rec	Mail Merge	1	09-29-2013 08:03 PM