Email the results of a database query

I am trying to email the results from a database query.

I create a Server Action
Add a database connection
Add a database query
Add setup mailer
Add a repeat
Inside the repeat i add my Send Mail.

It email s me but with as many emails as there are records, so i get 29 emails if it matches 20 results, even though i have only setup static content in the email for testing purposes, i still get 20 emails.
If i take the send mail out of the repeat though then i cant access the dynamic data returned by the query so I am stuck with it in the repeat step.

Please let me know if i am doing this incorrectly.

Community Page
Last updated: