Estract body of email

Help
1

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

2

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
3

Thank you so much @nshrimali,

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

4

Hi @CamiCat

Please find the below solution for your requirement
image

Sequence.xaml (8.3 KB)

1 Like
5

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?

image
image1920Ă—1080 222 KB

Thank you,
Cami

6

maileg.xaml (11.3 KB)

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

Cheers!!!

1 Like
7

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

8

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

9

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

1 Like
10

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

11

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

1 Like
12

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

1 Like