How to extract mail body ....?

My requirement is daily receiving in a mail
Mail body
Ex:-

1.5 abc
1.7 bca
1.8 mba
1.6 bba
Total four line in mail body

But some times only 2 or 3 or 1lines in mail body. how to extract the data (ex :-1.5
1.7…please help me…

HI @Vishnu_Reddy1

You can try with Regex expression

Mailbody = “1.5 abc
1.7 bca
1.8 mba
1.6 bba”

OutputResult = System.Text.RegularExpressions.Regex.Matches(Mailbody.ToString,"\d.{1,2}")(CInt(item.ToString)).ToString

Check out the XAMl file

ExtractNumberInmail.xaml (6.3 KB)

image

Regards
Gokul

this is how you can extract the body
do you just want to extract the whole body? or specific data in the body ?@Vishnu_Reddy1

tq Gokul …

I am using get text activity

Line by line extract data … total 4get text activity s using ofter write into excel file …
But today only received Mali body only 3line but i am using 4 get text activity it is thoing error
Please give me solution…

HI @Vishnu_Reddy1

Don’t use Get text activity to get the mail body content

Have a look on the XAML file

ExtractNumberInmail.xaml (11.0 KB)

Regards
Gokul