Format an Attachment when using xp_Sendmail

[klewis10367]

How can I format my output query when using the xp_sendmail in sql 2000. The following is the code i am using and the attachment is unreadable:

exec master..xp_sendmail @recipients='klewis',
@query='Select * from integrations.dbo.TRKtransExceptions',
@subject = 'Missing trako Memebers',
@message = 'This is a test',
@attach_results = 'TRUE',
@width = 256,
@separator=',',
@attachments = 'Trako Members.txt'

 

[JayKusch]

Maybe you need to preface "where" the attachment is like ...


@attachments = 'C:\MyDir\Trako Members.txt'


Thanks

J. Kusch