Description

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.

 

Instructions

1. Read the email using the Outlook > Read email activity

2. Save the HTML data of the email as an HTML file using the Create file activity

3. Convert the HTML file to an XLSX file using the Execute Python activity