Mail merge: how to use multiple Excel sheets

Hello,

I discovered the mail merge function in Word, which has really helped me save time in drafting a good number of reports for work.

As a data source, I have an Excel spreadsheet with several sheets.

When I open my Word document, it asks me which data source I want to use (meaning which Excel sheet).

After integrating the data from my first Excel sheet (mainly text and image links), I would like to integrate data from my second Excel sheet (graphs) into the same and only Word document.

However, when I open my Word document and tell it to take the second sheet as the data source, it tells me that the already integrated data (for each field) is not there... of course, because it is on my first sheet haha. But I would just like to add the data from the second sheet, in addition to the data from the first sheet, in the same Word document. I hope I'm clear.

Anyway, my question is: is it possible to integrate a second Excel sheet while keeping the data from the first?

Basically, is it possible to use the mail merge function with multiple Excel sheets or do all the data have to be on the same Excel sheet?

If not, I can simply copy/paste my graphs, but I admit that I could save a huge amount of time if I manage to automate it like that.

Thank you for your help.