We have a report that keeps the time data(hours booked by them in a month) of around 300 employees.
Now we want that if for an employee the number of hours booked by him is less than the aloocated hours, then a mail should be triggered to his/her supervisor
But the problem is the mail is triggering only for 5 people not for all of those whose hours booked is less than the allocated hours.
Please suggest any method
From what I understand he is not even trying to send to 300 employees. He is sending an alert to the supervisor of those employees who's hour bookings don't match what was allocated.
You can't solve that with a distribution list, as that list of recipients depends on the search results and also I assume you want to only send relevant data to each supervisor.
Actually its a query that is being sent as an alert.
The query actually has some conditions that brings out those people whose booked hours is less than estimated for a particular month.
It also has a supervisor column which is matched with their respective employee.
Then i am trying to run this as an email alert.
say like if my booked hours is less than the allocated then an email should be triggered to my supervisor saying that i have booked less hours.The email will not send any number related to hours.
And this will not go as a pdf
By default it is 100(Number of recipients). it could be increased till 10000.
Pls refer the below mentioned link for more information: