update in table view in the email at the end of the day

[Aman991]

Hi, 
I want to develop a bot that will run and send an email to owner about the activities occurred today let say 6:00pm everyday. 

I tried, one workaround in which we can send an email for each entry in table. in that case if there is 50 events occurred at any particular day than it will send 50 mails at ones. how I can combine them in table and schedule a process for single email task. 

also is multiple tables that are connected to one table we can send one combined data related to it in one email?
@Steve