Automated Email Sender from CSV or Excel File

import os
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
import openpyxl

# Function to send an email
def send_email(subject, body, to_email, smtp_server, smtp_port, smtp_username, smtp_password, from_email, encryption):
    msg = MIMEMultipart()
    msg['From'] = from_email
    msg['To'] = to_email
    msg['Subject'] = subject

    msg.attach(MIMEText(body, 'plain'))

    if encryption.lower() == 'starttls':
        server = smtplib.SMTP(smtp_server, smtp_port)
        server.ehlo()
        server.starttls()
    elif encryption.lower() == 'ssl/tls':
        server = smtplib.SMTP_SSL(smtp_server, smtp_port)
    else:
        print("Unsupported encryption type. Exiting.")
        return

    server.ehlo()
    server.login(smtp_username, smtp_password)
    server.sendmail(from_email, to_email, msg.as_string())
    server.quit()

# Function to process and delete data file (either CSV or Excel)
def process_and_delete_data(file_path, smtp_server, smtp_port, smtp_username, smtp_password, from_email):
    _, file_extension = os.path.splitext(file_path)

    if file_extension.lower() == '.csv':
        delimiter = ';'
        import_module = lambda: __import__('csv')
    elif file_extension.lower() == '.xlsx':
        import_module = lambda: __import__('openpyxl')
    else:
        print(f"Unsupported file format: {file_extension}. Exiting.")
        return

    try:
        data_module = import_module()
    except ImportError:
        print(f"Could not import the required module for {file_extension}. Exiting.")
        return

    with open(file_path, 'r', newline='', encoding='utf-8') as file:
        if file_extension.lower() == '.csv':
            csv_reader = data_module.DictReader(file, delimiter=delimiter)
        elif file_extension.lower() == '.xlsx':
            wb = data_module.load_workbook(file_path)
            sheet = wb.active

            # Get user input for column names
            columns_input = input("Enter the column names you want to use (comma-separated): ")
            columns = [col.strip() for col in columns_input.split(',')]

            # Warn the user about column name format
            print("Warning: Column names should not have spaces and should match exactly with the names in CSV/XLSX.")
            print("Example format: Column1,Column2,Column3")

            csv_reader = [dict(zip(columns, row)) for row in sheet.iter_rows(values_only=True)]

    for row in csv_reader:
        to_email = input("Enter the destination email address: ")  # Send all emails to user-specified address

        # Get user input for the subject columns
        subject_columns_input = input("Enter the columns you want to use in the subject (comma-separated): ")
        subject_columns = [col.strip() for col in subject_columns_input.split(',')]

        # Build the subject based on user input columns
        subject = ' '.join([row[col] for col in subject_columns])

        body = ''
        for col, value in row.items():
            body += f"{col}: {value}\n"

        # Get user input for encryption type
        encryption = input("Enter the encryption type (STARTTLS, SSL/TLS, etc.): ")

        try:
            send_email(subject, body, to_email, smtp_server, smtp_port, smtp_username, smtp_password, from_email, encryption)
            print(f"Email sent to {to_email}")
        except Exception as e:
            print(f"Failed to send email: {str(e)}")

    # Delete the processed data file
    os.remove(file_path)
    print(f"Data file deleted: {file_path}")

# Get user input for SMTP and email details
smtp_server = input("Enter the SMTP server: ")
smtp_port = int(input("Enter the SMTP server port: "))
smtp_username = input("Enter the SMTP username: ")
smtp_password = input("Enter the SMTP password: ")
from_email = input("Enter the source email address: ")

# Get user input for the data file path
data_file_path = input("Enter the path of the CSV or Excel file: ")

# Process the data file
process_and_delete_data(data_file_path, smtp_server, smtp_port, smtp_username, smtp_password, from_email)

print("All emails sent and data file processed and deleted successfully.")

pip install smtplib openpyxl

cd /path/to/your/script

python sendmail.py

Enter the SMTP server: mail.example.com
Enter the SMTP server port: 587
Enter the SMTP username: your_username@example.com
Enter the SMTP password: your_password
Enter the source email address: noreply@example.com
Enter the path of the CSV or Excel file: /path/to/your/data.csv
Enter the destination email address: info@example.com
Enter the columns you want to use in the subject (comma-separated): IP,Severity,NVT Name
Enter the encryption type (STARTTLS, SSL/TLS, etc.): STARTTLS

Email sent to info@example.com
Data file deleted: /path/to/your/data.csv

All emails sent and data file processed and deleted successfully.