A Log system with EasyMorph

1

Hi everyone.
I have a similar problem to the previous one, but more complex. I have an Excel file containing a network path in column A and a file name in column B. I need to read all these rows until the end of the data and check that the modification date of each file is the same as today's date.

I then create a new log file, that tells me: File A - Updated, File B - Not updated, etc.

The file's content will then be a test email, and the subject line should also include a count of the out-of-date files.
Example of an email subject: Out-of-date files: 2.
Is this possible with Easymorph?

Thanks everyone.

2

Hi Stefano,

Yes, it's surely possible with EasyMorph. See the example below.

check-files.morph (9.3 KB)
File paths.xlsx (9.3 KB)

If you're new to EasyMorph, here are the tutorial topics that can help understand what's going on in the example: