Using SendObject() to generate individual emails with Reports

[accessmatt]

I'm at a loss and I'm hoping someone can help. I have an Access DB that I'm trying to generate individual reports via email to multiple recipients based on email addresses stored within a table. What I think I need to occur is for a macro to execute a query that generates person specific reports and then use the sendobject() command to generate emails. Since I'm trying to generate individual emails, I'm assuming I need to loop through the execution so the sendobject() command is triggered after the creation of each report. Any thoughts.

 

[Remou]

This is a topic with many posts. For example:
Loop through records in table and output to string,then email
thread181-1109050