Hi I am trying to create a feature where an end user can get a filtered gallery emailed to them with a click of a button
I have spent 6 hours researching this and have come up with code below , but it is not creating a table , all I see is all the html code in the email subject
and just the word true in body
ClearCollect(Acc, master_search.AllItems);
Office365.SendEmailV2(User().Email,
/*"CRM Accounts",*/
/*body*/
"<h3>CRM Filtered Accounts</h3>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'>
<th>Code</th><th>Account</th><th>Country</th><th>Region</th><th>Rep</th><th>Rep2</th><th>Status</th>
</tr>
<tr>" & Concat(
Acc,
"<td>" & Title & " </td>
<td>" & field_1 & " </td>
<td>" & field_2 & " </td>
<td>" & field_3 & " </td>
<td>" & field_4 & " </td>
<td>" & field_5 & " </td>
<td>" & field_6 & " </td>
",
"
</tr><tr>"
) & "</table>",
true
)
