Python — Send Email Using SMTP

Create an SMTP object to connect to the server.
Log in to your account.
Define your message header and your login credentials.
Create a MIMEMultipart object and associate the relevant header with it - example: From:, To:, and Subject.
Associate a message with the MIMEMultipart message object.
Finally, send the message.

import smtplib

server = smtplib.SMTP('<mensager.of.your.cia>', 25)
server.starttls()
server.login("<Your-email>", "<Your-password>")

Out[1]:

(235, b'2.7.0 Authentication successful')

msg = "Testing SMTP EMAIL "
server.sendmail("<Your-email>", "<Other-email>", msg)
server.quit()

# Using PANDAS

import pandas as pd
list_table = pd.read_excel('email_schedule_table.xlsx')
display(list_table)

# Import smtplib for the actual sending function
import smtplib
import os

base_path = "<to.readme.file>"
filename = "readme"
path_to_file = os.path.join(base_path, filename)

# Import the email modules we'll need
from email.message import EmailMessage

# Open the plain text file whose name is in textfile for reading.
with open(path_to_file, 'r') as fp:
    # Create a text/plain message
    msg = EmailMessage()
    msg.set_content(fp.read())

# me == the sender's email address
# you == the recipient's email address

msg['Subject'] = f'The contents of {textfile}'
msg['From'] = '<your_email>'
msg['To'] = '<another_email>'

# Send the message via our own SMTP server.
s = smtplib.SMTP('<mensager.of.your.cia>')
s.send_message(msg)
s.quit()

# Import smtplib for the actual sending function

import smtplib
from datetime import datetime

# Import the email modules we'll need

from email.message import EmailMessage
server = smtplib.SMTP('<mensager.of.your.cia>')

for i, email in enumerate(admin_df['Email']):
   Responsavel = admin_df.loc[i, 'Responsible']
   IP = admin_df.loc[i, 'IP']
   Intimation = admin_df.loc[i, 'Intimation']
   Default = admin_df.loc[i, 'Default']
   CNPJ = admin_df.loc[i, 'CNPJ']
   msg = EmailMessage()
   
   body = f"""\
   To{IP} - N°: {CNPJ}
   {Responsible}

   Dear Administrator - DIMP (Declaration of Means of Payments) -    
   Public Sector:

   We request the (re)transmission of DIMP files related to the
     period(s) recorded below (month/year):

    {Default.split(';')}

    Motivations:

   EXCLUSIVELY FOR UPDATING AND UPDATING PURPOSES IN THE 
   INSTITUTIONAL DATABASE OF THIS CIA; PLEASE SEND ALL    
   FILES WITH NORMAL PURPOSE.

   Thank you.

   Sincerely,

   ------------------------
   <your_name>
   <your_title>
   <your_sector>
   EMAIL: <your_email>
   TEL: <your_contact>

   ------------------- """

msg.set_content(body)

# me == the sender's email address
# you == the recipient's email address

msg['Subject'] = f" Report of Omissions DA {IP} - {CNPJ} - FOR FINANCE CIA - AT - Request No. {Intimation} "

msg['From'] = '<your_email>'
msg['To'] = email

# Send the message via our own SMTP server.
#server = smtplib.SMTP('<mensager.of.your.cia>')

print("Email successfully sent!")

Email successfully sent!!