A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I created a test workbook; the code works for me.
If you like, you can download it from https://www.dropbox.com/s/k16mzi6099gaw02/MailReminders.xlsm?dl=1
Right-click the downloaded file and select Properties from the context menu.
Click Unblock, then click OK.
Make sure that you allow macros when you open the workbook.
For testing purposes, I have set the macro to run 1 minute after opening the workbook.
An email message was displayed:
And the worksheet was updated:
See https://www.dropbox.com/s/k16mzi6099gaw02/MailReminders.xlsm?dl=1