INSERT INTO hp_compose_email (`composeId`,`teamId`,`added_by`,`permission`,`groupId`,`tags`,`skip_lead_tags`,`tempId`,`from_name`,`from_email`,`subject`,`email_body`,`attachment`,`email_type`,`type`,`schedule_date`,`schedule_time`,`server_date`,`server_time`,`time_constraint`,`throttle_per_hour`,`throttle_duration`,`dated`,`email_sent`,`smtp_servers`,`last_leadId`,`emailId`,`is_paused`,`batch_campaign`,`is_processed`,`bulk_activities_status`) VALUES
("862","405","405","","13313","","","0","","","Lead Test","New Lead Test","","Send","email","2016-01-18","16:52:21","2016-01-18","16:52:21","no","0","0","2016-01-18 16:52:21","0","31","0","0","0","no","yes","start"),
("1202","405","405","","547137","","","4051449531793","","","Email#2_Wine_Turn Your Tasting Venues Into Lead Generation Factories","<table width=\"100%\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"background-color:#fff;\"><tbody><tr><td class=\"paragraph\" style=\" padding: 15px;\">
\n			
\n			<span id=\"t1\"><span style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\">HI&nbsp;&nbsp;{FirstName}!</span><br style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\"><br style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\"><span style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\">Not only do we transform your 5 Star Reviews into Review Branding Commercials,</span><br style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\"><span style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\">we offer a unique system to turn your tasting venues into Lead Generation Factories!.</span><br style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\"><span style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\">Click below for all the details:</span><br style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\"><div style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium; text-align: center;\">
\n	<br><br><a href=\"http://impact.membersnap.com/\"><img alt=\"Click here if image is not visible\" src=\"https://s3-us-west-1.amazonaws.com/impact-ins/Images/ImpactLogo.png\" style=\"width: 336px; height: 130px;\"></a></div>
\n<div style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium; text-align: center;\">
\n	<br>
\n	&nbsp;<a href=\"http://impact.membersnap.com/\">CLICK HERE if image is not&nbsp;visable</a><br><br><br><br><br><br><br>
\n	&nbsp;</div>
\n<div style=\"color: rgb(0, 0, 0); font-family: \'Times New Roman\'; font-size: medium;\">
\n	<a href=\"http://impact.membersnap.com/\">&nbsp;{unsubscribe}</a></div>
\n</span>
\n		</td>
\n	</tr></tbody></table>
\n
\n<script type=\"text/javascript\">
\n$(document).ready(function(){
\n	$(\'.show-action-on\').remove();
\n	$(\'.ToRemove\').remove();
\n})
\n</script>","","Send","email","2016-02-16","07:31:20","2016-02-16","07:31:20","no","0","0","2016-02-16 07:31:20","0","31","0","19608","0","no","yes","start"),
("1203","405","405","","10457","","","4051453851300","","","iMPACT \"Bid Concept\" Presentation Appointment Scheduled!","<div marginwidth=\"0\" marginheight=\"0\" style=\"margin:0;padding:0;background-color:#f2f2f2;min-height:100%!important;width:100%!important\">
\n	<center>
\n		<table style=\"border-collapse:collapse;margin:0;padding:0;background-color:#f2f2f2;height:100%!important;width:100%!important\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"100%\" width=\"600\" id=\"bodyTable\"><tbody><tr><td style=\"margin:0;padding:0;border-top:0;height:100%!important;width:100%!important\" align=\"center\" valign=\"top\">
\n						<table style=\"border-collapse:collapse;background-color: #fff;margin: 1% 0;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\" id=\"templateContainer\"><tbody><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templatePreheader\"><td align=\"center\" valign=\"top\">
\n										<table style=\"border-collapse:collapse;border-top:0;border-bottom:0\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td align=\"center\" valign=\"top\">
\n										<table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr><td style=\"padding-top:9px\" valign=\"top\"><table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td valign=\"top\">
\n										
\n										<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td style=\"padding-top:9px;padding-left:18px;padding-bottom:9px;padding-right:0;color:#606060;font-family:Helvetica;font-size:11px;line-height:125%;text-align:left; padding:2%;\" valign=\"top\" class=\"paragraph templatePreheader\">
\n										
\n										<span id=\"t1\"><pre style=\"text-align: center;\"><span style=\"font-size:20px;\"><strong><span style=\"font-family:helvetica,times,serif;\">APPOINTMENT SCHEDULED!</span></strong></span></pre>
\n</span>
\n										</td>
\n										</tr></tbody></table></td>
\n										</tr></tbody></table></td>
\n										</tr></tbody></table></td>
\n										</tr></tbody></table></td>
\n								</tr><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templateHeader\"><td align=\"center\" valign=\"top\">
\n								
\n								<table style=\"border-collapse:collapse;border-top:0;border-bottom:0\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td align=\"center\" valign=\"top\">
\n								<table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr><td style=\"padding-top:10px;padding-bottom:10px\" valign=\"top\"><table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td style=\"padding:9px\" valign=\"top\">
\n								<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td style=\"padding-right:9px;padding-left:9px;padding-top:0;padding-bottom:0; width:600\" valign=\"top\" class=\"templateImage paragraph templateHeader\">
\n								
\n								<span class=\"viewIm1\">
\n								<img src=\"https://impactinsmkg.com/glu/assests/templates/file/14538514424643ImpactLogopng.png\" style=\"max-width:600px;padding-bottom:0;display:inline!important;vertical-align:bottom;border:0;outline:none;text-decoration:none\" align=\"left\" width=\"600\"></span>
\n								</td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n								</tr><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templateBody\"><td align=\"center\" valign=\"top\">
\n								
\n								<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr id=\"body1\"><td style=\"padding-top:9px;padding-right:18px;padding-bottom:9px;padding-left:18px;color:#606060;font-family:Helvetica;font-size:15px;line-height:150%;text-align:left;padding:2%;\" valign=\"top\" class=\"paragraph templateBody\">
\n								
\n								<span id=\"t2\"><pre style=\"margin: 0px; padding: 0px; display: block; font-family: Helvetica; font-size: 30px; font-style: normal; font-weight: bold; line-height: 125%; letter-spacing: -1px; text-align: center; color: rgb(96, 96, 96) !important;\"><strong><span style=\"font-size:24px;\"><span style=\"font-family:helvetica,times,serif;\">   - Scheduling Details -</span></span></strong></pre>
\n<h3 style=\"margin: 0px; padding: 0px; display: block; font-size: 18px; font-style: normal; font-weight: bold; line-height: 125%; letter-spacing: -0.5px; text-align: left; color: rgb(96, 96, 96) !important;\">
\n	&nbsp;</h3>
\n<pre><strong><span style=\"font-size:18px;\"><span style=\"font-family:helvetica,times,serif;\">       <span style=\"font-size:16px;\"><span style=\"color: rgb(34, 34, 34);\">             Date of Appt:                             </span></span></span></span></strong><span style=\"font-size:16px;\">
\n<strong><span style=\"font-family: helvetica, times, serif; color: rgb(34, 34, 34);\">                                   Time:</span></strong>
\n
\n<strong><span style=\"font-family:helvetica,times,serif;\">                       Company:   {company}                                     </span></strong>        
\n<strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family: helvetica, times, serif;\">                            Phone:   {phone}</span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">       
\n</strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">                    First Name:  </strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">&nbsp;{first_name}
\n</strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">                     Last Name:  &nbsp;{last_name}
\n<span style=\"font-family: helvetica, times, serif;\">                                Title: &nbsp;&nbsp;{Contact_Title}</span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">  </strong><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\">          &nbsp;</span></strong>
\n
\n<strong><span style=\"font-family:helvetica,times,serif;\">                         Address:  </span></strong><strong><span style=\"font-family:helvetica,times,serif;\">{address} </span></strong><strong><span style=\"font-family:helvetica,times,serif;\">               </span></strong>
\n<strong><span style=\"font-family:helvetica,times,serif;\">                                 City:  </span><span style=\"font-family: helvetica, times, serif;\"> {city}       </span></strong>
\n<strong><span style=\"font-family: helvetica, times, serif;\">                               State:   {state}</span>
\n<span style=\"font-family: helvetica, times, serif;\">                                   Zip:   {zip} </span></strong>
\n
\n<span style=\"font-family:helvetica,times,serif;\">                         <strong>Revenue:
\n</strong></span><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\">                       &nbsp;# of Empl:
\n</span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\">                             X-Date:
\n
\n</span></strong></span><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\"><span style=\"font-size:18px;\">    Email:&nbsp;</span></span><span style=\"font-size:18px;\"><span style=\"font-family: helvetica, times, serif;\"> {email}
\n</span></span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-size:18px;\"><span style=\"font-family:helvetica,times,serif;\">Website:  </span><span style=\"font-family: helvetica, times, serif;\">{website}</span></span></strong>
\n</pre>
\n<p>
\n	&nbsp;</p>
\n</span>
\n								</td>
\n								</tr></tbody></table></td>
\n								</tr><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templateFooter\"><td valign=\"top\">
\n								
\n								<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr><td style=\"padding-top:9px;padding-right:18px;padding-bottom:9px;padding-left:18px;color:#606060;font-family:Helvetica;font-size:11px;line-height:125%;text-align:center;padding:2%;\" valign=\"top\" class=\"paragraph templateFooter\">
\n								
\n								<span id=\"t4\"><div style=\"text-align: center;\">
\n	<strong>Our email address:&nbsp;</strong><br><span style=\"text-align: center;\">ImpactInsMkg@gmail.com</span></div>
\n<div style=\"text-align: center;\">
\n	&nbsp;</div>
\n<div style=\"text-align: center;\">
\n	<em>Copyright © 2016 |&nbsp;iMPACT&nbsp;Insurance Marketing |<br>
\n	&nbsp;</em><em style=\"text-align: center;\">All rights reserved.</em></div>
\n<br></span>
\n								</td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n				</tr></tbody></table></center>
\n</div>
\n
\n<script type=\"text/javascript\">
\n$(document).ready(function(){
\n	$(\'.show-action-on\').remove();
\n	$(\'.ToRemove\').remove();
\n})
\n</script>","","Send","email","2016-02-16","07:33:51","2016-02-16","07:33:51","no","0","0","2016-02-16 07:33:51","0","31","974992","19609","0","no","yes","start"),
("1204","405","405","","547137","","","4051453851300","","","iMPACT \"Bid Concept\" Presentation Appointment Scheduled!","<div marginwidth=\"0\" marginheight=\"0\" style=\"margin:0;padding:0;background-color:#f2f2f2;min-height:100%!important;width:100%!important\">
\n	<center>
\n		<table style=\"border-collapse:collapse;margin:0;padding:0;background-color:#f2f2f2;height:100%!important;width:100%!important\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"100%\" width=\"600\" id=\"bodyTable\"><tbody><tr><td style=\"margin:0;padding:0;border-top:0;height:100%!important;width:100%!important\" align=\"center\" valign=\"top\">
\n						<table style=\"border-collapse:collapse;background-color: #fff;margin: 1% 0;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\" id=\"templateContainer\"><tbody><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templatePreheader\"><td align=\"center\" valign=\"top\">
\n										<table style=\"border-collapse:collapse;border-top:0;border-bottom:0\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td align=\"center\" valign=\"top\">
\n										<table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr><td style=\"padding-top:9px\" valign=\"top\"><table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td valign=\"top\">
\n										
\n										<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td style=\"padding-top:9px;padding-left:18px;padding-bottom:9px;padding-right:0;color:#606060;font-family:Helvetica;font-size:11px;line-height:125%;text-align:left; padding:2%;\" valign=\"top\" class=\"paragraph templatePreheader\">
\n										
\n										<span id=\"t1\"><pre style=\"text-align: center;\"><span style=\"font-size:20px;\"><strong><span style=\"font-family:helvetica,times,serif;\">APPOINTMENT SCHEDULED!</span></strong></span></pre>
\n</span>
\n										</td>
\n										</tr></tbody></table></td>
\n										</tr></tbody></table></td>
\n										</tr></tbody></table></td>
\n										</tr></tbody></table></td>
\n								</tr><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templateHeader\"><td align=\"center\" valign=\"top\">
\n								
\n								<table style=\"border-collapse:collapse;border-top:0;border-bottom:0\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td align=\"center\" valign=\"top\">
\n								<table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr><td style=\"padding-top:10px;padding-bottom:10px\" valign=\"top\"><table style=\"border-collapse:collapse\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td style=\"padding:9px\" valign=\"top\">
\n								<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tbody><tr><td style=\"padding-right:9px;padding-left:9px;padding-top:0;padding-bottom:0; width:600\" valign=\"top\" class=\"templateImage paragraph templateHeader\">
\n								
\n								<span class=\"viewIm1\">
\n								<img src=\"https://impactinsmkg.com/glu/assests/templates/file/14538514424643ImpactLogopng.png\" style=\"max-width:600px;padding-bottom:0;display:inline!important;vertical-align:bottom;border:0;outline:none;text-decoration:none\" align=\"left\" width=\"600\"></span>
\n								</td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n								</tr><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templateBody\"><td align=\"center\" valign=\"top\">
\n								
\n								<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr id=\"body1\"><td style=\"padding-top:9px;padding-right:18px;padding-bottom:9px;padding-left:18px;color:#606060;font-family:Helvetica;font-size:15px;line-height:150%;text-align:left;padding:2%;\" valign=\"top\" class=\"paragraph templateBody\">
\n								
\n								<span id=\"t2\"><pre style=\"margin: 0px; padding: 0px; display: block; font-family: Helvetica; font-size: 30px; font-style: normal; font-weight: bold; line-height: 125%; letter-spacing: -1px; text-align: center; color: rgb(96, 96, 96) !important;\"><strong><span style=\"font-size:24px;\"><span style=\"font-family:helvetica,times,serif;\">   - Scheduling Details -</span></span></strong></pre>
\n<h3 style=\"margin: 0px; padding: 0px; display: block; font-size: 18px; font-style: normal; font-weight: bold; line-height: 125%; letter-spacing: -0.5px; text-align: left; color: rgb(96, 96, 96) !important;\">
\n	&nbsp;</h3>
\n<pre><strong><span style=\"font-size:18px;\"><span style=\"font-family:helvetica,times,serif;\">       <span style=\"font-size:16px;\"><span style=\"color: rgb(34, 34, 34);\">             Date of Appt:                             </span></span></span></span></strong><span style=\"font-size:16px;\">
\n<strong><span style=\"font-family: helvetica, times, serif; color: rgb(34, 34, 34);\">                                   Time:</span></strong>
\n
\n<strong><span style=\"font-family:helvetica,times,serif;\">                       Company:   {company}                                     </span></strong>        
\n<strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family: helvetica, times, serif;\">                            Phone:   {phone}</span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">       
\n</strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">                    First Name:  </strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">&nbsp;{first_name}
\n</strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">                     Last Name:  &nbsp;{last_name}
\n<span style=\"font-family: helvetica, times, serif;\">                                Title: &nbsp;&nbsp;{Contact_Title}</span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\">  </strong><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\">          &nbsp;</span></strong>
\n
\n<strong><span style=\"font-family:helvetica,times,serif;\">                         Address:  </span></strong><strong><span style=\"font-family:helvetica,times,serif;\">{address} </span></strong><strong><span style=\"font-family:helvetica,times,serif;\">               </span></strong>
\n<strong><span style=\"font-family:helvetica,times,serif;\">                                 City:  </span><span style=\"font-family: helvetica, times, serif;\"> {city}       </span></strong>
\n<strong><span style=\"font-family: helvetica, times, serif;\">                               State:   {state}</span>
\n<span style=\"font-family: helvetica, times, serif;\">                                   Zip:   {zip} </span></strong>
\n
\n<span style=\"font-family:helvetica,times,serif;\">                         <strong>Revenue:
\n</strong></span><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\">                       &nbsp;# of Empl:
\n</span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\">                             X-Date:
\n
\n</span></strong></span><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-family:helvetica,times,serif;\"><span style=\"font-size:18px;\">    Email:&nbsp;</span></span><span style=\"font-size:18px;\"><span style=\"font-family: helvetica, times, serif;\"> {email}
\n</span></span></strong><strong style=\"font-family: Arial, Verdana, sans-serif;\"><span style=\"font-size:18px;\"><span style=\"font-family:helvetica,times,serif;\">Website:  </span><span style=\"font-family: helvetica, times, serif;\">{website}</span></span></strong>
\n</pre>
\n<p>
\n	&nbsp;</p>
\n</span>
\n								</td>
\n								</tr></tbody></table></td>
\n								</tr><tr style=\"border-bottom: 1px solid #ccc;\" id=\"templateFooter\"><td valign=\"top\">
\n								
\n								<table style=\"border-collapse:collapse\" align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"600\"><tbody><tr><td style=\"padding-top:9px;padding-right:18px;padding-bottom:9px;padding-left:18px;color:#606060;font-family:Helvetica;font-size:11px;line-height:125%;text-align:center;padding:2%;\" valign=\"top\" class=\"paragraph templateFooter\">
\n								
\n								<span id=\"t4\"><div style=\"text-align: center;\">
\n	<strong>Our email address:&nbsp;</strong><br><span style=\"text-align: center;\">ImpactInsMkg@gmail.com</span></div>
\n<div style=\"text-align: center;\">
\n	&nbsp;</div>
\n<div style=\"text-align: center;\">
\n	<em>Copyright © 2016 |&nbsp;iMPACT&nbsp;Insurance Marketing |<br>
\n	&nbsp;</em><em style=\"text-align: center;\">All rights reserved.</em></div>
\n<br></span>
\n								</td>
\n								</tr></tbody></table></td>
\n								</tr></tbody></table></td>
\n				</tr></tbody></table></center>
\n</div>
\n
\n<script type=\"text/javascript\">
\n$(document).ready(function(){
\n	$(\'.show-action-on\').remove();
\n	$(\'.ToRemove\').remove();
\n})
\n</script>","","Send","email","2016-02-16","07:34:07","2016-02-16","07:34:07","no","0","0","2016-02-16 07:34:07","0","31","0","19610","0","no","yes","start");



