I have created a musical casting database and my goal is to email each cast member their personal rehearsal schedule. What is the best way to mail merge each cast member schedule into a field to email. Note that I need the capability to format the date and time a certain way.
I have attached my solution file.
Thanks for your help!