Amazing-Python-Scripts

1
import pandas as pd
2
import smtplib
3
from email.message import EmailMessage
4
import xlrd
5
import openpyxl
6
import time
7

8
# Variable Declarations
9
excelFile = "DemoExcelFile.xlsx"  # Email Data
10
emailID = "abc@gmail.com"  # Add MailID
11
pwd = "abc@7"  # Add PASSWORD
12
subject = "We're Back!, Walk With World KITCOEK"  # EMAIL SUBJECT
13
htmlfile_loc = "camp1.html"  # YOUR HTML FILE
14

15
# Reading File
16
file = pd.ExcelFile(excelFile, engine='openpyxl')
17

18
# Email Setup
19
s = smtplib.SMTP("smtp.gmail.com", 587)
20
s.starttls()  # Traffic encryption
21
s.login(emailID, pwd)  # SMTP Login
22
count = 0
23

24
for sheet in file.sheet_names:
25
    print("\n\n<-- New Sheet -->\n")
26
    df1 = file.parse(sheet)
27
    for i in range(len(df1['EMAIL'])):
28

29
        with open(htmlfile_loc, 'r', encoding='utf8') as file:
30
            html_Content = str(file.read())
31
        msg = EmailMessage()
32
        msg['Subject'] = subject
33
        msg['From'] = emailID
34
        msg['To'] = df1['EMAIL'][i]
35
        msg.add_alternative(html_Content, subtype="html")
36
        s.send_message(msg)
37
        count += 1
38
        print(">>> ", df1['SRNO'][i], ": ", df1['EMAIL'][i], " : Sent")
39
        if (count % 60 == 0):
40
            print("\n\n <<>> Server CoolDown for 60 seconds <<>>\n\n")
41
            time.sleep(10)
42

43
s.quit()
44
print("\n\n <<:>> All Emails Sent <<:>>\n\n")
45