<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
@Anonymous
so say you have your template here in excel as below:
1. Step no. copy and paste this in an email as below in your normal outlook like below and send it to yourself
2. Open the Received email , Click on Actions-> Other Actions ->View Source, this will render the HTML
3. Now you have to extract the Repeating part in your table, so now you will have to retrieve the repeating data and concatenate to it the repeating part.
So say this is the full html
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="279" style="width:209.0pt;border-collapse:collapse">
<tbody>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in">
<p class="MsoNormal"><span style="color:black">Title :<o:p></o:p></span></p>
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.5pt;border-right:solid white 1.0pt;background:#4472C4;padding:0in 5.4pt 0in 5.4pt;height:.2in">
<p class="MsoNormal"><b><span style="color:white">Name<o:p></o:p></span></b></p>
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.5pt;background:#4472C4;padding:0in 5.4pt 0in 5.4pt;height:.2in">
<p class="MsoNormal"><b><span style="color:white">Positions<o:p></o:p></span></b></p>
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border:none;border-right:solid white 1.0pt;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;background:#D9E1F2;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
So the Repeating TR is as below:
<tr style="height:.2in">
<td width="136" nowrap="" valign="bottom" style="width:102.0pt;border-top:none;border-left:none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
<td width="143" nowrap="" valign="bottom" style="width:107.0pt;border:none;border-bottom:solid white 1.0pt;background:#B4C6E7;padding:0in 5.4pt 0in 5.4pt;height:.2in">
</td>
</tr>
So you will need to loop on your raw data and construct the Repeating part and save it in a variable
4. In your Email you have to Do like Concatenation to the HTML instead of Copy and Paste
So for your HTML you have to concatenate as concat(FirstStaticPart,variables(Repeating Part), EndStaticPart) and pass this composed action to your email.
This is a very complicated approach but it will work ; so it will be easier if you used word templates.
