Scribd
Upload
3 views2 pages

Python Automatiion

This document is a Python script that sends personalized emails to customers using the Gmail SMTP server. It reads customer data from an Excel file, constructs a message for each customer, and sends it while handling potential errors. The script includes a delay between emails to avoid being flagged as spam.

Uploaded by

mahmoudammar1221
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views2 pages

Python Automatiion

This document is a Python script that sends personalized emails to customers using the Gmail SMTP server. It reads customer data from an Excel file, constructs a message for each customer, and sends it while handling potential errors. The script includes a delay between emails to avoid being flagged as spam.

Uploaded by

mahmoudammar1221
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

import smtplib​

import time​
from [Link] import MIMEMultipart​
from [Link] import MIMEText​
import pandas as pd​
​
# 1...Server setup and email data​
SMTP_SERVER = "[Link]" ​
SMTP_PORT = 587​
SENDER_EMAIL = "@[Link]"​
SENDER_PASSWORD = "" ​
​
# 2.....Read data file​
​
file_path = "real_em.xlsx"​
df = pd.read_excel(file_path)​
​
# 3...email server connection​
try:​
server = [Link](SMTP_SERVER, SMTP_PORT)​
[Link]() ​
[Link](SENDER_EMAIL, SENDER_PASSWORD)​
print("Successfully connected to the SMTP server. Starting to send
emails...\n")​
​
# 4...Going through the customer row row​
for index, row in [Link]():​
customer_name = row["Customer_Name"]​
customer_email = row["Customer_Email"]​
segment = row["Customer_Segment"]​
​
# Message text​
subject = f"We miss you, {customer_name}! Special offer inside"​
​
body = f"""Hi {customer_name},​
​
We noticed it's been a while since your last order with us. As one of
our valued customers,​
we truly miss having you around.​
​
We would love to welcome you back! Use the coupon code 'WELCOMEBACK10'
to get 10% off on your next purchase.​
​
Best regards,​
Your Company Team​
"""​
​
##Email structure​
msg = MIMEMultipart()​
msg["From"] = SENDER_EMAIL​
msg["To"] = customer_email​
msg["Subject"] = subject​
[Link](MIMEText(body, "plain"))​

✔️🚀🚀🚀👌😊
​
#Send email ​
[Link](SENDER_EMAIL, customer_email, msg.as_string())​
print(f"[{index + 1}/{len(df)}] Email sent successfully to
{customer_name} ({customer_email})")​
​
​
[Link](3)​
​
except Exception as e:​
print(f"An error occurred: {e}")​
​
finally:​
​
[Link]()​
print("\nAll emails processed. Connection closed cleanly.")​

You might also like