Send report to multiple people

[robcarr]

Hi,

I have a report that is run from a form, the user selects the employee they want to report on, and then the dates they want to view, and then choose the report and the report is displayed, what i would like to do is create a similar report from a query and send each person who appears in the query that runs the report a copy of there own stats. So If the query generates 10 peoples data then it would send 10 reports to the various people.

I am just need ing advice on how to go about this.

thanks

Rob.

Hope this is of use, Rob.

 

[Remou]

Hi
I am not sure I understand you, but if you are creating these reports from a query, couldn't you step through the query and get the names? That way you could use SendObject to email the report to each person.