VBA Email Text too long for screen

[TallMan]

Hey Guys,

I think I have an easy one for you. In my VBA code I have a body to an email which is too long so it does not let me type anymore characters.

Does anyone know how to kick it down to the next line???

I think is is something like this.

.htmlbody = "first line"...................................................................
.htmlbody <1> = "second line"........................................................

Am I completely off on this one?

 

[pbaldy]

My preference is line continuation characters (space-underscore):

.htmlbody = "blah blah " _
          & "more blah blah"

the other way

.htmlbody = "blah blah "
.htmlbody = .htmlbody & "more blah blah"

 

[TallMan]

Great!! Thank you PBaldy. That was very easy.

Do you know a way to have a piece of the text be a hyperlink?

 

[pbaldy]

Sorry, never saw your reply. I assume since you're building an HTML body, you could build a normal HTML link, which if memory serves would look like:

<a href="PathHere">Description here</a>