Html not getting displayed in Table Format

Hello Ramco,

The issue you're facing is likely due to the email client not rendering the HTML correctly or the IsBodyHtml property not being set to true in the MailMessage object. Without IsBodyHtml = true, the email client will treat the content as plain text, and the HTML tags will be displayed as a normal string instead of being rendered as a table.

Here’s how you can fix the issue and ensure the HTML table is displayed correctly in the email body:

// Build the HTML table
StringBuilder htmlTable = new StringBuilder();
htmlTable.Append("");
htmlTable.Append("");

// Add headers to the table
htmlTable.Append("");
htmlTable.Append("");
htmlTable.Append("");
htmlTable.Append("");
htmlTable.Append("");

// Add rows to the table
while (!oRecordSet.EoF)
{
    htmlTable.Append("");
    htmlTable.Append("");
    htmlTable.Append("");
    htmlTable.Append("");
    htmlTable.Append("");

    oRecordSet.MoveNext();
}

htmlTable.Append("
Transaction ID
Doc. No
Doc. Date
" + oRecordSet.Fields.Item("TransId").Value.ToString() + "
" + oRecordSet.Fields.Item("DocNum").Value.ToString() + "
" + oRecordSet.Fields.Item("DocDate").Value.ToString() + "
");

// Convert the StringBuilder to a string
string body = htmlTable.ToString();

// Email configuration
var addresses = "[email protected];[email protected]";
var fromAddress = new MailAddress("[email protected]", "Sender");
const string fromPassword = "Password"; // Use app-specific password if 2FA is enabled
string subject = "[Message] Data in HTML Table";

var smtp = new SmtpClient
{
    Host = "smtp.gmail.com",
    Port = 587,
    EnableSsl = true,
    DeliveryMethod = SmtpDeliveryMethod.Network,
    UseDefaultCredentials = false,
    Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};

// Send the email
foreach (var address in addresses.Split(new[] { ";" }, StringSplitOptions.RemoveEmptyEntries))
{
    using (var message = new MailMessage(fromAddress, new MailAddress(address))
    {
        Subject = subject,
        Body = body,
        IsBodyHtml = true // Ensure this is set to true for HTML content
    })
    {
        try
        {
            smtp.Send(message);
            Console.WriteLine($"Email sent to {address}");
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Failed to send email to {address}: {ex.Message}");
        }
    }
}