Craft Commerce: Export each order to a specific CSV file and send it throught email
You could write a custom Craft plugin (generate the boilerplate for it at https://pluginfactory.io) that listened to one of Craft Commerce's order events.  Likely onSaveOrder or onOrderComplete depending on your specific requirements.

From there, your plugin could build the CSV the old fashioned way in PHP, or use something like the CSV library to do the heavy lifting for you.

Once you've built the CSV, you can use Craft's EmailService->sendEmail() (accessible through craft()-&gt;email-&gt;sendEmail() to add the attachment and shoot the email off.