topic HTML email body text wrap in QlikView

HTML email body text wrap

johngouws — Mon, 16 Jan 2023 03:55:58 GMT

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

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

Thank you very much.

Re: HTML email body text wrap

marcus_sommer — Mon, 16 Jan 2023 15:51:27 GMT

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

Re: HTML email body text wrap

johngouws — Thu, 19 Jan 2023 03:03:48 GMT

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>" _
& "Good afternoon." _
& "Management Report - PDF File Attached. This email is an automated procedure." _
& " " _
& " " _
& " " _
& "Kind Regards. Report Manager." _
& "</body></html>"