Data export - html emails

Hi,

I need to export the communications from our CRM; since we have Tableau linked to Sage, I grab the data from Tableau. However, the html communications are just coming over as an html block, unless they're very short.

Can someone tell me how I can get those html emails? My IT manager is assisting me, but said he couldn't find a table for them.

I appreciate the help, thank you!

Parents
  • 0

    Hi Robyn

    Not sure what you're looking for, but the body of an email is held in the Communications table in the column comm_email with all the html coding with it. 

    WIth data in it looking something like this 

    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"><html><head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    </head>
    <body dir="auto">
    <div dir="auto">This is a second email</div>
    <div dir="auto"><br>
    </div>
    <div dir="auto"><br>
    </div>
    <div dir="auto"><br>
    </div>
    <div id="composer_signature" dir="auto">
    <div style="font-size:85%;color:#575757" dir="auto">Sent from Samsung Mobile on O2</div>
    </div>
    <div dir="auto"><br>
    </div>
    </body>
    </html>

  • 0 in reply to Matthew Shaw

    Hi Matthew,

    that helps. I wondered if there was another table somewhere.

    In that case, I'd guess because we're exporting our data into excel via Tableau, that field is truncated, especially in email chains, and showing nothing BUT a short block of html coding.  

    What's the best way for me to get the full email out? Obviously not the way I'm doing it. 

    Thank you!

Reply
  • 0 in reply to Matthew Shaw

    Hi Matthew,

    that helps. I wondered if there was another table somewhere.

    In that case, I'd guess because we're exporting our data into excel via Tableau, that field is truncated, especially in email chains, and showing nothing BUT a short block of html coding.  

    What's the best way for me to get the full email out? Obviously not the way I'm doing it. 

    Thank you!

Children