How to select multible rows in a table

[Teodor]

Of course you can filter a query using an array with multiple IDs.
Once you filter the query add the records to an array and use the array value in the email body.
Check the docs about using arrays in server connect:

Working with Server Connect Array Lists

Intro The Server Connect Array List component allows you create and manipulate Array Lists easily with Server Connect actions. You can add items to an array, join multiple sources, remove and set arbitrary items, keep simple or complex objects or collections in an Array List. It's also easy to use it as a string builder, when you need multi lines strings. Basics In order to be able to add items to an array you first need to define the array. The Array List actions are located in the Data Man…