How to read datatable from email

How to read datatable from email and copy datatable out to another email?

image

hi @fairymemay
kindly refer below thread ,


which may aid you…
hpy learning… :grinning:

1 Like

If i have more than 10 email per month.
I think more resources.

Any suggestions?

Hi @fairymemay

Try this :point_down:

  1. Get the mail message using ‘Get Outlook Mail Message’
  2. Save the email(mail message) as .eml using ‘Save Mail Message Activity’
  3. Open the saved .eml file using start process activity. (it will open in outlook)
  4. Ctrl + A (Select) and Ctrl +C (Copy) on the email page and Paste the text into Excel file.
  5. Save the Excel file and get the content into Datatable using Read Range Activity.

If​ i​ use​ extractdatatables From Html.
Can​ use​ or​ not?

@fairymemay

Yes, you can !