Amazing-Python-Scripts

1
from email.mime.text import MIMEText
2
from email.mime.multipart import MIMEMultipart
3
import xlrd
4
import time
5
import smtplib
6

7
path = "selects.xlsx"
8
File = xlrd.open_workbook(path)
9
sheet = File.sheet_by_name('Selects')
10

11
mail_list = []
12
interviewerlist = []
13
name = []
14
for k in range(sheet.nrows - 1):
15
    student = sheet.cell_value(k + 1, 0)
16
    email = sheet.cell_value(k + 1, 1)
17
    passed = sheet.cell_value(k + 1, 3)
18
    interviewer = sheet.cell_value(k + 1, 4)
19
    if passed == 'Yes':
20
        mail_list.append(email)
21
        interviewerlist.append(interviewer)
22
        name.append(student)
23

24
email = 'example@gmail.com'  # add the sender's email address
25
password = '*****'  # sender's password
26
server = smtplib.SMTP('smtp.gmail.com', 587)
27
server.starttls()
28
server.login(email, password)
29

30
for mail_to in mail_list:
31
    send_to_email = mail_to
32
    find_des = mail_list.index(send_to_email)
33
    studentName = name[find_des]
34
    subject = f'Congratulations {studentName}!! You are selected for further interviews.'
35
    message = f'Dear {studentName}, \n' \
36
              f'We inform you that you wil be interviewed by ${interviewerlist[find_des]}. Please wait for the concern mail from your interviewer. \n'\
37
              '\n' \
38
              'Best Regards'
39

40
    msg = MIMEMultipart()
41
    msg['From '] = send_to_email
42
    msg['Subject'] = subject
43
    msg.attach(MIMEText(message, 'plain'))
44
    text = msg.as_string()
45
    print(f'Sending email to {studentName}... ')
46
    server.sendmail(email, send_to_email, text)
47

48
server.quit()
49
print('Mails sent!')
50
time.sleep(10)
51