Excel data to email

[eric_1]

What are you trying to achieve?

I am trying to have Make.com automate my monthly email notifications. I have an excel spreadsheet with all of my tools. On the first of each month I need to send out an email to a group in my organization notifying them of equipment coming up due for re-calibration.
For example, I want to send out an email on 09-01-2024, with a list of all the tools from the spreadsheet that have calibrations expiring between 09-01-2024 and 09-30-2024.

Steps taken so far

I have a scenario created that includes 3 modules and a filter (Excel, Array Aggregator and Outlook Email). I got it to the point that it runs without errors but the email has no data when I run it.
I am attaching all the info I can think of including the outputs for each module and the email body.

Screenshots: scenario setup, module configuration, errors

[Donald_Mitchell]

Hello @eric_1 and welcome to the Make Community!

By any chance would you be able to share the output of the Excel module? Only a few lines would do and you’ll likely need to change some data.

Basically, instead of Array Aggregator, you might need to look at using a Text Aggregator.
Text Aggregator can build the repeatable parts of your HTML table (the line items), then in a following module you would surround the output of the Text Aggregator with the rest of the table HTML like the header row, etc…

[eric_1]

[eric_1]

I made some changes based on recommendations I received and this is what it looks like now: