Hi Andrew,
Just to make sure I understand, you would to first generate a view from a content calendar table, that is either due today or over due.
You would then make a report from that information, and send it through gmail.
You could use help with ...