Send report of all changed or updated content in past day? Trying to use Rules to do this but I think it's a bit too complicated.

I want to specify a time interval - say 24 hours - and generate an email report that lists all of the content that has been changed or created.

I can do this for individual items quite easily, but I'm looking for an aggregate report that someone could look at in the morning or evening to get a general overview of all the content changes.

I did stumble across the Views Rules module, which is interesting. It would allow me to create a view containing all the new content or updated content in the past xx hours and present that data to Rules. But it seems that would still just allow me to loop over the data and send out individual emails.

I could of course just write a small module to do this as well, but I'm wondering if there's an existing solution?
Have you loooked at message notify?
Have a look at the blog post by gizra 
or watch the video, message notify allows you to use view as the body of the email.