Create Mail Merge from Multiple Sheets
I'm trying to create a mail merge that pulls from multiple sheets. One sheet has general information such as Name, Address, Project Info ect.... The other sheet is a checklist. I want to combine the general information as well as whatever is checked off on the checklist and create a mail merge. This way, I can mail each client a letter showing their personal information as well as whatever was completed on the checklist.
Any idea how I can accomplish this?