Well in the end I skipped the report entirely and just generated a string to place directly into the email body. I know a little bit of HTML (probably quite old!) and they are just simple formatting. A little bit of bold for titles, that's about it. Ended up with the below, which works nicely...
Hello, all. I wonder if any of you can tell me how to fix an odd little problem I'm having.
I'm running the following code to generate an email from a report.
The code is on the code sheet of a form, where there's a button. The user enters or updates a record on the form and clicks to...