In this case you can use the for each file in a folder activity & inside that you need create a datatable to add values everytime you iterate through Excel files. Then post this loop you can give the datatable with all the data to create HTML content to get combined output in single mail for all excels.