I have the basic syntax for BCP to a CSV file down. I have 2 ?'s regarding this procedure.
1) is it possible to copy header text (meaning field names?
2) is it possible to delete the file once it has been attached to an email?
As long as your header information is static, then you can have the header information in a single file, and "prepend" the header information on the data file (you will end up doubling the data file size, of course. You just need to make sure that the header file ends with a new line character:
C:\>echo This is a dummy header > test1.txt
C:\>echo And this is dummy data > test2.txt
C:\>type test1.txt, test2.txt > test3.txt
Deleting the file after it has been attached to an email, depends on how you get confirmation it has been attached and emailed successfully.