How to inset a new line in the body text when sending email with vba aceess

[benny goldenberg]

Hello ,
I have a problem when i want to send email with vba aceess
I do not know how to insert a new line in the body message .
Can anyone help me to solve this problem.
I tried "NewLine" , "VbCrlf" , <br>
It does not work.
Benny

 

[arnelgp]

it the body is plain text, just add vbCrLf:

.Body= "message" & vbCrLf & "another text."

for html:

.HtmlBody = "message<br>another text."

 

[Gasman]

Croosposted https://www.accessforums.net/showthread.php?t=86384

 

[theDBguy]

Hi. Welcome to AWF!

Also, how the email message is rendered or displayed depends on the email client settings. Maybe check there as well.