Hello,
What’s the best way to auto-generate (at 9am PST) an email that goes out to members of our Engineering workspace, something along the lines of:
"Good morning Engineer:
Today is [date].
Yesterday you were scheduled to work on
[populated from tasks].
Today you are scheduled to work on
[populated from tasks].
Tomorrow you are scheduled to work on
[populated from tasks].
You have the following overdue tasks:
[populated from tasks]
Have a great day!"