New Line in VBA Script

[tylerg11]

I have a button on my form that opens a new outlook email, and populates the body with data. I want to use a carriage return to seperate the text strings. I am using the keyword "vbNewLine", and while it creates a new line, the cursor can't "click" into that blank line...almost like "vbNewLine & vbNewLine" did a double space. I don't want this because of the formatting that results on the receiver's end...sometimes the spaces are removed. Are there any other key words I could use that would follow the behaviour of the enter key?

.Body = "My Text String" & vbNewLine & vbNewLine & "Second Text String On New Line"

[RuralGuy]

I would try vbCrLf which is a Carriage Return and then a Line Feed. ^M^J

[tylerg11]

So would that be something like this?

"FirstParagraphString" & vbCrLF & vbNewLine & "SecondParagraphString"

[RuralGuy]

Experiment a bit.

[tylerg11]

I tried it, and it works....however, I'm getting the same result. For example, if I place the cursor at the end of the first line, and hit the Down Arrow button, it doesn't move the cursor into the space, it just completely skips it. I don't want this because the email received with some email providers removes that blank space

[RuralGuy]

How about putting just a period on that line?
.
.

[tylerg11]

I don't want that in the email though. Maybe I could use " "? I was just wondering if there was a VBA keyword I might have been missing. But it seems like they all basically have the same result.

[RuralGuy]

Good luck on your quest.

[tylerg11]

Thank you.