next line in text file - VBA

[ericlch16]

Hi

I have a string variable (mystring) that i use to display in the body of the email.

I also have a text file which will have same contents as mystring.

In the email, <br> is considered a next line and this works fine.

Now I am trying keep the line break in the text file. So, i did this

Replace(mystring,"<br>", " & vbCrLf & ")

However, I am not getting a line break. Instead it is displaying the string " & vbCrLf & " in text file. What is wrong with that statement? Thank you

 

[Gokhan Aycan]

Remove the double quotes and ampersands, you are making the replacement a string as is.
Edit: Not sure about ampersands actually, try with/without

 

[rlv01]

Why not just Replace(mystring,"<br>", vbCrLf)?

 

[ericlch16]

Thats works.

I always thought the 3rd argument of Replace function has to be in "". something new to me. thanks all