Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Case report - email body is exported as HTML

(0) ShareShare
ReportReport
Posted on by 10

Hello fellow Dynamics people,

We have the requirement to export all case details to a Word/PDF. It is like a report of one single case, including all the details, notes, activities and also the email conversations.

Everything works just fine, it is easy to set up with the XML explorer in Word. But the problem is that the email-description field values are stored as HTML. Which results in an HTML export on the requested report. This makes it unreadable for humans, it also messes up the complete formatting of tables and page ranges.

This is how it looks. The first picture shows the first page of the report, which works fine, the second displays a table for email activities:

D365_5F00_Afb1.png

Picture 2:

D365_5F00_Afb2.png

Is there a way to let the system parse the HTML into plain text or something else that is readable? I know you can you can convert the email body to plain text with the help of workflows, but that gives not the desired results and it is not an efficient solution (then we have to store every email body twice).

Any help, ideas or tips are welcome!

  • KvRoploo Profile Picture
    KvRoploo 10 on at
    RE: Case report - email body is exported as HTML

    The solution provided is meant for On premise environments.

    We have an Online instance:

    Microsoft Dynamics 365

    2020 release wave 1 enabled

    Serverversie: 9.1.0000.13228

    Clientversie: 1.3.425-2001.3

  • KvRoploo Profile Picture
    KvRoploo 10 on at
    RE: Case report - email body is exported as HTML

    Hello Andrew,

    I am going to try this, thank you for your suggestion.

    Regards

  • KvRoploo Profile Picture
    KvRoploo 10 on at
    RE: Case report - email body is exported as HTML

    Hello Asif,

    Thank you for your answer, but this is exactly what I say about using a custom solution and workflow to decode the HTML. It simply does not give the desired results and it also demands that we have to store every email in the system twice; one in HTML and one in plain text (decoded). That gives to much overhead. Non the less thank you for your support :)

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Case report - email body is exported as HTML

    Hello,

    You can use cell formatting feature of reporting services - docs.microsoft.com/.../format-text-in-a-text-box-report-builder-and-ssrs

  • Asif365 Profile Picture
    Asif365 1,431 on at
    RE: Case report - email body is exported as HTML

    Hi,

    Please have a look at the post, it could be helpful.

    meganvwalker.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans