Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
Partner - Specialist
Partner - Specialist

HTML email body text wrap

Good morning. 
I have a working email body, but I have to have everything in a single line, like this: 
<html><body><p>Good afternoon.</p><p ALIGN=LEFT>Management Report - PDF File Attached. This email is an automated procedure.<br></p><br><br><br><p ALIGN=LEFT>Kind Regards.<br>Report Manager.<br></p></body></html>

How can I break the lines to make it more readable? Like this: 
<html>
<body>
<p>Good afternoon.</p>
<p ALIGN=LEFT>Management Report - PDF File Attached. This email is an automated procedure.<br></p>
<br>
<br>
<br>
<p ALIGN=LEFT>Kind Regards.<br>Report Manager.<br></p>
</body>
</html>

Thank you very much. 

Labels (1)
2 Replies
marcus_sommer

Maybe: replace(String, '><', '<' & chr(10) & '>')

johngouws
Partner - Specialist
Partner - Specialist
Author

Hi @marcus_sommer .

Thank you for those pointers. I eventually got it to work. I am not sure if it is technically correct, but it does what I need it to do. 

objEmail.htmlbody = "<html><body>" _
& "<p>Good afternoon.</p>" _
& "<p ALIGN=LEFT>Management Report - PDF File Attached. This email is an automated procedure.</p>" _
& "<br>" _
& "<br>" _
& "<br>" _
& "<p ALIGN=LEFT>Kind Regards.<br>Report Manager.</p>" _
& "</body></html>"