28-12-20 10:03 AM
Hi,
I am using the MS outlook VBO to send out status email . The question that I have is with regards to the email formatting. For better understanding let me give you an example .
Example : I want to send out an email with the following email body
Desired state
Process start time: 08:00:00 pm
Process End time : 08:30:00 pm
BOT has successfully completed the task. Please find attached the updated deliverables
Current state
In the current scenario I am not able to get the sentences in the email body in separate lines. I am getting the following output currently
Process start time: 08:00:00 pm Process End time : 08:30:00 pm BOT has successfully completed the task. Please find attached the updated deliverables
It would be great if someone can let me know how to format the email body
Regards,
Shobhit Malaviya
Answered! Go to Answer.
29-12-20 02:50 PM
If HTML formatted, use <br>. Example: "Process Start time: 08:00:00 pm<br>Process End time: 08:30:00 pm"
If plain-text, you can use NewLine(). Chr(13) also technically works, but NewLine() is obviously better to use. Example: "Process Start time: 08:00:00 pm" & NewLine() & "Process End time: 08:30:00 pm"
28-12-20 05:19 PM
You can use NewLine() text function
29-12-20 02:50 PM
If HTML formatted, use <br>. Example: "Process Start time: 08:00:00 pm<br>Process End time: 08:30:00 pm"
If plain-text, you can use NewLine(). Chr(13) also technically works, but NewLine() is obviously better to use. Example: "Process Start time: 08:00:00 pm" & NewLine() & "Process End time: 08:30:00 pm"