There are instances when we are interested in extracting a table from an email and saving it as an Excel file. Currently, the Outlook > Read emails activity alone returns a key-value pair that contains the HTML data of the read email.
We can use this HTML data to save the table as an Excel file. In this article, we show you how to do that.
Read the email using the Outlook > Read email activity
Save the HTML data of the email as an HTML file using the Create file activity
Convert the HTML file to an XLSX file using the Execute Python activity
Want more details about the converting process? Then, check How to convert an HTML file to an XLSX file using the 'Execute Python' activity.