Email a report

[Guest]

I have a report in which each page is a personalized letter (each has
differing data). I'm needing to email each page to a different school
every week. Is there a way to break out each individual page for email
purposes.??

Thanx - david

 

[Rick B]

I have done this in the past by using code to loop through all the "schools"
and create the report only for them, then email it, then loop to the next
record (my example was a Work-In-Process report that was emailed to each
employee once a week.

I built a form and based it on my list of active employees. I had an
EmployeeID field on the form to display the current employee id. I had a
button on it that would run the report (with the query criteria grabbing the
UserID) and email it. The code would then move the form to the next record,
and do it all again. this happened until the end of file was encountered.

I don't have this database around any more, so I can't share the exact code
with you.

Good luck!