I have created and pasted the html tablet in mail body but now i need it excel
Can you try this:
Can you try below apporach.
1>get outlook mail message - filters are supported here.You can search through other posts on forum.
2>loop through the list to work on required email.
3>for the required email get the item.Headers("HTMLBody”).ToString
and store into a string variable using assign.
4>Now run the custom activity https://go.uipath.com/component/html-to-datatable On this html string to get the data tables which you can write into excel pr can directly iterate through.
Use build datatable activity
To create a template