I have to make a workflow that sends a weekly reminder to the managers of some listed employees, that's not a hard task to do, I've set the workflow to send the reminder to the manager's email column, but the problem comes whenever there is one manager for let's say 100 employees, so each week that manager will receive 100 email reminders for each of the employees. And that's what I'm trying to prevent, how can I set it up, so if a reminder email has been sent to this particular manager(this particular manager email), not to send it anymore for that week, to be sent only once to each of the managers, no matter how many employees they have signed to them?
Ok..You need to have a flag in your workflow. Create one more Column say EmailSentThisWeek and assign it default value as No. From the workflow change this column value to Yes as soon as the first email is sent. Once the column value is set to Yes check for this column value( IF condition) before sending another email. If its value is Yes then it shouldnt go inside IF condition and hence no email will be sent.
See Benny you could possibly save mangers name along with a date (Today) in another list. This could be done in workflow, and have another field named as flag. Now you create item in this list every time manager receives an email. Most importantly you will have to keep a check in the second list for every instance of workflow. If the manager already exists with date (today) , end the workflow there itself. This is appropriate for one day , now you have to extend it for a week.