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
("7800","2229","2229","","588575","","","0","","","Test1","X<div style=\"clear:both\"></div><table align=\"center\" style=\"float: left; width:100%\"><tbody><tr id=\"canspam\">\n            <td>  \n               <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\" bgcolor=\"#e8e8e8\">\n                  <tbody>\n                     <tr>\n                        <td>\n                           <p style=\"font-size: 13px; color:rgb(68, 68, 68);margin-top:10px;margin-bottom:10px;padding-left:10px\"> To unsubscribe from all future emails {unsubscribe}</a><br>\n                              To update your contact information please  {contact_info_update} \n                           </p> \n                        </td>\n                     </tr>\n                     <tr>\n                        <td>            \n                           <table width=\"100%\">\n                              <tbody>\n                                 <tr style=\"width:100%;\">\n                                    <td style=\"width:80%;\">\n                                       <p style=\"font-size: 13px; color: rgb(68, 68, 68);padding-left:10px\"> <b>This email is sent to {email} by:</b><br>\n                                          {{CompanyName}} {{Address}}<br>\n                                       </p>\n                                    </td>\n                                    <td  style=\"width:20%;\">\n                                       \n                                    </td>\n                                 </tr>\n                              </tbody>\n                           </table>\n                        </td>\n                     </tr>\n                  </tbody>\n               </table>\n            </td>\n            </tr></tbody></table>","","Schedule_Send","email","2017-09-27","14:40:47","2017-09-27","14:40:47","no","50","15","2017-09-27 14:40:47","0","170,453","0","266372","0","yes","yes","start"),
("7801","2229","2229","","588575","","","0","","","Test2","<p class=\"p1\">
\n	<span class=\"s1\"><?xml version=\"1.0\" encoding=\"UTF-8\"?> <?ADF VERSION=\"1.0\"?> <adf> <prospect> <id source=\"Hot Prospector\">Hot Prospector</id> <requestdate>2017-09-27T14:39:59-07:00</requestdate> <vehicle interest=\"buy\" status=\"new\"> <id></id> <year></year> <make></make> <model></model> <trim></trim> <doors></doors> <bodystyle></bodystyle> <transmission></transmission> <colorcombination> <exteriorcolor></exteriorcolor> <preference></preference> </colorcombination> <pricecomments></pricecomments> <option> <optionname></optionname> <manufacturercode></manufacturercode> <price type=\"msrp\"></price> </option> <finance> <method></method> <amount></amount> </finance> </vehicle> <customer> <contact> <name part=\"first\">Christest</name> <name part=\"last\">Dutchaktest</name> <email preferredcontact=\"0\"><a href=\"mailto:cdutchak@autocan.ca\"><span class=\"s2\">cdutchak@autocan.ca</span></a></email> <phone type=\"voice\" time=\"nopreference\" preferredcontact=\"1\">7806600992</phone> <address> <street line=\"1\">Q34534</street> <city>5SDFGSDFG</city> <regioncode>Saskatchewan</regioncode> <postalcode>4356345</postalcode> </address> </contact> <comments>Lead Source: wufooForm</comments> </customer> <vendor> <id source=\"191:ADF XML\"/> <id source=\"AdditionalEmails\"/> <id source=\"DealerId\">2229</id> <vendorname>Maple Ridge Chrysler</vendorname> <contact> <name part=\"full\" type=\"individual\"/> <email preferredcontact=\"0\"><a href=\"mailto:mapleridgechrysler@turbohpadmin.com\"><span class=\"s2\">mapleridgechrysler@turbohpadmin.com</span></a></email> <phone preferredcontact=\"0\" time=\"nopreference\" type=\"voice\">+18196611409</phone> <address> <street line=\"1\"></street> <city>Maple Ridge</city> <regioncode>British Columbia</regioncode> <postalcode></postalcode> </address> </contact> </vendor> <provider> <name part=\"full\">Maple Ridge Chrysler</name> <service></service> </provider> </prospect> </adf></span></p>
\n
\n
\n<?xml version=\"1.0\" encoding=\"UTF-8\"?> <?ADF VERSION=\"1.0\"?> <adf> <prospect> <id source=\"Hot Prospector\">Hot Prospector</id> <requestdate>2017-09-27T14:39:59-07:00</requestdate> <vehicle interest=\"buy\" status=\"new\"> <id></id> <year></year> <make></make> <model></model> <trim></trim> <doors></doors> <bodystyle></bodystyle> <transmission></transmission> <colorcombination> <exteriorcolor></exteriorcolor> <preference></preference> </colorcombination> <pricecomments></pricecomments> <option> <optionname></optionname> <manufacturercode></manufacturercode> <price type=\"msrp\"></price> </option> <finance> <method></method> <amount></amount> </finance> </vehicle> <customer> <contact> <name part=\"first\">Christest</name> <name part=\"last\">Dutchaktest</name> <email preferredcontact=\"0\">cdutchak@autocan.ca</email> <phone type=\"voice\" time=\"nopreference\" preferredcontact=\"1\">7806600992</phone> <address> <street line=\"1\">Q34534</street> <city>5SDFGSDFG</city> <regioncode>Saskatchewan</regioncode> <postalcode>4356345</postalcode> </address> </contact> <comments>Lead Source: wufooForm</comments> </customer> <vendor> <id source=\"191:ADF XML\"/> <id source=\"AdditionalEmails\"/> <id source=\"DealerId\">2229</id> <vendorname>Maple Ridge Chrysler</vendorname> <contact> <name part=\"full\" type=\"individual\"/> <email preferredcontact=\"0\">mapleridgechrysler@turbohpadmin.com</email> <phone preferredcontact=\"0\" time=\"nopreference\" type=\"voice\">+18196611409</phone> <address> <street line=\"1\"></street> <city>Maple Ridge</city> <regioncode>British Columbia</regioncode> <postalcode></postalcode> </address> </contact> </vendor> <provider> <name part=\"full\">Maple Ridge Chrysler</name> <service></service> </provider> </prospect> </adf><div style=\"clear:both\"></div><table align=\"center\" style=\"float: left; width:100%\"><tbody><tr id=\"canspam\">\n            <td>  \n               <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\" bgcolor=\"#e8e8e8\">\n                  <tbody>\n                     <tr>\n                        <td>\n                           <p style=\"font-size: 13px; color:rgb(68, 68, 68);margin-top:10px;margin-bottom:10px;padding-left:10px\"> To unsubscribe from all future emails {unsubscribe}</a><br>\n                              To update your contact information please  {contact_info_update} \n                           </p> \n                        </td>\n                     </tr>\n                     <tr>\n                        <td>            \n                           <table width=\"100%\">\n                              <tbody>\n                                 <tr style=\"width:100%;\">\n                                    <td style=\"width:80%;\">\n                                       <p style=\"font-size: 13px; color: rgb(68, 68, 68);padding-left:10px\"> <b>This email is sent to {email} by:</b><br>\n                                          {{CompanyName}} {{Address}}<br>\n                                       </p>\n                                    </td>\n                                    <td  style=\"width:20%;\">\n                                       \n                                    </td>\n                                 </tr>\n                              </tbody>\n                           </table>\n                        </td>\n                     </tr>\n                  </tbody>\n               </table>\n            </td>\n            </tr></tbody></table>","","Schedule_Send","email","2017-09-27","14:45:42","2017-09-27","14:45:42","no","50","15","2017-09-27 14:45:42","0","170,453","0","266373","0","yes","yes","start"),
("8397","2229","2229","","593979","","","0","","","test SMTP","Hi {first_name}, this is a test to see if the SMTP is pushing the emails.<br />
\n<br />
\nTxs!<br />
\n<br />
\nSean<div style=\"clear:both\"></div><table align=\"center\" style=\"float: left; width:100%\"><tbody><tr id=\"canspam\">\n            <td>  \n               <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\" bgcolor=\"#e8e8e8\">\n                  <tbody>\n                     <tr>\n                        <td>\n                           <p style=\"font-size: 13px; color:rgb(68, 68, 68);margin-top:10px;margin-bottom:10px;padding-left:10px\"> To unsubscribe from all future emails {unsubscribe}</a><br>\n                              To update your contact information please  {contact_info_update} \n                           </p> \n                        </td>\n                     </tr>\n                     <tr>\n                        <td>            \n                           <table width=\"100%\">\n                              <tbody>\n                                 <tr style=\"width:100%;\">\n                                    <td style=\"width:80%;\">\n                                       <p style=\"font-size: 13px; color: rgb(68, 68, 68);padding-left:10px\"> <b>This email is sent to {email} by:</b><br>\n                                          {{CompanyName}} {{Address}}<br>\n                                       </p>\n                                    </td>\n                                 </tr>\n                              </tbody>\n                           </table>\n                        </td>\n                     </tr>\n                  </tbody>\n               </table>\n            </td>\n            </tr></tbody></table>","","Schedule_Send","email","2017-12-14","04:46:19","2017-12-14","04:46:19","no","50","15","2017-12-14 04:46:19","0","170","0","303915","0","yes","yes","start");



