Yisaacs,

I am persisting with exactly the same problem and running into the same brick walls you are.

Trawling the internet suggests that it seems to work in some environments and not in others.

I've tried csv/xml with variations on all the switches.

I either get an attachment with most of the output truncated or all in one column like you or some rubbish hex data.

On their own, the queries are fine. Whack them into sp_send_dbmail and you enter the secret society of SQL mail programmers. Someone has the answer, but ain't telling. 🙂