Is there a way to automate sending a report of records to different email addresses? eg. A first group of records in the report gets sent to one email address and another group of records in the report gets sent to another email adress and so forth.
So far I have noticed that when scripting one email gets sent with every record regardless of how the report is sorted and header/footers added. So, for example, if I have a group of people and records in one sorted report by person and then their applicable records on the screen and I want to send the relevent records in one email to each applicable person can this be done?