Extract data from Outlook email

Help Studio
#1

Hi,

I have to create a Workflow where I filter emails by subject and the have to extract data from the body. An example of email:

Dear,
the received document NALS_25689632594_20210324_LAR_R.XML is completely correct.

This is an automatic message. Do not reply.

What I have to extract in this example is “NALS”, the date “20210324” and “LAR_R” from the body. The variables are always different.

#2

@markosc

First you can use For Each after the Get Mail Message activity, as below

image
image1685×555 40.2 KB

After that Use Regex expression as below

image
image1636×370 22.3 KB

Later you can use split method to get your required string

Hope this may help you

Thanks

1 Like
#3

@markosc - As an alternate, you can try this regex group pattern…

image
image941×668 31 KB

Nals = Regexvar(0).groups(1).tostring
20210324 = Regexvar(0).groups(2).tostring
LAR_R = Regexvar(0).groups(3).tostring

#4

@ksrinu070184 @prasath17
Does it work with Outlook?

#5

@markosc

Yes, It will work

Use Outlook Mail Message activity, but outlook should be configured locally

Item.Body will extract the body as string then you can apply the Regex

Thanks

1 Like
#6

Yes…It does @markosc - pass your mail body as an input to the regex…

image
image726×278 12 KB

Write Line:
image

StrOuput is of variable type : MatchCollection…

Here: Replace the StrInput with your body content…

1 Like
#8

Hi can you please tell me what do I need to write when I need to print out text between , and . (from the above example)?

#9

@markosc - you mean this…

the received document NALS_25689632594_20210324_LAR_R

If so, you have Dear always in before the comma ?

#10

the email always starts with “Dear,”
and I have to print out “the received document NALS_25689632594_20210324_LAR_R.XML is completely correct” so the text between comma and full-stop.

#11

@markosc - Please try this…

StrPrint = Regex.Match(StrInput,"(?<=Dear,\r\n).*").value

StrPrint is of variable type String…

May I know, how/why the initial requirement got changed?

1 Like
#12

It did not changed I just have an Excel file to fill with first mentioned data and that I have a cell where I have to copy the message. Thank you for your help!

1 Like
#13

Hi, when I test it in a workflow with emails, it gives me nothing (empty write line)

#14

@markosc - could you please share the complete text and screen of the worflow …i.e how you implemented the Regex…

#15

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