Simple formatting in a cfmail query
I am trying to have cfmail send a list (the result of a query) from an access DB. I would like each value separated by some blank lines. I have inserted </br> but they don't get treated as html, they are just sent along with the results:
<cfquery name="P1" datasource="DB">
SELECT * FROM Table1
</cfquery>
<cfmail query="P1"
subject='Testing CFMail'>
<cfoutput>
#Col2#</br></br>
</cfoutput>
</cfmail>
The resulting email looks like this:
Result1</br></br>
Result2</br></br>
Result3</br></br>
I would like the </br> treated as html and not included in the email. Any suggestions would be appreciated. TIA.
