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

benny goldenberg

New member
Local time
Today, 20:09
Joined
Jul 30, 2022
Messages
1
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:09
Joined
May 7, 2009
Messages
19,169
it the body is plain text, just add vbCrLf:

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

for html:

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

theDBguy

I’m here to help
Staff member
Local time
Today, 11:09
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!

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

Users who are viewing this thread

Top Bottom