Using Carriage Feed and/or Line Feed in string variable

[dougdrex]

I'm using Excel 2010.

This seems like a fairly basic function, but I'm having trouble getting it to work the way I intend.

I have a string variable that is being passed through to the body of an email. There are different pieces of information stored in named ranges of the Excel file that need to be passed through to the variable, and there should be a new paragraph when each section begins.

Below is the code I have, but it is not working. What am I doing wrong?

strBodyText = Range("Greeting") & vbCrLf & Range("Body1") & vbCrLf & Range("Body2") & vbCrLf & Range("Sig")

Thanks!
Doug

 

[shg]

If the email is formatted as HTML, change vbCrLf to "< br >" without the spaces.

 

[dougdrex]

If the email is formatted as HTML, change vbCrLf to "< br >" without the spaces.

Now it's giving me a syntax error. Here is the code after I used the "<br>":

strBodyText = Range("Greeting") & <br> & Range("Body1") & <br> & Range("Body2") & <br> & Range("Sig")

 

[dougdrex]

The code for Post #3 should have been as shown below. The "< br >" does not have spaces in the actual code.

    strBodyText = Range("Greeting") & < br > & Range("Body1") & < br > & Range("Body2") & < br > & Range("Sig")

 

[shg]

< br > (sans spaces) has to be in quotes as shown in post #2 .