You can easily do this using the SQL Server DB Mail (SQL 2005+, I think). You'll need to enable it via the Surface Area Configuration tool (or system options) and configure mail profiles on your SQL Server instance prior to using it.
You can look at SQL BOL, or this MSDN article which lists all of the DB Mail stored procedures and provides additional links for using them.
Once you have DB Mail enabled and have configured a mail profile, the syntax to email query results would be something like this:
@body='Query Results Are Attached',
@subject ='Query Results',
@query ='SELECT * FROM mytable',
@attach_query_result_as_file = 1,
After you have your statement working properly you can create a SQL Agent job to execute it and have it run on a regular schedule.