I have a requirement where user would select level and then user should be able to send report in excel form to the selected level of person
Example lets say there are 10 Managers and each manager has 5 employes and these 10 managers are distributed in 5 senior managers.
If I select level as Senior Manager and select name of the Senior manager then an excel should be generated with All the manager and the employess under that manager and should be emailed to Senior manager since level selected was Senior Manager.
No w if i select names of 2 different Senior managers then 2 mails should be generated and send to each indiviual manager with there respective managers and employees.
This should be done through access point with click of a button .