HTML email body text wrap

johngouws · ‎2023-01-15

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.

marcus_sommer · ‎2023-01-16

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

johngouws · ‎2023-01-18

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>"

Application Development