You can also write the output directly to a file from SSMS.

Choose 'output to file' instead of 'output to grid'.

You might also like to check the option to 'quote strings containing list separators when saving .csv results'.

Yet another alternative is to use the SQLCMD extensions built in to SSMS, there is an example here on MSDN