Estract body of email

Hello friends,

I need to extract the different data from this email, beetween the words VDIVS and 1,0718.
How can I do that?
Can you please send me an example of workflow?

Subject: FW: Ordine vendita divisa cdg 1158813

VDIVS
1158813
50794547
USD
4.278,13
05-apr-17
07-apr-17
1,0718

have a nice day

Thank you,
Cami

You will get the list of mail message using the activity you are using to get the mail messages, and then when you are iterating the list, you will get an mailmessage object. In this you can use the Body() method, it will give the output in a string format. Now using the substring method, you can get the required data.

1 Like

Thank you so much @nshrimali,

can you provide me an example of workflow to do this?
Thank you so much,
cami

Hi @CamiCat

Please find the below solution for your requirement

Sequence.xaml (8.3 KB)

1 Like

Thank you so much @kommijeevan,
i try and let you know :slight_smile:
How to set the Top parameter in the “Get outlook messages” so that the Robot fetches all possible messages?


Thank you,
Cami

maileg.xaml (11.3 KB)

You can go through the sample workflow. I hope this helps.

Cheers!!!

1 Like

Thank you so much @nshrimali ,
i try and let you know :slight_smile:
How to set the Top parameter in the “Get outlook messages” so that the Robot fetches all possible messages?

thank you,
cami

Thank you so much @nshrimali.
Can you please send me also the workflow that , after extracting the portion of text needed, extracts all the data (the numbers and letters)?
Thank you so much,
Cami

The no of messages of retrieved starting from the top of list

1 Like

Thank you @kommijeevan.
But if I want to extract them all?
Thank you,
Cami

Top property enter this one Int32.MaxValue that will read all messages.

1 Like

If you got solution, please also make sure to mark my answer as the solution.

1 Like