| Line 414... |
Line 414... |
| 414 |
followupSheet = workbook.add_sheet("Followup Call Summary")
|
414 |
followupSheet = workbook.add_sheet("Followup Call Summary")
|
| 415 |
setWorksheetTemplate(freshSheet, followupSheet)
|
415 |
setWorksheetTemplate(freshSheet, followupSheet)
|
| 416 |
populateFreshSheet(freshSheet)
|
416 |
populateFreshSheet(freshSheet)
|
| 417 |
populateFollowupSheet(followupSheet)
|
417 |
populateFollowupSheet(followupSheet)
|
| 418 |
workbook.save("crmacquisition.xls")
|
418 |
workbook.save("crmacquisition.xls")
|
| 419 |
sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "amit.sirohi@shop2020.in"], "", "CRM Acquision Report", "crmacquisition.xls")
|
419 |
sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com","khushal.bhatia@saholic.com", "amit.sirohi@shop2020.in"], "", "CRM Acquision Report", "crmacquisition.xls")
|
| 420 |
|
420 |
|
| 421 |
def sendmail(email, message, title, *varargs):
|
421 |
def sendmail(email, message, title, *varargs):
|
| 422 |
if email == "":
|
422 |
if email == "":
|
| 423 |
return
|
423 |
return
|
| 424 |
mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
|
424 |
mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
|