Fields of a query in the body of an e-mail

Job ID: 32326509

Budget: $10 – $30 USD

I have a form with a subform, based on a select query.
I made already a function that generates an e-mail.
All what i need is the help to add the fields of the query (an order of procucts) into the body of the email.
I think with recordset, but i don't understand how
Related categories: Microsoft Access Visual Basic for Apps