Unable to match outlook body word with Excel list keywords c#

Help Studio
, , ,
1

Hi Team,
I have list of keyword in excel sheet.
i want match and find the same keyword in outlook email body.
when i assign a variable to the excel list to store, and find if it contains in email body; but there is 0 result with condition for the activity(if). am i missed something here? if i hardcode the condition<email.Body.ToString().Contains(“keyword”)>, it is work fine.

image
image622×772 17.1 KB

image
image617×721 13.7 KB

2

Hi @balaraj.pubalan

Check that the variable exists correct data or not with a message box or log message

3

Yes. i able to list it with log message and the outcome is good.
image

4

Hi @balaraj.pubalan ,
I think you need use 2 loop to compare all elements in excel with all mail body
I have created a process same
you can check

image
image646×771 21 KB

image
image760×726 18.6 KB

image
image603×752 18.5 KB

Regards,
LNV

1 Like
5

Hi @balaraj.pubalan

Could you try the below condition in If.

email.body.tolower.toString.Contains(strExcel .toLower.toString)

Hope it helps!!

1 Like
6

not working. no result or output for the condition.

7

May I know what is the variable name of Output datatable.
After there is an assign activity what you have initialized the value for strExcel. @balaraj.pubalan

8

Hi @Nguyen_Van_Luong1 Is there you make the email body written out to excel first to match with another checkIN excel?if i understand this correctly?

9

it is odtExcel
image
odtExcel.ToLower() Assign to strExcel.

10

Hi @balaraj.pubalan
yes, I think this will correct.
I tried with for each mail.body.contain string in excel,
but it have result not correct, you can try my solution
Regards,
LNV

1 Like
11

In that case I have given the condition which is correct one.
Once try the below one.

email.body.toLower.toString.contains(strExcel.toString)
12

same…i cant get the output with this condition.

image
image586×751 15.7 KB

output:
image

13

If i hard code it, it is working…

image
image1205×646 28.2 KB

14

Hi @Nguyen_Van_Luong1 Actually this is comparassion in excel but i want to do acticity in outlook if the word match, i want to do some activty on that email.

15

Hi,
it’s just a matter of comparing email and excel
it’s a simple matter of UiPath
you can try my way
Or can you share your sample file and sample email
Regards,
LNV

16

keyword.xlsx (15.6 KB)
emailbody.xaml (14.6 KB)

Attached is list in excel to detect and activity in outlook…

17

Hi ,
You need compare keyword with body mail.
That’s right?
after that, What do you need?
Paste Status in keyword?
image

image
image943×389 29.1 KB

keyword.xlsx (55.3 KB)
compare_mail_excel.xaml (21.8 KB)
You can try

1 Like
18

not paste the status again instead i want that email get deleted.

19

yes. use delete outlook message
compare_mail_excel.xaml (17.8 KB)
Try this solution

20

sorry…i cannot open this file in my studio.may i have the screen shots with variable? else i need to go trough the code in xml file on by one…Thanks :slight_smile: