FilesExpand file tree

master

/

sendDuesReminders.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

36 lines (29 loc) · 1.32 KB

master

/

sendDuesReminders.py

Copy path

Top

File metadata and controls

• Code
• Blame

36 lines (29 loc) · 1.32 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

#! python3

# sendDuesReminders.py - Sends emails based on their status in spreadsheet.

import openpyxl, smtplib, sys

# Open the spreadsheet and get the latest dues status.

wb = openpyxl.load_workbook('duesRecords.xlsx')

sheet = wb.get_sheet_by_name('Sheet1')

lastCol = sheet.get_highest_column()

latestMonth = sheet.cell(row=1, column=lastCol).value

unpaidMembers = {}

# Check each member's payment status

for r in range(2, sheet.get_highest_row() + 1):

payment = sheet.cell(row=r, column=lastCol).value

if payment != 'paid':

name = sheet.cell(row=r, column=1).value

email = sheet.cell(row=r, column=2).value

unpaidMembers[name] = email

# Log in to email account.

smtpObj = smtplib.SMTP('smtp.gmail.com', 587)

smtpObj.ehlo()

smtpObj.starttls()

smtpObj.login('my_email_address@gmail.com', sys.argv[1])

# Send out reminder emails.

for name, email in unpaidMembers.items():

body = 'Subject: %s dues unpaid.\nDear %s,\nRecords show that you have not paid dues for %s. Please make this payment as soon as possible. Thank you!' % (latestMonth, name, latestMonth)

print('Sending email to %s...' % email)

sendmailStatus = smtpObj.sendmail('my_email_address@gmail.com', email, body)

if sendmailStatus != {}:

print('There was a problem sending email to %s: %s' % (email, sendmailStatus))

smtpObj.quit()