Setup a weekly custom email with recipient list based on criteria from DatSet or card data
I would like to schedule an email to be sent out Monday mornings, but the recipient list is different every week as it is based on current data in a DataSet for temesheet entries per employee. More specifically, for all employees that reported less than 40 hours of work last week, a friendly reminder is sent to this sub-group to complete the timesheet.
I am hoping that this email is sent out automatically and without my involvement. Is there a way to set this up, or is there a possible work-around?