import pandas as pd
import smtplib


df = pd.read_csv('file.csv')

df['Shipping Tier'] = df['2day ship']
df['Capacity'] = df['Planned Capacity']
df['Max Date'] = df['Date']

df2 = df[['Distributor ID','Distributor Name', 'Shipping Tier','Capacity', 'Max Date']]

smtpObj = smtplib.SMTP('smtp-mail.outlook.com', 587)
type(smtpObj

smtpObj.starttls()
smtpObj.login('myemail, 'pw')

##vendors = df['Distributor ID']
emails = df['Email'].tolist()
##emailAndVendors = []


for i in range(len(emails)):
    FROM = 'myemail'
    TO = str(emails)
    SUBJECT = 'subject'
    TEXT = '''Hello DSV Partner,\n\nYou have consumed your daily capacity which could push out customer promise dates and negatively affect sales.




'''

    message = """\
    From: %s
    To: %s
    Subject: %s

    %s
    """ % (FROM, TO, SUBJECT, TEXT)

    smtpObj.sendmail(FROM, TO, message)