What we do for such needs :
- scheduled workflow
- query the list to get the needed item (user = *** and status != completed)
- loop on the result collection to build a table or a multiline variable
- put the table in a email and send
The recipient get an email like :
"You have 20 items to complete for today :
- Item 1
- Item 2
....."
If you need to format the email, you can use the Build String action to create HTML containing references to the items in your collection and store them in a multi line variable. Then this will allow you to append your HTML each time and build the HTML into something like a table before putting the that final HTML into your email.
This just builds on the correct approach Thomas has suggested.
Thanks for the responses, my troubles are that I don't know how exactly to build the table nor do I know anything about HTML codes.
Hi,
So we do something similar all the time. Basically the trick is:
1) Query your list of tasks to get the results (I think you have all of that thus far), however make sure you order by the user that you are wanting to send the summary to
2a) Create 4 variable - one for an top table, one for the end table and one for an inner table and one for the emailTXT, all must be multiple lines of text
2b) Create a variable for PreviousUser as string
3a) Set the top table variable to something like <table><thead><tr><th>User</th><th>Task</th><th>Due Date</th>.....</thead></tr><tbody> - filling in any headers you want in a <th></th> tag as per examples above
3b) Set the end table variable to something like </tbody></table>
3c) Create a variable for the count lets call it iCount
4) Create a for each loop and loop through the results from step 1 stored in a collection
5) In the loop check if the PreviousUser is equal to the current User we are looping though
5a) If PreviousUser is not equal to User and PreviousUser is not blank then update the emailTXT to html using a build string equal to <h1>User has iCount tasks open</h1><h2>Summary</h2>+top table + inner table + end table and save output to EmailTXT
5b) add EmailTxt as body of email and send summary to user or users manager or whomever you want it to go to
5c) Reset Inner table to "" and iCount to 0
5c) if the PreviousUser is equal to User or PreviousUser is blank then
Buildstring for Inner Table <tr><td>User (variable)</td><td>TaskNmae(variable)</td>....</tr> - note you need to match all columns to all header columns
Do a maths calculation of iCount+1
Loop
6) Final step - after you have looped through all items the last item would NOT have sent a mail so copy steps 5a - 5b outside of the loop to send the last email.
Give me a shout if you need some more information.
Thanks
Craig
, with the solutions provided were you able to resolve your issue?
This was the post I'd been trying to find before.
All your resource should be in there, you will need to do some HTML, but hopefully in there is enough detail for you to produce something.
