I have a calendar that employees use to request time away. When a user adds an item to the calendar, an e-mail is generated to the manager asking for approval/declination of the time away. What I cannot figure out is how to bring in all the information already on the calendar for the day. For instance, if I request tomorrow off, but Tom Stack has time already, the e-mail should appear as such:
Coolest Person has requested time off for 08/06/2016.
Other individuals who have time off on 08/06/2016: Tom Stack - 4 hours from 8:00 AM to 12:00 PM
Does anyone have any ideas how this can be accomplished?