Distributing Reports to List of Email Recipients (not attachments)

[PatK]

Was wondering if anyone had tackled this. I see a lot of code/discussion
around attaching reports, but nothing specifically about this.

I have a table of email addresses, and each of these folk are responsible
for specific projects (rows in another table). Status get's updated to the
project rows regularly.

I would like to create a set of code that would distribute specific project
row details, via a nice pretty (not an attachment) report, generated via VBA.
Each report is fundamentally unique. There is common way to link the email
list to the table via a join, that would link the email address, to their
owned rows in the project table.

I was thinking relatively simply HTML coded output using Send. Ie, I build
the string that is to become the report content, and send that to the owner
of the rows associated with that content.

Any examples, you have, even it not specifically as above, that would show
the code to loop through the email table, and then query the second table for
content, format it, and send it would be great! Note: of high interest is
how I would format the content so that I can produce "tabular" email reports.

Thanks a million!

PatK

 

[PieterLinden via AccessMonster.com]

use a recordset of e-mail addresses, based on your table, then create a
filtered report of the individual person's projects, then use SendObject to
email it.