Send email reminder based on due date while excel doc is closed

hi,
I am not sure this particular question was solved but I was not able to find the right solution.
I have due date on items on the document. I want to automatically send a note to the owners to remind them it's due in 7 days while excel is closed. I don't want someone to open it everyday to check. If an item is coming to due, they'll get the alert or reminder automatically. I was able to find something that can send an email when a cell is certain value but it's not done automatically.
Any help would be awesome.
Thanks

I'm not sure if you can that strictly with VBA. I'm guessing (and only guessing) you need a 2 step approach.

1. Some kind of cron script or windows scheduler to open the excel file on a daily basis, maybe something 4am, etc.
2. Then with excel, you can use VBA an On Open command to check the due date and email out. and then close excel.

Remember, this would also require the PC to be on at all hours. Perhaps you are doing this on a Server or VM setting?

Do you have a working/sample file to help get started? I'm not an expert here like others, but I can try and help best I can.