Pages

Thursday, February 23, 2012

Convert Email Body to Plain Text

If you wish to create a report on the email body within CRM, the problem is that if you just retrieve the data from the email body it will appear with all the html tags which is not too pretty to say the least.


But luckily there's an easy way to handle this. To do so, follow these steps:


  • Highlight the report expression containing the html text and select "Placeholder Properties..."


  •   Select the Markup Type option of "HTML - Interpret HTML tags as styles"


And that's pretty much it. Now the html text renders as, well... html text (not technically "plain text" as indicated by the title of this post).




1 comment:

  1. Hi Nahi,

    When i tried this against the dbo.Email.Description field it did not work. I am getting a "Invalid URI: The hostname could not be parsed" error in BIDS.

    ReplyDelete