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?