UPDATE tblemailtemplates_static SET message = '<span style="font-size: 12pt;">Hi {contact_firstname},</span><br /><br /><span style="font-size: 12pt;">I wanted to ask if you\'d mind taking a minute to leave a review for {companyname} so other customers can read about your experience. It will only take a minute.</span><br /><br /><span style="font-size: 12pt;">{business_review_links}</span><br /><span style="font-size: 12pt;"><br /></span><span style="font-size: 12pt;">Thanks so much for giving us the opportunity to serve you {contact_firstname}.</span><br /><br /><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'business-review';

UPDATE tblemailtemplates SET message = '<span style="font-size: 12pt;">Hi {contact_firstname},</span><br /><br /><span style="font-size: 12pt;">I wanted to ask if you\'d mind taking a minute to leave a review for {companyname} so other customers can read about your experience. It will only take a minute.</span><br /><br /><span style="font-size: 12pt;">{business_review_links}</span><br /><span style="font-size: 12pt;"><br /></span><span style="font-size: 12pt;">Thanks so much for giving us the opportunity to serve you {contact_firstname}.</span><br /><br /><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'business-review';

UPDATE tblemailtemplates_static SET message = '<span style="font-size: 12pt;">Hi {contact_firstname},</span><br /><br /><span style="font-size: 12pt;">I wanted to let you know about our referral program. We\'ll give you {offer_amount} for each and every customer you send our way.</span><br /><br /><span style="font-size: 12pt;"> Anytime you hear someone mention they need work done, tell them about us and when they let us know you sent them our way, we will cut you a {offer_amount} check.</span><br /><span style="font-size: 12pt;">If you have any questions, let me know.</span><br /><br />Thanks for everything!<br /><br /><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'client-referral';

UPDATE tblemailtemplates SET message = '<span style="font-size: 12pt;">Hi {contact_firstname},</span><br /><br /><span style="font-size: 12pt;">I wanted to let you know about our referral program. We\'ll give you {offer_amount} for each and every customer you send our way.</span><br /><br /><span style="font-size: 12pt;"> Anytime you hear someone mention they need work done, tell them about us and when they let us know you sent them our way, we will cut you a {offer_amount} check.</span><br /><span style="font-size: 12pt;">If you have any questions, let me know.</span><br /><br />Thanks for everything!<br /><br /><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug = 'client-referral';