Send Email with totals
I have a listview that is sorted by sub summary fields. that display totals.
I want to be able to send an email every hour to users to notify them of the totals with what product.
The problem is the product and totals change all the time so I can't hardcode it using sql. I want to just go into the layout do a find on current date and time and whatever products appear, email those totals.
How can I accomplish this?