Skip to main content

Hi everyone,
I am Emmanuel Katto from Duabi, United Arab Emirates (UAE) need to copy only a table from an email body (without including any other content) and paste it directly into Excel as a table. Does anyone know the best way to do this? Any suggestions or tips on how to achieve this efficiently would be really helpful!

 

Regards

Emmanuel Katto

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.

Reply