My teammates and I (4 of us total) use a task log in SharePoint to keep track of tasks. I have been tasked (hah!) with creating a daily summary email to be sent to each user containing tasks overdue, tasks due today, and tasks coming due (within the next 5 days, let's say).
This email should go out daily, the time is flexibly (probably before 9 am).
I can't do timer jobs as I don't have Visual Studio nor do I have SharePoint Server installed on my machine.
I would like to do this via a workflow, if possible. It can pause for 24 hours, etc. if need be, but I have no clue how to get started. I've been googling for 4 days now and am not much better off for it.
The basic summary email should look like this:
Hello [User], You have [X] tasks past due: - [Task 1] - [Task 2] You have [Y] tasks due today: - [Task 1] You have [Z] tasks due within 5 days: - [Task 1] - [Task 2] - [Task 3]
SharePoint version is 2010, I have SPD 2013 installed on my machine. I do not have SharePoint Server.