How to Email Sql query results?

Environment: Sql server 2000, C#, VB.Net

I would like to run a sql query and send the results of that query to an email address in the body of the email.

**************************************************************
Sql:
Select count(books)
from Authors
where published >= getdate()-7

Email:
The number of books published this week = (the result from SQL query)

**************************************************************

I would like to automate this task so somebody doesn't need to run it every week.

Please advise how can this be programmed?

Thanks.