Simple formatting in a cfmail query

[mornings80]

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"

  from='user1@gmail.com'

  to='user2@gmail.com'

  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.

[EddieLotter · Accepted solution]

Add the type="html" attribute to the cfmail tag and remove the leading slash in the br tag.

Cheers

Eddie

[mornings80]

Thank you!

[BKBK]

Hi mornings80​, please mark the correct answer. That will certainly help someone in future.