Make sure SQL Mail is running (test it in Enterprise Manager -> select the server name, then click Support Services -> SQL Mail and test to see if it's working).
Then use the xp_sendmail extended stored procedure.
Format (incl. passing a SQL query to the mail):
EXEC xp_sendmail @Recipients='
[email protected]', @Subject='Subject', @message='Message', @query='Select field from table'