Iam reaching out regarding an issue with our email template configuration. Our current HTML template works correctly without tables, but as soon as we incorporate tables for displaying dynamic data (like user background verification status and support ticket summaries), the email fails to send or render correctly. This table is essential for displaying detailed user information and support ticket updates.
I’ve checked for common issues, such as CSS syntax and HTML structure, but it appears the issue may be related to how Saviynt processes or renders HTML tables within email templates. Could you please assist in resolving this, or let me know if there are specific formatting requirements we need to follow to make this work?
SELECT u.username As 'username', u.firstname AS 'First Name' ,u.lastname AS 'Last Name', DATE_ADD(u.startdate, INTERVAL 60 DAY) AS 'expirydate' FROM users u LEFT JOIN users manager ON u.manager = manager.userkey WHERE ( u.customproperty37 is null OR u.customproperty37 != 'YES') and u.employeetype= 'Contractor' AND u.startdate IN ( DATE_SUB(CURDATE(), INTERVAL 55 DAY), DATE_SUB(CURDATE(), INTERVAL 10 DAY), DATE_SUB(CURDATE(), INTERVAL 3 DAY), DATE_SUB(CURDATE(), INTERVAL 9 DAY), DATE_SUB(CURDATE(), INTERVAL 60 DAY), DATE_SUB(CURDATE(), INTERVAL 10 DAY), DATE_SUB(CURDATE(), INTERVAL 60 DAY) );
Template
:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>BGV Verification</title>
</head>
<style>
{
font-family: Arial, sans-serif;
background-color: #f4f4f4;
}
.container {
width: 100%;
margin: 0 auto;
background-color: #ffffff;
padding: 20px;
}
.header-table {
width: 100%;
background-color: #e1e1e1;
}
.header-table td {
padding: 10px;
}
.content-table {
width: 100%;
margin: 20px 0;
border-collapse: collapse;
text-align: left;
}
.content-table th, .content-table td {
border: 1px solid #ddd;
padding: 8px;
}
.content-table th {
background-color: #f2f2f2;
font-weight: bold;
}
.footer {
margin-top: 20px;
text-align: center;
font-size: 12px;
color: #555;
}
</style>
</head>
<body>
<div class="container">
<!-- Header Section -->
<table class="header-table" border="0">
<tr>
<td align="left">
<img src="img url" alt="removed" width="100" />
</td>
<td align="right">
<img src="img url " alt="removed" width="60" height="60" />
</td>
</tr>
</table>
<h3>Dear Manager,</h3>
<p>This email serves to highlight the outstanding background verification (BGV) status of user. As per company policy, the BGV process must be completed within 90 days of onboarding. Failure to do so will unfortunately result in the automatic deactivation of user accounts.
A list of users with pending BGV is attached to this email for your reference. We kindly request that you prioritize the completion of their verifications to ensure continued access to company resources and systems.</p>
<table class="content-table" border="1">
<thead>
<tr>
<th>Username</th>
<th>First Name</th>
<th>Last Name</th>
<th>Expiry Date</th>
</tr>
</thead>
<tbody>
<tr>
<td>${ANALYTICSDATA.username[0]}</td>
<td>${ANALYTICSDATA['First Name'][0]}</td>
<td>${ANALYTICSDATA['Last Name'][0]}</td>
<td>${ANALYTICSDATA['expirydate'][0]}</td>
</tr>
</tbody>
</table>
</body>
</br></br>
Regards,</br>
Removed
</body>
</html>
The Template is Working Without add the table i aint unable to understand cuz same template is working in DEV i dont where it wrong please help me to resolve the issue
Thank you for your attention to this matter. I look forward to your guidance.
[This message has been edited by moderator to mask sensitive information]
