How to automatically break lines in email body

[sunny.zhang]

I am draft email, and there is a content that was read from Excel. After insert to the email, All text squeezed together without line breaks. How to solve this problem

It should like this:

But when it insert to email body, All bullet in one line, How to start Line wrap and word wrap from the second bullet like above

I use Assign like this：

[Srini84 (Srinivas Kadamati)]

@sunny.zhang

Use HTML code to write as per your requirement

HTML Lists

Hope this may help you

Thanks,
Srini

[lrtetala (Lakshman Reddy)]

Hi @sunny.zhang

Try like this

Var1.Replace(“.”,Environment.NewLine+“•”)

Output:

I hope it helps!!

[supriya117 (Supriya Allada)]

Hi @sunny.zhang

The sample test Ex:

RPA drives rapid. significant improvement. to business metrics across industries. and around the world.

In assign activity:

str_text = "RPA drives rapid."+vbLf+"significant improvement."+vbLf+"to business metrics across industries."+vbLf+"and around the world."

print: str_text
output:

RPA drives rapid.
significant improvement.
to business metrics across industries.
and around the world.

Hope it helps.

[supriya117 (Supriya Allada)]

@sunny.zhang

Give the date in excel like this:

RPA drives rapid."+vbLf+“significant improvement.”+vbLf+“to business metrics across industries.”+vbLf+"and around the world.

[lrtetala (Lakshman Reddy)]

@sunny.zhang

If you find the solution for your question please mark as solution to close the loop.