Create a button, create a client script.
Add that client script in the suitelet.
Create a function in the client script which the button calls.
Write the logic of creating the CSV and send the email.
Alternatively you could also call another/or the same suitelet from the client script, with which you can download the CSV.