Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Exporting Email Activities without HTML code

Jump to Best Answer
  • 1.  Exporting Email Activities without HTML code

    SILVER CONTRIBUTOR
    Posted May 10, 2021 04:16 PM
    I'm trying to export many thousands of email activities, and while I can see the email body on the screen in my Advanced Find results, when I export to Excel, the body copy is translated to HTML code.  The code does contain the body of the email way deep inside it, but everything I try to do in Excel to remove the tag just removes the whole cell content.  I'm even open to purchasing a tool that can accomplish this if there is one out there.  I feel like I've researched a ton and I still can't find any sort of solution to this.  Anyone have any ideas?

    ------------------------------
    Jennifer (Norton) Coville
    Business Development Systems Analyst
    Harden
    Jacksonville FL
    ------------------------------


  • 2.  RE: Exporting Email Activities without HTML code
    Best Answer

    TOP CONTRIBUTOR
    Posted May 11, 2021 02:41 AM
    I did something like this before using PBI.
    Can't remember how but this looks like a reasonable approach.
    Once you have converted it in PBI, you should be able to export to Excel if you need to, however, if you use the PBI Service, you could connect directly to the data source, and have it update daily.
    Convert Data From HTML To Plain Text In Power BI (c-sharpcorner.com)

    ------------------------------
    Donal McCarthy
    Digital Marketing Administrator
    BrightWork
    ------------------------------



  • 3.  RE: Exporting Email Activities without HTML code

    SILVER CONTRIBUTOR
    Posted May 12, 2021 08:56 AM
    Donal, you are a LIFE SAVER!  Thank you!  I ran into a small issue with null values, but once I removed blanks from that column, everything worked perfectly!  Thanks a million!!

    ------------------------------
    Jennifer (Norton) Coville
    Business Development Systems Analyst
    Harden
    Jacksonville FL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role