Bulk email sender from CSV with Python
Level: Real-World Project
Project Description
In today’s real-world Python project, you’ll build a Bulk Email Sender — a script that reads email addresses and names from a CSV file and sends personalized emails to each person using Python’s built-in csv and smtplib modules.
This is incredibly useful in real life — from sending newsletters and promotional updates, to internal announcements or even school-wide messages. No more copy-pasting emails manually!
Here’s what your app should do:
Load recipient data from a CSV file like
recipients.csv, which contains emails and names.Compose a personalized message for each contact (e.g., "Hi Alice...").
Send the email using your Gmail or Outlook account.
Print a confirmation that each message was sent.
By completing this project, you'll learn:
How to send real emails from Python
How to personalize those messages using CSV data
How to use SMTP with
smtplibAnd how to safely use app passwords for Gmail and Outlook accounts
Sample recipients.csv File
Create an empty file in your computer, paste the following data, and save the file under the recipients.csv name. Make sure to place some real email addresses there.
email,name
alice@example.com,Alice
bob@example.com,Bob
carol@example.com,CarolExpected Output
💡 Hint
Need help figuring out how to read the CSV and send emails? Click the hint button below for a preview of the key functions and how to use an app password.
📨 Hint includes help with csv.DictReader, smtplib, and creating an email.mime message.
𝌣 Solution
🔒 This solution is available to paid subscribers only.
🧠 Includes complete code, sample CSV, and instructions on getting Gmail or Outlook app passwords.
🚀 Want to keep leveling up?
Browse 200+ projects at dailypythonprojects.substack.com/archive and unlock all solutions by subscribing. Build real Python skills daily and transform how you learn — one project at a time.