How can I extract and paste just a table from an email into Excel?

Hi @emmanuelkatto24,

You can follow these steps :

1. Retrieve the Email:

   • Use the Email: Get Messages action to retrieve the email containing the table. Make sure to specify the folder (e.g., Inbox) and any filters (e.g., subject, sender).

2. Extract the Email Body:

   • To extract the body of the email. This will typically be in HTML format.

3. Parse the HTML Content:

   • Use the String package  to parse the HTML content and isolate the table. You might need to use regular expressions or HTML parsing tools to accurately extract the table data.

4. Store the Table Data:

   • Store the extracted table data in a variable. You can use a list or table variable to hold the rows and columns of the table.

5. Write to Excel:

   • Use the Excel Package action to open the target Excel file.
   • Use the Set cell or Write from Table actions to write the extracted table data into Excel. Ensure that you format it as a table if needed.