Help with automating an email task

I am trying to setup a bot that would do two things. 1) At a specified time send an email. 2) In that email pull the most recent entry and use it as the email body. We also have an enum with different unit (areas at our site) selections. What we want to happen is at 2:45 when shift changes we want our app to pull the entry from that shift and unit and email it to the next shift, shift coordinators, and others on the list.

Please let me know if this is not enough information and I will see if I can amend it.