T-SQL script modified to send out emails / msdb.dbo.sp_send_dbmail

General information for the business: industrial production
Description of requirements/functionality: Hello,

we currently send out Tables by email to a group of employees like:

eMail to sm@ikmaier.com;wm@ikmaier.com;zz@ikmaier.com
Name | eMail | Sample-Data
Steffen Maier | sm@ikmaier.com | 5
Steffen Maier | sm@ikmaier.com | 2
William Maes | wm@ikmaier.com | 3
=====================================================


Using this command:

EXEC msdb.dbo.sp_send_dbmail
@recipients = 'sm@ikmaier.com;wm@ikmaier.com;zz@ikmaier.com',
@query = 'SELECT * FROM TABLE'



Now, we want so send out an eMail to the same people, but only with their data.
Like:

=====================================================
eMail to sm@ikmaier.com:
Steffen Maier | sm@ikmaier.com | 5
Steffen Maier | sm@ikmaier.com | 2
=====================================================

=====================================================
eMail to wm@ikmaier.com:
William Maes | wm@ikmaier.com | 3
=====================================================

=====================================================
No eMail to zz@ikmaier.com, because its not in the table.
=====================================================
Specific technologies required: T-SQL (for Microsoft SQL Server)
OS requirements: Windows
Extra notes: