Mail List

  

 import csv

import smtplib

from email.mime.text import MIMEText

# Define the email parameters

sender_email = 'your_email@example.com'

sender_password = 'your_email_password'

subject = 'Update your password'

message_template = '''\

Dear {name},

Please update your password for our service. You can do this by logging into your account and changing your password.

Thank you,

The Service Team

'''

# Read the CSV file and send an email to each user

with open('user_data.csv') as file:

   reader = csv.reader(file)

   next(reader)  # Skip header row

   for row in reader:

       # Extract user data

       name, email = row

       # Create the email message

       message = message_template.format(name=name)

       email_message = MIMEText(message)

       email_message['Subject'] = subject

       email_message['From'] = sender_email

       email_message['To'] = email

       # Connect to the SMTP server and send the email

       with smtplib.SMTP('smtp.gmail.com', 587) as server:

           server.starttls()

           server.login(sender_email, sender_password)

           server.sendmail(sender_email, email, email_message.as_string())

       print(f'Sent email to {name} ({email})')