Skip to main content
mornings80
Participating Frequently
Jul 24, 2018 11:44 PM UTC
Answered

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"

  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 is closed to new replies. Start a new post to keep the conversation going.
EddieLotter
EddieLotterCorrect answer
Inspiring
Jul 27, 2018 1:00 PM UTC

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

Cheers

Eddie

3 replies

EddieLotter
EddieLotterCorrect answer
Inspiring
Jul 27, 2018 1:00 PM UTC

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

Cheers

Eddie

Translate
mornings80
Participating Frequently
Jul 27, 2018 2:41 PM UTC

Thank you!

Translate
BKBK
Community Expert
Community Expert
Aug 25, 2018 12:09 PM UTC

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

Translate