Email with lots of multiple record info...

[Macgyver]

I'm overhauling an old FM DB which uses a hideous script to generate an weekly status email.

There's some generic text, plus some field data from each record in the found (project) set, and each of those includes some data from each related (task) set.

So, 'Projects' contains Project A (with 'Tasks' 1, 2, 3), Project B (with 'Tasks' 4, 5, 6), Project C (with 'Tasks' 7, 8, 9).

I can think of multiple ways to do this, but I'm curious if there's a particular approach that most straightforward and popular?