Send formated query result by mail

[Rolf Kemper]

Dear Experts,

I want to send a formated query result by mail.
I'm running SQL Server 2000

1) How can I achieve that the printed length of a field is based on
the minimum required length to show the stored data uncut( Means the
fieldlength is the maximum required length found in all items of a
column ) ?
What I'm looking for is like this ones

A) SELECT @MailString = @MailString + REQUIRED_LENGTH(column_name1 ,
alias ) + REQUIRED_LENGTH(column_name2 , alias2 ) , ... + @CRLF
FROM tab.
B) @MailString = NICE_PRINT('SELECT column_name1 as 'alias1' ,
column_name2 as 'alias2' , ... FROM tab')

Approach A is probably very inefficient.
Approch B is probably more complex

I guess many of you have solved that problem already.
Every tip , example or hint is highly welcome.

Thanks a lot
Rolf