Output to Excel
An easy way to get the data to a mailing list is now to output it to Excel, where we can easily manipulate it into a variety of formats without further programming.
Here's what that output looks like in Excel:
At this point we have a report that runs and is useful. It can be enhanced to support more complex selection criteria. As usual, there are a number of different ways to accomplish essentially the same result. Some of those paths would be significantly different for the developer, but nearly invisible to the user. Some might not even matter to the next developer who has to work on this report. What is important at this point is that the result works reliably, provides the desired output, operates with reasonable speed, and does not cost too much to create or maintain. If all these goals are met, most of the other differences are usually not very important.
