Hello, I want to know if it is possible to enable monthly task summary even if there is no changes on that particular task, solution can be via powershell/workflow/sharepoint.
Idea is that my supervisor wants to have monthly summary of all incomplete tasks and tasks created in current month.
They would love to receive mail from sharepoint with summary of all those tasks, in which they could see all the info like they see in regular summary when something changes in task.
Please give me some idea or if solution if anyone has done something like this before.
Here is what I get on another forum: http://sharepoint.stackexchange.com/questions/148856/sharepoint-2013-monthly-task-summary
I can suggest you two ways to do that
- Using SharePoint Timer Job which runs monthly
You can create a custom timer job which will iterate through all the the sites and then tasks list within a webapp. Then for each tasklist you can find the newly created and unfinished tasks format them in a presentable way and then use SpUtility.SendMail() to send the mail.
- Using PowerShell and task scheduler
Basically you do the same task in powershell and then schedule the script to run monthly.
- Workflow options are also available but you’ll need to attach those workflows with every task list and that’s in my opinion is not that much scalable.
