如何将电子邮件发送到从动态查询结果中获取的地址？

I am trying to enter email addresses based on the userids found in the query results , The query find the user that are violating the system and using those Ids we wish to query another table to get there full email addresses and place them in as recipients.I am trying to enter email addresses based on t