If you are getting it in a html formatted mail, then you can do the following steps to extract data without issues.
- Open the Email and save that as .mhtml format.
- Then open that .mhtml file using any browser which is compatible for your process.
- Then do web data scraping of that table from the web page, so now you will get the data as a datatable without parsing the html body.
- Now you can feed the data into the webpage.
You also can try with html body parsing process, but you need to handle null values with this step, sometime if the table cell does not contains values then you have to check and make that.
If you have any questions please let me know.