You can pretty much do that in Workflow. Since you are already succeeded with Search query in the Workflow, I assume the search result will be an array list and you need to
- Create Send Email Action
- Build the HTML table in the Body
- Iterate through the Search result’s array list by using VTL and set the value to each cell
Here is the reference Workflow: Fetch Array from HTTP request and send in Email in a table with separated values with similar scenario.
Hope this helps you.