Outlook Email Trail

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Good day Everybody,

I need some assistance with extracting the first email body from the trail e,g..

This one above would be the first one that came in a trail.

How do I extract only the first message from the trail?

[ashokkarale]

@Anelisa_Bolosha1,

Use this regex to get everything before “From:” which is where second email starts.

^(.*?)(?=From:)

[adi.mehare (Aditya Mehare)]

In Get email you can filter by something like Subject, From, CC or Subject or Body contains, so that you will get array of all mail messages from this trail.
Then sort it by received time and get first message.

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Hi @ashokkarale ,
Thank you for the reply, The email I want is the one from the very bottom of the trail, using your example:

I would want this one in the bottom:

[ashokkarale]

@Anelisa_Bolosha1,

Can you try simple string split

mailbodystring.Split("From:")(mailbodystring.Split("From:").Length-1)

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Hello, thank you for the response, The emails I get are dynamic it’s not always the same senders

[yedukondaluaregala]

@Anelisa_Bolosha1

After getting your email body in as single string, lets say you are emailbody stored in strEmailBody variable.

in assign activity you can below expression to get the last email

strEmailBody.Substring(strEmailBody.LastIndexOf(“From”))

This give you exact email what you are looking for like below image

Happy Automation!!
If you find the solution, mark it as solution!!

[Anelisa_Bolosha1 (Anelisa Bolosha)]

it worked thanks so much