SQL Output

Hi there

I need to have a basic select statement to run automatically, which I can do, but I need the results to be saved to a txt file and then emailed to a group of users, I used to do this in oracle by using the spool statement, any ideas?