Issue with exporting email body to excel

Help Studio
6

The UiPath Docs for Debugging are an excellent resource for a quick start. (Also Academy training is quite detailed and thorough)
Check this page out to see how you can use breakpoints to effectively “pause” the running workflow and see a snapshot of that instance, value of each variable before the paused activity executes.

(Traverse the menu tree on the left to read about other panels in the Debugging section)

Also, the mail body looks right. This is what you can expect when you read mail.Body as String because it invariably contains HTML.
There are a few good topics on forums about how to make sense of the HTML string you receive from the Body property.

  1. Getting HTML Mail Body - #7 by Bharat_Kumar
  2. Get outlook mail messages html body - #2 by nimin

See if one of the solutions discussed here work for you. Essentially what you need to do is get rid of all the HTML tags sitting between <> and </> And a few other non-textual residue after clean up.
The topics above have some insights into doing that.
Please let us know on your progress and any issues you encounter :slight_smile:

Cheers.