You can put the body of the email directly into a string, then parse the HTML, or you can use the HTML to text connector to extract the text from the body.
For example, I created an email with this HTML table in the body.
If I put the body of the email directly into a string variable, it looks like this:
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style></head><body dir="ltr"><div class="elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)"><br></div><div lang="EN-US" style="word-wrap:break-word"><div class="x_WordSection1"><table class="x_MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse; border:none"><tbody><tr><td width="208" valign="top" style="width:155.8pt; border:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">Col1</p></td><td width="208" valign="top" style="width:155.85pt; border:solid windowtext 1.0pt; border-left:none; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">Col2</p></td><td width="208" valign="top" style="width:155.85pt; border:solid windowtext 1.0pt; border-left:none; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">Col3</p></td></tr><tr><td width="208" valign="top" style="width:155.8pt; border:solid windowtext 1.0pt; border-top:none; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">1</p></td><td width="208" valign="top" style="width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">2</p></td><td width="208" valign="top" style="width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">3</p></td></tr><tr><td width="208" valign="top" style="width:155.8pt; border:solid windowtext 1.0pt; border-top:none; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">4</p></td><td width="208" valign="top" style="width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">5</p></td><td width="208" valign="top" style="width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt"><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif">6</p></td></tr></tbody></table><p class="x_MsoNormal" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif"> </p><p class="x_MsoNormal elementToProof" style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif"><br></p></div></div></body></html>
If I use the use the HTML to text connector and put that into a string variable, it looks like this:
Col1
Col2
Col3
1
2
3
4
5
6
If you have a known table structure, the second one is probably better.
You can then feed the text to Excel using Run Script and have an Office Script that creates a table out of it.
