Automating Manager-Employee Report

Hi, 

I've looked through the documentation but can't seem to find what I am looking for. 

I am tying to automate an email sent to all individual managers with their associated direct reports attached for approval that it's right. Do you think this can be done?

Your help here is greatly appreciated. 

Please excuse my noobness. Slight smile