Weekly Alert function & Grouping of rows
I am working on a data of approx 100 rows and this data is divided amongst 10 user, Manager of these 10 user is same. I have created a weekly alert to send the report to these 10 users of their accounts to get the status and their manager every Monday but it seems the alert is not generating the expected report as it simply grouping the 100 records and sending it to these 10 users and their manager.
Can anyone suggest the workaround for this, i have attached the screenshot which is received when alert runs every week.
I have inserted the Placeholder in the subject line but it seems after certain limit it doesn't work
And in the end it shows the message truncated due to length.