I am trying to extract specific information from the body of an Outlook e-mail.
For example, I need to get all words that are between quotation marks (“word”) that are present in the body.
I am using the “Get outlook mail messages” and I can already paste the whole body information into an excel file, for example. However, I need to work with some parts of the info instead of all of it.
Thanks in advance,
Even I am searching for this will let you know Kazuo san if I find any solution.
You can use the
There is a sample in UiPath → Library called
Extract Text Between Labels. Labels.xaml (7.1 KB)
Probably you’ll need to adapt it to retrieve all matches (not only the first) plus adapt the regex expression as per this article:
Thanks Badita for your help will try this
Hi Adarsh i am also trying this but i am not getting any solution ,Did you got the solution?? i am not able to get data into CSV or excel from email body ,my problem is i have thousands of email from a particular email address and i want to retrieve some part of it into excel or CSV ,
I have email body like
i want my name and age field into CSV
hello, I am also trying to extract values from an email. Badita’s solution does work … but … I first had to remove carriage returns / line breaks from my txt. Once I converted the text into a string without carriage returns then Badita’s solution worked fine.
this line removes the carriage returns.
strVariable = mail.Body.Replace(vbCrLf, “”)
… I don’t really understand vbLF (linefeed) and vbCR (carriage return) … so you you may have to experiment a bit with mail.Body.Replace(vbCr, “”).Replace(vbLf, “”) … good luck
Hello Sandeep, did you manage to find a solution for this? I am looking at the same thing. Thank you!
Hello, anyone could give a solution for this?