Extract data out of body of a mail

Help
22

@yannip after running in circles a few weeks either on this problem, I solved installing outlook locally instead of using the web version. With that, the dedicated activity works very nicely.

23

Thanks for sharing Stefano.
Unfortunately for me it is not working on the standalone version of outlook or the web version.
Glad you have a working solution - i know the pain of this issue :slight_smile:

1 Like
24

Well, if you use the Get Outlook Mail activity, it works fine normally. Be sure the MailFolder input is equal to the name you have in the outlook application. And check also the trust center config in Outlook options.

1 Like
25

One of the issues is in the trust center. Company policies do not allow us to change it. And it is an international company so not easy to change it. In the end they did not want to change it.

1 Like
26

Hello,
Can you pls elaborate on (From row In DataTableMail.Select() Select String.Join(“,”,row.ItemArray)).ToList()
I am trying to follow this and need to convert ‘ExtractDataTable’ (type=datatable) to a list type variable.

1 Like
27

Well this code will convert each row of your dt into a list item and its using LinQ
It takes each row nd then for each item it will join it together and make it a comma separated value and the result converted to a list item.

ex DT like :
1|Nadim|29|UiPath
2|Ash|28|UiPath

becomes List[{“1”, “Nadim” , “29”, “UiPath”},{“2”, “Ash”, “28”, “UiPath”}]

1 Like
28

Thank you, but what I am confused about is the syntax.
I guess I need to create a variable of type (list), lets say ‘LIST’
and assign
LIST= (From row In DataTableMail.Select() Select String.Join(“,”,row.ItemArray)).ToList()
where DataTableMail is the scraped datattable.
Right?

2 Likes
29

yes :slight_smile:

2 Likes
30

:slight_smile: :slight_smile: Thank you so much!!!

1 Like
31

Main.xaml (12.7 KB)

Hi, I tried this, but strangely, sometimes its working and giving me data in output pane and sometimes not. I am not able to get it. (Internet explorer blocking content???)

attaching the mht file and the error message I am getting.

error
error605×620 11.2 KB
mht%20file
mht%20file920×620 14.1 KB

1 Like
32

see if this helps
ProcessEmailBody.xaml (14.0 KB)

2 Likes
33

hi nadim
when m trying to search specific mail based on subject in assign activity
its showing some error

image
image749×142 24.3 KB

how can i get specific mail?
please suggest

thanks

1 Like
34

Yes, you get it by filter based on the subject.
However the issue you have here is due to variable type.

This assign will give a result = whether the current mail is having the subject that you want.
This should be a Boolean (true/false) based on which you can proceed of move to next mail.

Your left hand variable is related to the subject it self im guessing.

Let me know you have understood what you need to do.

3 Likes
35

got resolved.
thanks

1 Like
36

Hi,

I tried same in Lotus Notes mail, at step c, while trying to scrape data, scrape results coming as blank. Please suggest.

37

If you have excel license look at this post:

@nadim.warsi please let me know your review =)

38

Hi Can you please Explain step 4.
i tried this step but i got an error object reference not set to an instance of object

39
User ID rupadhye
Client ID 100
Connection Name MGS
Action Unlock

Want to extract such data from mail body

40

@Sneha_Ambulkar, extract data from body, then Build data table , Add data row by row

41

Main.xaml (19.4 KB)

i attach my work flow over here please check