Sending output of Query to someone via email

[Steve]

I have written a macro to run to separate queries (using
the open query command, however, I would like to automate
the sending of an email using the output file as an
attachment once each query has been run (an email for
each query).

Can this be done ?

If so, what do i need to so and how do input the email
address, subject and ensure that the email is sent ?

Thanks
Steve