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.
Instructions
-
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.