Yes and no.
The CSV feature is only for writing to a file on the server.
But, you can use the PlainTemplate feature to create a CSV file and then attach that using the "null" filter with the attachment specified in the "filter_options".
You'll find several posts about doing this on the forums. "Search" is your friend.