I have a requirement to send email notification at specific time. In salesforce I have a list of employees stored in there. I would like to have an option to send email to all the employees who have a specific status field value = 'active'.
I would like to have the capability to specify the time when the emails should triggered to all the employees with active status.(I have a process builder set up which send out email alerts).
In a gist- I would like to send out mass email to all the employee stored in Salesforce at a specific time mentioned by the admin. There are about more than 10,000 employees in salesforce and all are outside of salesforce. May be not use process builder and send email alert using single or mass email messaging. But I think there is a limit of 1000 on these and I have more than 10,000 employees to whom I have to send email alerts. Correct me if I am wrong.
What can be the best way to achieve this. Is there any appexchange app which can support this functionality?