UPDATE tblemailtemplates_static SET message = '<span style="font-size: 12pt;">Hi {staff_firstname},</span><br><br><span style="font-size: 12pt;">This is an automated email from {companyname}.</span><br><br><span style="font-size: 12pt;">The task <strong>{task_name}</strong> deadline is on <strong>{task_duedate}</strong>.</span><br><br><span style="font-size: 12pt;">This task is still not finished.</span><br><br><span style="font-size: 12pt;">You can view the task on the following link: <a href="{task_link}">{task_name}</a></span><br><br><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'task-deadline-notification';

UPDATE tblemailtemplates SET message = '<span style="font-size: 12pt;">Hi {staff_firstname},</span><br><br><span style="font-size: 12pt;">This is an automated email from {companyname}.</span><br><br><span style="font-size: 12pt;">The task <strong>{task_name}</strong> deadline is on <strong>{task_duedate}</strong>.</span><br><br><span style="font-size: 12pt;">This task is still not finished.</span><br><br><span style="font-size: 12pt;">You can view the task on the following link: <a href="{task_link}">{task_name}</a></span><br><br><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'task-deadline-notification';