Extract specific content from mail body

Learn
, , , ,
1

Hi Everyone ,

I would like to extract specific content from my mail body .Can anyone suggest the way ?

We do get employee’s expiry mail and would like to extract Name , Employee ID and Manager Email from the body part and save to an excel file.I need to do it for each expiry mail comes to inbox with different names emp IDs and manager mails…

Accountexpire

Please help me on this as I have an urgent task to be done based on this :slight_smile:

2

@greejo

You can use matches and give as below

image

You can extract Name value from this

Mark as solution if this helps

Thanks

3

Hi @Srini84,

Sorry , I am beginner in Uipath
If you have bit time, would you just display me the code to extract name or email id as an example as I am little confused of :slight_smile:

4

@greejo

Sorry for late reply

Please find attached

BlankProcess19.zip (16.6 KB)

Mark as solution if this helps

Thanks

6

Perfect, Thanks a lot Brother…That worked…:slight_smile:
I have one more doubt here …
I would like to send a mail to a mail ID with the results i got ( Name(0).ToString , EmployeeID(0).Tostring, ManagerEmail(0).ToString)

When i prepare mail subject as “Leaver Notification of” +Name(0).ToString , I am getting the below error

“Send Outlook Mail Message: The specified string is not in the form required for a subject.”

Is it possible for me to add the Regex output in Subject and inbetween Body of the mail ?

My mail should be like the following

To - ManagerEmail(0).ToString
**SUbject- “Leaver Notification of” NAME **
Body- Hi Manager Name, ( The name should be split from email id)
-----------------------------
-------------------Employee Name

7

@greejo

We already store into a Manager / Name Variable, so try to use that variable

Thanks

8

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