Skip to main content
mornings80
Participating Frequently
July 24, 2018
Answered

Simple formatting in a cfmail query

  • July 24, 2018
  • 1 reply
  • 1088 views

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.

This topic has been closed for replies.
Correct answer EddieLotter

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

Cheers

Eddie

1 reply

EddieLotter
EddieLotterCorrect answer
Inspiring
July 27, 2018

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

Cheers

Eddie

mornings80
Participating Frequently
July 27, 2018

Thank you!

BKBK
Community Expert
Community Expert
August 25, 2018

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