Extract Email body (contain table) to Excel

[tra_my_Tran (Annie)]

Hi All,
I want to extract the table from multiple email body to Excel file. I tried but it turned out one email body fit into one cell, i want it fit the whole table. Can anyone help me with this

[sureshj (suresh_hserus)]

@tra_my_Tran

Refer this

Copy email body to Excel file, multiple lines

Hi happy helpers I have come across an issue with reading the email body from an Outlook message and then pasting the value into Excel. I use the get outlook message activity and read the email.body. No problem. The email body contains plain text, maybe 500 lines, sometimes up to 30.000 lines. The problem starts when I use the write cell to write the text in Excel. It pastes the entire text in one cell instead of 500 lines as the example above. How can I get it to write the email.body to 50…

How to write email body table to excel file

Hi, I am trying to extract table content from email body to excel file… can anyone know how to do this

Thanks,
Suresh J

[tra_my_Tran (Annie)]

Hi @sureshj,

I tried those but it didnt work for me, I saw one solution in those link you shared but there is no demo. Could you share one if possible :). Thank u so muchhhhhh.

[Sourav_Anand]

Custom activity to extract tables from email:

https://go.uipath.com/component/extract-tables-from-mail-839f39

This Custom Activity allows to Extract all the tables from a Mail body. The Input to the activity is MailMessage and it returns a dataset with all the tables in the mail