I have outlook email the bot has to read the email based on the subject and filer the email then in email body i have table data i need to export it excel but the data is in plane text in sometime in html .Need some help to resolve the issue?

Help Something Else
1

Attaching the sample body .

A table providing details of orders including the order number, TMS number, UIT code, order name, recipient, postal code, city, address, country, required delivery date, number of cartons, number of pallets, and weight in kilograms, sent with a greeting and the UIT codes. (Captioned by AI)
A table providing details of orders including the order number, TMS number, UIT code, order name, recipient, postal code, city, address, country, required delivery date, number of cartons, number of pallets, and weight in kilograms, sent with a greeting and the UIT codes. (Captioned by AI)1600×527 18.6 KB

Thanks ,
suresh .T

2

Hi @Thumu_Suresh

Can you try this

Regards,

3

@Thumu_Suresh

try as below it will extract data

for your condition,
after reading the email check email body is html (emailbody.ishtml)
if it html then you can extract the data by following above video.
if is not html then build a flow by extracting all the values.
and make it in form of datatable or directly write in excel

Happy Automation!!