python email merge

What it does

1. Reads data from a CSV file.
2. Replaces placeholders in the email text and subject line with corresponding data from the CSV file.
3. Sends each customized email through Microsoft Outlook.

How it works

Replace 'your_file.csv', standard_email_text, and standard_subject with your actual file path and text. The script reads the CSV file, replaces placeholders in the email text and subject line with the corresponding data, and sends the emails.

What you need

• You need to have Microsoft Outlook installed on your system.
• This script assumes the CSV file is well-formed and the headers match the placeholders.
• Python's win32com.client library is used for interacting with Outlook, which is Windows-specific.

Script

import csv
import win32com.client as win32

# Define your standard email text and subject line here
standard_email_text = "Hello _name_,\n\nPlease check this URL: _URL_.\nBest regards."
standard_subject = "Information for _name_"

# Function to send email via Outlook
def send_email(recipient, subject, body):
    outlook = win32.Dispatch('outlook.application')
    mail = outlook.CreateItem(0)
    mail.To = recipient
    mail.Subject = subject
    mail.Body = body
    mail.Send()

# Reading CSV and sending emails
with open('your_file.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        email_body = standard_email_text
        email_subject = standard_subject

        # Replace placeholders in the email text and subject
        for key in row:
            email_body = email_body.replace(f'_{key}_', row[key])
            email_subject = email_subject.replace(f'_{key}_', row[key])

        # Send the email
        send_email(row['email'], email_subject, email_body)