Sending email with data from more than one table

We have a nominations process where multiple people may bid for a job, then the person responsible for the job needs to send this to an external party via email to make a selection from the multiple nominations.

Is there a way to include a table of records in an email, rather than individual records?

Or more broadly to construct email in a way that can encompass data from more than one table, provided they have a connection?