Hello,

I have followed the advise on the post for the following and have place a 'tab' in the query_result_seperator and the csv file is still opening incorrectly.

I would just like to verify that I place a ' then hit the TAB key and close with '

Any help would be appreciate.

Code:

exec msdb.dbo.sp_send_dbmail @recipients = '@.org;@.net;',

@body = 'Here are the visits :',

@query = 'exec usp_nh_PharamacyInterventionExport',

@query_attachment_filename = 'results.csv',

@query_result_separator = '',

@subject = 'Payors Changed Yesterday',

@query_result_header = 1,

@attach_query_result_as_file = 1,

@execute_query_database = 'it'

thank you