Hello,
I'm using the code below which is working fine but I would like to add a header to separate the two collections but so far I have only been able to add this for the first collection. When I add a header for the second it's populated in the last row of the last column.
I know this is something pretty straight forward and have tried different combination but am now throwing in the towel. Any help would be much appreciated.
Office365Outlook.SendEmailV2("email","Stock",
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
"<tr style='background-color:#efefef'>
<th>Description</th>
<th>Device</th>
<th>Current Level</th>
</tr>" &
Concat(colTonerStock,
"<tr>
<td>" & Title & " </td>
<td>" & Device & " </td>
<td>" & CurrentLevel & " </td>
</tr>")&
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
"<tr style='background-color:#efefef'>
<th>Description</th>
<th>Device</th>
<th>Current Level</th>
</tr>" &
Concat(colWasteStock,
"<tr>
<td>" & Title & " </td>
<td>" & Device & " </td>
<td>" & CurrentLevel & " </td>
</tr>"))
