Can someone point me in the right direction?
I have a tablw which contains data for 6 members of the team. I want to create a query that pulls out data from a specific set of dates (entred via a datepicker on a form). I then want to filter that data and send it out a CSV file to a specific email address.
Thanks
Sounds like you can use that query to generate a CSV file, then send that CSV URL to the intended email address.
If you don’t want a link, I would suggest sending the CSV URL and the email address to Make, then download and attach the CSV file to the email module there.
That sounds exactly like what I need. I am unsure on how to achieve though. 
You can try the Generate CSV method first. Make sure you choose which columns to export.