I need to extract data from table from mail body. I used extract tables from email activity. but it is not extracting properly. Please help me to solve this.
Could you please refer the below custom activity from Uipath market place. It might help your requirement. Thanks.
@kirankumar.mahanthi1 Already i tried that custom activity . All the data are stored into “A” column only. Data are not extracted properly.
There are multiple approaches to read a DATATABLE from a mail body
Like data scrapping or converting the HTML mail body to DATATABLE
Have a view on this thread for multiple approaches
This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it
If you using this component
Then the steps involved will be like
In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the email and convert it into a string.
I think we don’t have much options for this requirement. There is one approach like
Get the mail body from the mail items.
Convert that text to a html file.
Open that html table in browser.
Using extract table or extract structure activity to extract the data into data table.
Use write range to write data back to excel.
Sharing my thought with the above high level steps.
And also please refrer the below link it is having some different approach to achieve the requirement you mentioned.
I am not able to do step 3. because After completion of step 2 the data is not in table format.
Are you able to save as the text file to html. You can use open browser activity or start process activity to open in browser.
I am able to save the text to html. But now the data not in table format.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.