How to write email body table to excel file

You can try this:

  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 and Ctrl +C (Copy) on the email page and Paste the text into excel file.
  5. Save the excel and get the content into Datatable using Read Range Activity.
6 Likes