Home > database >  Email body contents get jumbled up if below html emailed
Email body contents get jumbled up if below html emailed

Time:04-28

I am processing raw data with powershell then populating hash tables. Then i am generating report out of hash table. I am generating HTML file as a report. This HTML file looks well if i use any browser but if i send in email using option as -BodyasHtml $HTML content gets jumbled up .Below code has nested tables. what can i do so even email looks what i see in browsers ?? Below code was in email if i send email as -Body $HTML .

   <html>                                                       
    <head>
    <style type="text/css">
    caption {  font-size: 1.5em;  font-weight: 400;  margin: 0;  padding: 6px 0 8px;  text-align: left;}
    .table1 {border: 4px ;background:#cff;align:"center";cellpadding="0"; cellspacing="0";}
    .table2 {border: 3px ; background:#E0F8AE;align:"left" ;cellpadding="20";cellspacing="0";}
    .table3 {border: 4px ; background:#FFCAB1 ;align:"right";cellpadding="20" ;cellspacing="0";}
    
    tr, td { font-size:16px; }
    .content {width: 640px !important;}
    td.fw {padding:25px 25px 25px 25px}
    .th1 { border: solid 2px #ffffff; padding: 5px; background:#A6cb5b}
    .th4 { border: solid 2px #ffffff; padding: 5px; background:#6DC7C7}
    .th2 { border: solid 2px #ffffff; padding: 5px; background:#c7896b}
    .th3 { border: solid 2px #ffffff; padding: 5px; background:#ECA583}
    .td1 { border: solid 2px #ffffff; padding: 5px; }
    .td2 { text-align: center; font-size: 1.5em; face:Tahoma; color:#D35400 ;}
    .td3 { text-align: center; font-size: .5em; padding: 5px;color:#0000FF }
    .td4 { text-align: center; font-size: .5em; padding: 5px;color:#D35400 }
    
    </style>
    <meta charset="utf-8">
    <title> NestedTables </title>
    </head>
    <body >                                                       
    <table width="100%" style="font-size: 15px;border-collapse: collapse;">
        <tr>
        <td >Daily Backup Summary Reports From ALL cluster</td>
        </tr>
        <tr>
        <td  >Below report also available on NAS share : \\hcohesity05\cohesity_reports </td></tr>
        <tr>
        <td  >Contact Anil Maurya for any question/comments on this report. </td></tr>
        </tr>
    </table>
    <table  style="margin-left:auto; margin-right:auto;width:"100%"; border: "4px solid green"; border-collapse: collapse;" >                     
    <tr> <th  colspan="2" > Hcohesity01 Cluster Daily stats </th> </tr>
    <tr>                                                          <! start of first row in main table  >
    <td >                                                         <! start of first cell in first row in main table  >
    <table >                                                       <! start of top left table  >
    <tr> <th > Cluster Parameter</th> <th > Value </th> </tr>
    
    <tr> <td > Number of Backup Failure </td> <td > 0 </td> </tr>
    
    <tr> <td > Total backup Jobs </td> <td > 597 </td> </tr>
    
    <tr> <td > Total Front End backup size in TB </td> <td > 15553.39 </td> </tr>
    
    <tr> <td > Over All backup success </td>
    
                                      <td ><span style="color: #0000FF"> 100.00 % </td> </tr>
                                      
    <tr> <td > Cluster actual physical Size in TB</td> <td > 384.81 </td> </tr>
    
    <tr> <td > Physical space consumed in TB </td> <td > 179.07 </td> </tr>
    
    <tr> <td > Over All cluster Usage % </td> <td > 46.53 %</td> </tr>
    
                            <tr> <td > IBMCOS Usage in TB </td>
                            <td > 141 </td> </tr>
                            <tr> <td > IBMCOS Usage % </td>
                            <td > 40.75 % </td> </tr>
                            </table>                                                      
                            </td>                                                         
                            <td>
               <table >
                                    <tr> <th  colspan="2"> Servers with Change Rate more than 10% </th> </tr>                                                       <! start of right top table >
                                    <tr> <th > Servers Name </th>
                                    <th > change Rate</th></tr>
    
               
                                                                            <tr> <td  colspan="2"> No Server found. </td> </tr>
                                                                              
                                                                            
                                    </table> </td> </tr> 
    
                                    
    <table  style="margin-left:auto; margin-right:auto;width:"100%"; border: "4px solid green"; border-collapse: collapse;" >                     
    <tr> <th  colspan="2" > Hcohesity03 Cluster Daily stats </th> </tr>
    <tr>                                                          <! start of first row in main table  >
    <td >                                                         <! start of first cell in first row in main table  >
    <table >                                                       <! start of top left table  >
    <tr> <th > Cluster Parameter</th> <th > Value </th> </tr>
    
    <tr> <td > Number of Backup Failure </td> <td > 0 </td> </tr>
    
    <tr> <td > Total backup Jobs </td> <td > 325 </td> </tr>
    
    <tr> <td > Total Front End backup size in TB </td> <td > 15494.36 </td> </tr>
    
    <tr> <td > Over All backup success </td>
    
                                      <td ><span style="color: #0000FF"> 100.00 % </td> </tr>
                                      
    <tr> <td > Cluster actual physical Size in TB</td> <td > 385.1 </td> </tr>
    
    <tr> <td > Physical space consumed in TB </td> <td > 179.01 </td> </tr>
    
    <tr> <td > Over All cluster Usage % </td> <td > 46.48 %</td> </tr>
    
                            <tr> <td > IBMCOS Usage in TB </td>
                            <td > 72 </td> </tr>
                            <tr> <td > IBMCOS Usage % </td>
                            <td > 45.57 % </td> </tr>
                            </table>                                                      
                            </td>                                                         
                            <td>
               <table >
                                    <tr> <th  colspan="2"> Servers with Change Rate more than 10% </th> </tr>                                                       <! start of right top table >
                                    <tr> <th > Servers Name </th>
                                    <th > change Rate</th></tr>
    
               
                                                                            <tr> <td  colspan="2"> No Server found. </td> </tr>
                                                                              
                                                                            
                                    </table> </td> </tr> 
    
                                    
    <table  style="margin-left:auto; margin-right:auto;width:"100%"; border: "4px solid green"; border-collapse: collapse;" >                     
    <tr> <th  colspan="2" > Hcohesity04 Cluster Daily stats </th> </tr>
    <tr>                                                          <! start of first row in main table  >
    <td >                                                         <! start of first cell in first row in main table  >
    <table >                                                       <! start of top left table  >
    <tr> <th > Cluster Parameter</th> <th > Value </th> </tr>
    
    <tr> <td > Number of Backup Failure </td> <td > 2 </td> </tr>
    
    <tr> <td > Total backup Jobs </td> <td > 911 </td> </tr>
    
    <tr> <td > Total Front End backup size in TB </td> <td > 2518.08 </td> </tr>
    
    <tr> <td > Over All backup success </td>
    
    <td ><span style="color: #FF0000">99.78 % </td> </tr>
    
    <tr> <td > Cluster actual physical Size in TB</td> <td > 446.23 </td> </tr>
    
    <tr> <td > Physical space consumed in TB </td> <td > 95.26 </td> </tr>
    
    <tr> <td > Over All cluster Usage % </td> <td > 21.35 %</td> </tr>
    
                                    </table>                                                      
                                    </td>                                                         
                                    <td>
               <table >
                                    <tr> <th  colspan="2"> Servers with Change Rate more than 10% </th> </tr>                                                       <! start of right top table >
                                    <tr> <th > Servers Name </th>
                                    <th > change Rate</th></tr>
    
               
                                    <tr> <td > hwd00135.dev.hbcbs.local </td>
                                    <td > 23662 </td> </tr>
                                                                             
                                    
                                    <tr> <td > hwd00270.corpads.local </td>
                                    <td > 19 </td> </tr>
                                                                             
                                    
                                    <tr> <td > hwd00271.corpads.local </td>
                                    <td > 21.1 </td> </tr>
                                                                             
                                    
                                    <tr> <td > hwd00276.corpads.local </td>
                                    <td > 14.3 </td> </tr>
                                                                             
                                    
                                    </table> </td> </tr> 
    
                                    
    <table  style="margin-left:auto; margin-right:auto;width:"100%"; border: "4px solid green"; border-collapse: collapse;" >                     
    <tr> <th  colspan="2" > Hcohesity05 Cluster Daily stats </th> </tr>
    <tr>                                                          <! start of first row in main table  >
    <td >                                                         <! start of first cell in first row in main table  >
    <table >                                                       <! start of top left table  >
    <tr> <th > Cluster Parameter</th> <th > Value </th> </tr>
    
    <tr> <td > Number of Backup Failure </td> <td > 0 </td> </tr>
    
    <tr> <td > Total backup Jobs </td> <td > 442 </td> </tr>
    
    <tr> <td > Total Front End backup size in TB </td> <td > 1289.94 </td> </tr>
    
    <tr> <td > Over All backup success </td>
    
                                      <td ><span style="color: #0000FF"> 100.00 % </td> </tr>
                                      
    <tr> <td > Cluster actual physical Size in TB</td> <td > 311.14 </td> </tr>
    
    <tr> <td > Physical space consumed in TB </td> <td > 69.68 </td> </tr>
    
    <tr> <td > Over All cluster Usage % </td> <td > 22.40 %</td> </tr>
    
                                    </table>                                                      
                                    </td>                                                         
                                    <td>
               <table >
                                    <tr> <th  colspan="2"> Servers with Change Rate more than 10% </th> </tr>                                                       <! start of right top table >
                                    <tr> <th > Servers Name </th>
                                    <th > change Rate</th></tr>
    
               
                                                                            <tr> <td  colspan="2"> No Server found. </td> </tr>
                                                                              
                                                                            
                                    </table> </td> </tr> 
    
                                    
    </table>                                                              
    </body>                                                                
    </html>  

=============================

CodePudding user response:

I haven't used the powershell. But the general rule that you needs to follow for the email if I remember correctly, is that you need to provide inline css in HTML elements.

Its seems like you have a proper HTML. But you need to provide the inline css instead of internal css. So remove the class and instead add style in the HTML element. For example:

<td > Total backup Jobs </td>

change to

<td style="border: solid 2px #ffffff; padding: 5px;"> Total backup Jobs </td>

Also make sure that you have the proper open and closing tags for each element. If you don't provide the closing tag for an element. Browser will handle it but email might won't.

I hope this helps.Thanks

P.S: If you provide the screenshot of the email that would be helpful as well.

  • Related