I have some workflow that has been built which automatically triggers an email in certain situations. The email is being triggered and sent properly, however, the contents of the email are not displaying properly.
In building the body of the email, I ahve a string which keeps getting populated with subsequent entried. Each entry is separated by VBCRLF.
If I do a msgbox of the string, I see everything displayed as it should with the new line breaks. However, when the email is sent, all of the text is on one line.
I have tried using VBCR, VBCR+VBLF, chr(10)+chr(13), and have not been able to get the email to recognize the new line.
Is there a reason you're trying to add those together?
"static text " & String_variable1 & VBCRLF & VBCRLF & "more static text: " & string_variable2 & VBCRLF & VBCRLF
here's an extract from my system:
vSubject = "Quality Center Notification - Test '" & Test_Fields.Field("TS_NAME").Value & "' requires rework"
vBody = "<HTML>This test has been reviewed by " & User.FullName & " and rework is required." & vbcrlf & vbcrlf &_
"Please check the Description field of the test to determine what rework is required.</HTML>"
vBody (above) is inserted into a larger string called vText which contains a whole lot of HTML to make the email look identical to a standard QC email -- colours, font, background, border and even the link directly to the test for the user to click on
If your email format is HTML, you should use the BR tag to insert a line break :
<font class="small">Code:</font><hr /><pre>
<html><body>This test has been reviewed by " & User.FullName & " and rework is required.<br />" & _
"Please check the Description field of the test to determine what rework is required.</body></html></pre><hr />