SJT,

\t would definitely work. I guess I didn't fully understand what the @seperator parameter does. But now I know it is just to seperate the two columns and that is...

I noticed something... the white spaces I am tryign to get rid off are 'tab's. I tried setting @seperator = 'tab' but that just puts 'tab' in the beginning of...

Martin, thank you for your comments.

I tried changing the @seperator parameter to . and ,

Each time, those characters were placed at the end of the column record, but it didn't...

Thanks for your reply. YES, I have tried @seperator parameter as well. see below

EXEC master..xp_Sendmail

@recipients = 'myname@mydomain.com',

@no_header = 'true',

@separator ='  ',

@query = 'Select customername, custno, dateregistered...