I have created a report that sends an email at 8:00 in the morning of a task assigned to that person that is due on that day. As it stands right now if there are 10 tasks someone must do that day they will receive 10 different emails. How can I send all records in one email? Iโm sure it has something to do with a start/end formula but I havenโt been able to figure out how to use it. I would love is someone could just tell me exactly how it should look. below is the body template for the email:
Task: <<[Task]>>
Date: <<[Date]>>
Document: <<[Google Document]>>
Assignee: <<[Assignee]>>
Category/Event: <<[Category/Event]>>
Status: <<[Status]>>
COMMENTS: <<[COMMENTS]>>
ID: <<[ID]>>
<<_ROW_WEB_LINK>> TO GO TO TASK IN APP
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |