INSERT INTO hp_email_log (`emailId`,`composeId`,`templateId`,`smtpId`,`memberId`,`added_by`,`subject`,`body`,`type`,`email_type`,`dated`,`attachment`) VALUES
("266370","0","0","","2229","2229","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><table align=\"center\"><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 <a target=\'_blank\'  href=\"https://carleadsondemand.com/glu/unsubscribe/2229/VjcxK3dLRHZNVzdGdE03R1VZekdwQT09/MEZVbzNTekNVMmxFM1BLdDhFMS9zUT09\">Click here</a></a><br>\n											To update your contact information please  <a href=\"https://carleadsondemand.com/glu/update-contact/XzIyMjk=\">Click here</a> \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 cdutchak@autocan.ca by:</b><br>\n															 , Maple Ridge, British Columbia, USA / Canada<br>\n														</p>\n													</td>\n													<td  style=\"width:20%;\">\n														 <a title=\"Visit here\" target=\"_blank\" href=\"https://carleadsondemand.com\"><img width=\"100\" hight=\"50\" src=\"carleadsondemand.com/glu/resources/2229/logo.png\"></a>\n													</td>\n												</tr>\n												\n											</tbody>\n										</table>\n										\n									</td>\n								</tr>\n							</tbody>\n						</table>\n					</td>\n				</tr></tbody></table><img src=\"https://app.agencyelephant.com/glu/email/mailread/416831650864\" border=\"\" width=\"1\" height=\"1\" alt=\".\">","N","0","2017-09-27",""),
("266372","7800","0","170,453","2229","2229","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>","N","0","2017-09-27",""),
("266373","7801","0","170,453","2229","2229","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>","N","0","2017-09-27",""),
("266380","0","0","","2229","2229","Test3","<p class=\"p1\">
\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</p><table align=\"center\"><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 <a target=\'_blank\'  href=\"https://carleadsondemand.com/glu/unsubscribe/2229/VjcxK3dLRHZNVzdGdE03R1VZekdwQT09/VEs2NWxIaEV6RXBlOHRzRVhVcTBSQT09\">Click here</a></a><br>\n											To update your contact information please  <a href=\"https://carleadsondemand.com/glu/update-contact/XzIyMjk=\">Click here</a> \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 cdutchak@autocan.ca by:</b><br>\n															 , Maple Ridge, British Columbia, USA / Canada<br>\n														</p>\n													</td>\n													<td  style=\"width:20%;\">\n														 <a title=\"Visit here\" target=\"_blank\" href=\"https://carleadsondemand.com\"><img width=\"100\" hight=\"50\" src=\"carleadsondemand.com/glu/resources/2229/logo.png\"></a>\n													</td>\n												</tr>\n												\n											</tbody>\n										</table>\n										\n									</td>\n								</tr>\n							</tbody>\n						</table>\n					</td>\n				</tr></tbody></table><img src=\"https://app.agencyelephant.com/glu/email/mailread/354199319425\" border=\"\" width=\"1\" height=\"1\" alt=\".\">","N","0","2017-09-27",""),
("303914","0","0","","2229","2229","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<table align=\"center\"><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 <a target=\'_blank\'  href=\"https://carleadsondemand.com/glu/unsubscribe/2229/VjcxK3dLRHZNVzdGdE03R1VZekdwQT09/bHJSeDRMRzNzUVNqQTN6OVFPbExvZz09\">Click here</a></a><br>\n											To update your contact information please  <a href=\"https://carleadsondemand.com/glu/update-contact/XzIyMjk=\">Click here</a> \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 sean.cassy@gmail.com by:</b><br>\n															Maple Ridge Chrysler Dodge Jeep Ram , 11911 West St, Maple Ridge, British Columbia, V2X 3M6, USA / Canada<br>\n														</p>\n													</td>\n													<td  style=\"width:20%;\">\n														 <a title=\"Visit here\" target=\"_blank\" href=\"https://carleadsondemand.com\"><img width=\"100\" hight=\"50\" src=\"carleadsondemand.com/glu/resources/2229/logo.png\"></a>\n													</td>\n												</tr>\n												\n											</tbody>\n										</table>\n										\n									</td>\n								</tr>\n							</tbody>\n						</table>\n					</td>\n				</tr></tbody></table><img src=\"https://app.agencyelephant.com/glu/email/mailread/107295145420\" border=\"\" width=\"1\" height=\"1\" alt=\".\">","N","0","2017-12-14",""),
("303915","8397","0","170","2229","2229","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>","N","0","2017-12-14","");



