I am trying to send a report to a list of employees.
I have a query that generates the report into the layout I want and includes the e-mail address of who the recipient should be.
The report looks something like this:
--Employee Name--
--E-mail address---
-Hire Date----Tenure-
-Attendance-
-Quality Score-
...etc...
I need to send, for each row in the query, this report based on the results of that particular row.
How would I go about making a e-mail template that would be used, or at least sending the report as a PDF attachment? I've seen the sendObject method, but I cannot seem to wrap my head around it.
I have a query that generates the report into the layout I want and includes the e-mail address of who the recipient should be.
The report looks something like this:
--Employee Name--
--E-mail address---
-Hire Date----Tenure-
-Attendance-
-Quality Score-
...etc...
I need to send, for each row in the query, this report based on the results of that particular row.
How would I go about making a e-mail template that would be used, or at least sending the report as a PDF attachment? I've seen the sendObject method, but I cannot seem to wrap my head around it.
