Getting Results In An EMail PDF?

We have the following proc that executes an e-mail and attaches the resulting query as a TXT attachment. Is there a way to make the attachment be a PDF?


@MYRECIPIENTS varchar (500)

, @MYSUBJECT varchar (50)

, @MYBODY varchar (500)

, @MYQUERY varchar (1000)

, @MYIMPORTANCE varchar (10)

, @MYPROFILE varchar (50)

as

declare @NewSubject varchar(200)

set @NewSubject = @MYSUBJECT + ' ' + Cast(GetDate() as varchar(20))

Execute msdb.dbo.sp_send_dbmail

@profile_name = @MYPROFILE

,@recipients = @MYRECIPIENTS

,@subject = @NewSubject

,@body = @MYBODY

,@query = @MYQUERY

,@importance = @MYIMPORTANCE

,@attach_query_result_as_file = 1

,@body_format = 'HTML'