Hi everyone, I have an online manuscript revision system. When an editor assigns a reviewer to review a manuscript, he sets a deadline date for reviewing. I want to run a scheduled automated email to send reminder email one week before the deadline date. I know it should be easy but for some reason i cannot get it done...
Any help will be appricated.
Thanks in advance.
Set a scheduled job to run every day.
The script should get ALL manuscripts (from DB) with deadline = now + 7 days
For each of the selected manuscripts generate reminder email...
Thank you very much!