Sending Multiple Emails From a CSV File

import email, smtplib, ssl, csv

from email import encoders
from email.mime.base import MIMEBase
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

subject = "An email with attachment from Python"
body = "This is an email with attachment sent from Python"
sender_email = "generic@blah.com"
#receiver_email = ""


# Create a multipart message and set headers
message = MIMEMultipart()
message["From"] = sender_email
message["To"] = receiver_email
message["Subject"] = subject
message["Bcc"] = receiver_email  # Recommended for mass emails

# Add body to email
message.attach(MIMEText(body, "plain"))

filename = "test.xlsx"  # In same directory as script

# Open PDF file in binary mode
with open(filename, "rb") as attachment:
    # Add file as application/octet-stream
    # Email client can usually download this automatically as attachment
    part = MIMEBase("application", "octet-stream")
    part.set_payload(attachment.read())

# Encode file in ASCII characters to send by email    
encoders.encode_base64(part)

# Add header as key/value pair to attachment part
part.add_header(
    "Content-Disposition",
    f"attachment; filename= {filename}",
)

# Add attachment to message and convert message to string
message.attach(part)
text = message.as_string()

# Log in to server using secure context and send email

#with smtplib.SMTP("mailhost:25") as server:
    #server.sendmail(sender_email, receiver_email, text)

with smtplib.SMTP("mailhost:25") as server:
    with open("contacts_file.csv") as file:
        reader = csv.reader(file)
        next(reader)  # Skip header row
        for name, email, grade in reader:
            server.sendmail(
                sender_email,
                email,text
                #message.format(name=name,grade=grade),
            )

Traceback (most recent call last):
  File "/home/abbyrjones72/Documents/remote_repos/emailer/email.py", line 1, in <module>
    import smtplib, ssl
  File "/home/abbyrjones72/anaconda3/lib/python3.7/smtplib.py", line 47, in <module>
    import email.utils
  File "/home/abbyrjones72/Documents/remote_repos/emailer/email.py", line 17, in <module>
    with smtplib.SMTP_SSL("stmp.gmail.com", 465, context=context) as server:
AttributeError: module 'smtplib' has no attribute 'SMTP_SSL'

import smtplib, ssl
import csv


message = """\
    From: {sender}
    To: {email}
    Subject: Your Grades

    Hi {name}, your grade is {grade}.

    """
sender = "abbyrjones72dev@gmail.com"
password = input("Please enter a password: ")
context = ssl.create_default_context()

with smtplib.SMTP_SSL("stmp.gmail.com", 465, context=context) as server:
    server.login(sender, password)
    with open("contacts.csv") as file:
        reader = csv.reader(file)
        # skip first header row
        next(reader)
        for name, email, grade in reader:
            server.sendmail(
                sender,
                email,
                message.format(sender=sender, email=email, name=name, grade=grade),
            )

import email, smtplib, ssl, csv

from email import encoders
from email.mime.base import MIMEBase
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

from_address = ""


with smtplib.SMTP("mailhost:25") as server:
    with open("contacts_file.csv") as file:
            reader = csv.reader(file)
            next(reader)  # Skip header row
            for name, subject_line, body, email, grade, attach in reader:

                # Create a multipart message and set headers
                message = MIMEMultipart()
                message["From"] = from_address
                message["To"] = email
                message["Subject"] = subject_line

                filename = str(attach)

                # Add body to email
                message.attach(MIMEText(body, "plain"))

                with open(filename, "rb") as attachment:
                    # Add file as application/octet-stream
                    # Email client can usually download this automatically as attachment
                    part = MIMEBase("application", "octet-stream")
                    part.set_payload(attachment.read())  

                    # Encode file in ASCII characters to send by email    
                    encoders.encode_base64(part)

                    # Add header as key/value pair to attachment part
                    part.add_header(
                    "Content-Disposition",f"attachment; filename= {filename}",)

                # Add attachment to message and convert message to string
                message.attach(part)
                text = message.as_string()

                # Use server to send email
                server.sendmail(from_address, email, text)