How store the email body into excel using email received trigger?

Hi team,

i am using email recevied trigger when ever i received email from perticular mail and also i want to extract the email body of that perticular mail and store it in excel. how to do this?

Use " Get Outlook Mail Messages" (link Activities - Get Outlook Mail Messages)

Make an variabel for Messages

Use a “For each” (not for each row)

In For each mail - you can get info with currentItem.subject and so on…

Hope it works.

my process is trigger when ever i recevied the email from perticular email address that i did with email recevied trigger and after that i want read the email body and store that body text into excel file. this is my requirement

@Naveen_Kanike,

Are you using Integration Service for trigger?

Thanks,
Ashok :slight_smile:

yes ashok iam using integration service trigger from orchestrator

Hi @Naveen_Kanike

Check the below thread,It might helps you

@Naveen_Kanike,

Ok so you will have to get the email from UiPathEventObject.

Refer this thread.

Thanks,
Ashok :slight_smile:

In my case i wanted to do it in outlookmail how to do it my requirement is it has as to trigger when ever a mail is received from perticular mail address and then from that email perticular email body i need to store it in excel.

please check the screenshots for my flow ashok



@Naveen_Kanike,

I feel you should be using Orchestrator trigger and configure it there to filter received from.

image

Also remove this Email Received trigger form Code and directly pass UiPathEventObjectId to Get Email by ID.

Thanks,
Ashok :slight_smile: