Send HTML formatted emails

4

You can view how to set up HTML tables here.

What I usually do is set up a table called Templates. In that table you can make a row called HTML Table. Then, in the canvas of that row, put the main table HTML, adding a {1} to the where you’ll enter the row values

<table>
  <tr>
    <th>Company</th>
    <th>Contact</th>
    <th>Country</th>
  </tr>

  {1}

</table>

Then, on the table where you want to pull the data from, make a column called HTML Insert, and configure it like this:

  <tr>
    <td>thisrow.Company</td>
    <td>thisrow.Contact</td>
    <td>thisrow.Country</td>
  </tr>
  <tr>

Then, wherever you want the table to appear, you write a formula like this:

format(@HTML Table.template, [formula filter for what values you want].HTML Insert.Join(“”) )

Depending on the email template, you’ll have to mess around with where you enter the .tohtml(). This is a huge pain though and I would love an easier solution if anyone has one.

2 Likes