Process Emails

CamiCat · April 17, 2019, 6:54am

Hello friends,

(@rkelchuri, @Rammohan91, @balupad14, @vvaidya, @ClaytonM, @Florent_Salendres, @Manjuts90, @Maheshk, @MAHESH1)
I have a process in which I should perform the following actions:
1)open Outlook;
2)get all unread emails; (the Parameter Top must be set in such a way that all unread emails are rpcessed, not only the first 30)
3)read the body of the email and extract all data

(for example the data from VDIVS to 1,0718 in the following body:

From: Foo**
Sent: mercoledì 5 aprile 2017 09:59
To: Estero <estero@.it>
Cc: Forex <Foreign@*.it>
Subject: FW: Ordine vendita divisa cdg 1158813

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

Banca )
4) store the data in variables.
Can you please help me in defining a sample workflow?
It’s very urgent for the development of a Bot at the client.
Thank you so much,
Cami

Gouda_6 · April 16, 2019, 7:27pm

Hi @CamiCat,

Is this emial boday format is same it starts with VDIVS and ends with numeric value?

Thanks,

CamiCat · April 16, 2019, 7:32pm

Hello @Gouda_6 ,

the mail is forwarded so it contains also the part with: From: Foo**
Sent: mercoledì 5 aprile 2017 09:59
To: Estero <estero@ .it >
Cc: Forex <Foreign@*.it>
Subject: FW: Ordine vendita divisa cdg 1158813

The part of the data that I want to store starts with one of these : ADIVS, ADIVT , VDIVS or VDIVT and ends with numeric value.
Thank you so si much
Cami

Gouda_6 · April 16, 2019, 7:59pm

Hi @CamiCat,

Please find the attached xaml file.
Main.xaml (7.3 KB)

Thanks,

CamiCat · April 17, 2019, 6:37am

Thank you so much @Gouda_6.
I’ll try and let you know as soon as possible.
Cami

CamiCat · April 17, 2019, 6:53am

Hello @Gouda_6,

what does the parameter Top=-1 in “get Outlook mail maessages” mean?

Thank you so much,
Cami

Gouda_6 · April 17, 2019, 6:55am

Hi @CamiCat,

it reads all the mails from outlook u an change it if you want read particular count of mails.

Thanks,

CamiCat · April 17, 2019, 6:56am

thank you .

I deleted the mark from OnlyUnreadMessages and left Top=-1 but doesn’t work
It gives this error:
Get Outlook Mail Messages: The operation has timed out.
Can you please help me?
Thank you,
Cami

CamiCat · April 17, 2019, 6:59am

Hello @gouda,
when I have the data in Write Line action, can I separate them in different variables?

Thank you so much,
Cami

Gouda_6 · April 17, 2019, 7:00am

Hi @CamiCat,

Can you mark OnlyUnreadMessages and try runnning
and make sure mails are unread in outlook, which meets your condition.
Thanks,

CamiCat · April 17, 2019, 7:01am

Thank you @Gouda_6.
But if it is alredy read the email that I want to get?
Thank you so so much for your precious and kind help.
Cami :)

Gouda_6 · April 17, 2019, 7:28am

Hi @CamiCat,

“But if it is read the email that I want to get?”
It should still work give some count in top property and make sure you move the processed mail to some other folder so that bot won’t pick same mails again and again for next run.
For moving the mail,
Make sure you have all ready created folder to move.