Sounds like s job for PowerShell, or an SSIS package, or bcp. It's not a feature of native T-SQL. SSMS has the capability to direct output to a file, and even include the query text, but it's not scriptable AFAIK.
-----------
With business clients like mine, you'd be better off herding cats.