Convert-Data-Extension-Rows-To-Email-In-Tabular-Format.HTML

 Hi Admin,<br/>
 
<b> Below is the status of Automation:</b><br/>
 
 <table border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td align="left">

        <table border="1px" cellpadding="0" cellspacing="0">

          %%[
            var @rows, @row, @rowCount, @numRowsToReturn, @lookupValue, @i, 
            set @lookupValue = "true"
            set @numRowsToReturn = 0 
            set @rows = LookupOrderedRows("Automation_Status",@numRowsToReturn,"Automation_Name, Customer_Key, Status, ScheduledTime","Flag", @lookupValue)
            set @rowCount = rowcount(@rows)

            if @rowCount > 0 then 

                for @i = 1 to @rowCount do

                  var @DEColumn1, @DEColumn2, @DEColumn3, @DEColumn4
                  set @row = row(@rows,@i)
                  set @DEColumn1 = field(@row,"Automation_Name")
                  set @DEColumn2 = field(@row,"Customer_Key")
                  set @DEColumn3 = field(@row,"Status")
                  set @DEColumn4 = field(@row,"ScheduledTime")

                  if @i == 1 then

                  ]%%
                      <tr>
                        <td>Automation Name</td>
                        <td>Customer Key</td>
                        <td>Status</td>
                        <td>Scheduled Time</td>
                      </tr>
                  %%[

                  else 

                  ]%%
                      <tr>
                        <td>%%=Uppercase(@DEColumn1)=%%</td>
                        <td>%%=v(@DEColumn2)=%%</td>
                        <td>%%=v(@DEColumn3)=%%</td>
                        <td>%%=v(@DEColumn4)=%%</td>
                      </tr>
                  %%[ 
                  endif

                next @i


          endif 

        ]%%

        </table>
      </td>
    </tr>
  </table>