Read body of email and write to csv

[sushmithaelluru (sushmitha)]

HI All,

I need to read the email body which contains ,

Can you please help me in converting to CSV file.

Thanks.

[kalyanDev]

using mail activities read the emails then output from the email activity store it and then that variable.body will return the email body then first print it then format the data as required for to write into csv

[sushmithaelluru (sushmitha)]

Hey hi @kalyanDev, am using the below logic.

Process.xaml (16.8 KB)

Getting the output as follows:

[jitendra_123 (Jitendra Ughade)]

Hi @sushmithaelluru
-Read the emails using Get Imap Mail messages.
-Iterate It In for each Lopp
-You Can use Filter if wants the mails from Particular UserId Or User.
-Then Get the Body body using item.body.
-Then Use Write CSV Activity to write that data in Csv File.

[sushmithaelluru (sushmitha)]

Hey @jitendra_123, am using the logic you mentioned in the xaml I uploaded. The body contains the image I attached above too.

Getting the output as,

[kalyanDev]

okay i’ll check once…

[jitendra_123 (Jitendra Ughade)]

@sushmithaelluru
Is there any HTML table contains in Your mail body?

[sushmithaelluru (sushmitha)]

Ok @kalyanDev, thanks.

[sushmithaelluru (sushmitha)]

Yes @jitendra_123, it contains.