Scheduling A Data Export From Server

I have a sql server query that when run, produces 8 columns of data and some rows of data.My colleague has this in a stored procedure, and each week is running a manual crystal report, exporting it into a data only excel sheet, and emailing it across to the rest of the business.Is there a much easier, more automated way of doing this? What would be the best method of storing this query so it could be scheduled, a stored procedure, or something else? The query is below -

DECLARE
@startdate datetime,
@enddate datetime
SET @enddate = DATEADD(wk, DATEDIFF(wk, 0, getdate()), -1)
SET @startdate = DATEADD(wk, -1, DATEADD(wk, DATEDIFF(wk, 0,getdate()), -1))

[code]....