This attaches the results of the query SELECT * FROM Users and sends it to 
[email protected]
EXEC msdb.dbo.sp_send_dbmail  
    @profile_name = 'The Profile Name',  
    @recipients = '
[email protected]',  
    @query = 'SELECT * FROM Users',  
    @subject = 'List of users',  
...