Process Emails

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 :slight_smile:

Hi @CamiCat,

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

Thanks,

1 Like

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

Hi @CamiCat,

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

Thanks,

3 Likes

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

Hello @Gouda_6,

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


Thank you so much,
Cami

Hi @CamiCat,

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

Thanks,

1 Like

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

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

Thank you so much,
Cami :slight_smile:

Hi @CamiCat,

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

1 Like

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

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.

image

2 Likes

Thank you so much @Gouda_6.
Can you please share with the xaml modified?
Thank you so much,
Cami :slight_smile:

Hi @CamiCat,

Please find the attached Xaml file
Main (6).xaml (8.6 KB)

1 Like

Thank you so much @Gouda_6.
Is it possible to separate the data extracted in different variables?
Thank you so much,
Cami :slight_smile:

HI @CamiCat

Main (6).xaml (11.4 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.