sending html and plain/text email using msdb.dbo.sp_send_dbmail

[ck9663]

guys...i got tired searching the net for some reference...thi s is what i have so far:

set @@tableHTML = '
    <p>some code</p>
    <p>some code</p>
     <table>
        <tr>
            <td>some header1 here</td>
            <td>some header2 here</td>
        </tr>
        <tr>
            <td>some datat1 here</td>
            <td>some data2 here</td>
        </tr>
     </table>'

         EXEC msdb.dbo.sp_send_dbmail @recipients='recipients@domain.com',
            @profile_name = 'sqlserveremailprofilename',
            @subject = 'This is the subject',
            @body = @tableHTML, -- this variable are series of HTML codes
            @body_format = 'HTML'

i need to check if the outlook email of the recipient can display HTML, otherwise it should display plain text. could you guys point me to the right direction or if anyone has a sample code that i can use?

thanks

--CK