How do I mail merge onto Word from multiple Excel Worksheets

Can you provide more information on the content of the worksheets.

Out of the box, Word can only use a single, flat data source for mail merge.

It is possible however that my MergeTools Add-in could do what you after.

Dear Jonas

To mail merge from multiple Excel worksheets in Word without interfering with the previous merge, follow these steps:

1. Open your Word document and go to the "Mailings" tab.
2. Click on "Select Recipients" and choose "Use an Existing List."
3. Navigate to the location where your Excel files are stored and select the first worksheet you want to include in the merge.
4. Insert merge fields as needed.
5. Complete the merge as usual, and your Word document will be populated with data from the first Excel worksheet.
6. Now, if you want to include data from additional Excel worksheets, go back to the "Mailings" tab, click "Select Recipients," and choose "Use an Existing List" again.
7. Select the next Excel worksheet you want to include and repeat the process of inserting merge fields.
8. Continue this process for each additional Excel worksheet you want to merge.

By following these steps, you can merge data from multiple Excel worksheets into your Word document without interfering with the previous merge. If you encounter any issues or have further questions, feel free to ask!

Best regards Adekunle

Hi, Jonas M thank you for coming to the forum, my name is Adekunle.its worth noting that this is a user community and we are all users here. while we strive to assist and share insights we are not microsoft.