Justin Napolitano

A simple Python-based mail merge utility designed to send personalized emails to multiple recipients using a CSV database and a text template. This project demonstrates basic email automation leveraging SMTP and templating techniques.

Features

Reads recipient data from a CSV file
Uses a text template with placeholders for personalization
Sends emails via SMTP with TLS encryption
Simple configuration for SMTP server and credentials

Tech Stack

Python 3
Standard libraries: csv, smtplib, ssl

Getting Started

Prerequisites

Python 3 installed
Access to an SMTP server (e.g., Office365 SMTP)

Installation

Clone the repository:

git clone https://github.com/justin-napolitano/mailmerge.git
cd mailmerge

Configuration

Update SMTP login credentials in TestScript.py:
- login with your SMTP username
- password with your SMTP password
Ensure mailmerge_database.csv contains your recipient data
Customize the email template in mailmerge_template.txt as needed

Running

Run the test script to send emails:

python TestScript.py

Project Structure

mailmerge/
├── mailmerge_database.csv    # CSV file containing recipient data
├── mailmerge_server.conf     # SMTP server configuration (not used in script)
├── mailmerge_template.txt    # Email template with placeholders
├── README.md                 # Project documentation
└── TestScript.py             # Python script to send emails

Future Work / Roadmap

Externalize configuration (SMTP credentials, server settings) to a config file
Implement template rendering using a dedicated templating engine (e.g., Jinja2)
Add error handling and logging for failed email sends
Support HTML email templates
Create a command-line interface for flexibility
Secure sensitive information such as passwords