
update tblsms_templates_static set template = "Hey {contact_firstname}, when you get a minute, would you mind leaving a review for {companyname}? Google: {google_my_business_link}. Yelp: {yelp_business_link}. Facebook: {facebook_business_link}. Thanks so much!" where type = "business_review";

update tblsms_templates set template = "Hey {contact_firstname}, when you get a minute, would you mind leaving a review for {companyname}? Google: {google_my_business_link}. Yelp: {yelp_business_link}. Facebook: {facebook_business_link}. Thanks so much!" where type = "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 /><b>You can review us at Google here: </b><span style=\"font-size: 12pt;\">{google_my_business_link}<br /><br /><b>You can review us at Yelp here:</b><span style=\"font-size: 12pt;\"> {yelp_business_link}</span><br /><br /><b>You can review us at Facebook here:</b><span style=\"font-size: 12pt;\"> {facebook_business_link}</span><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 type = "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 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 /><b>You can review us at Google here: </b><span style=\"font-size: 12pt;\">{google_my_business_link}<br /><br /><b>You can review us at Yelp here:</b><span style=\"font-size: 12pt;\"> {yelp_business_link}</span><br /><br /><b>You can review us at Facebook here:</b><span style=\"font-size: 12pt;\"> {facebook_business_link}</span><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 type = "business_review";