send object – csv file

Can anyone give me a clue as to how to send a csv file direct from a query in Access, it will only allow a txt or xls.
Failing that – what vba would I use to send a file created on the hdd to an email recipient

either answer should be fully automated at the click of a button

Thanks