See: https://www.msofficeforums.com/mail-...-multiple.html. Although the example there uses a single Excel file and the data are on two sheets, the same principles apply for using multiple Excel files.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]