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>

Reply
  • 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>

Children