python create outlook email with attachment

In pandas, the way to read columns is to access them as follows. We are going to be reading the spreadsheet using pandas and storing the result in a data frame email_list email_list = pd.read_excel('EmailList.xlsx') Get all the Values from the File Server = smtplib.SMTP_SSL('', 465) server.ehlo() server.login(your_email, your_password) Read the File

For example, if you are using gmail you must allow your gmail account access to a less secure app.

Depending on your email provider security setting, the login in line 15 might error out this script.

Here is a list of some smtp values based on your email provider

If you are sending the emails from any other email besides gmail, then you should change the ‘’ in line 13 to the email provider you are using.

There are two crucial things to watch out for here: We are going to set up the smtp server for Gmail.

These are fake obviously :) Change these to your email credentials your_name = 'Bill Butlicker' your_email = ' your_password = 'bearsbeetsbattlestar' Set Up the Email Server to Send the Email smptlib comes pre installed so you don’t need to do anything but if you haven’t installed pandas then once again go through this tutorial: Intro to Reading and Writing Spreadsheets with Python Specify Your Credentials Import both pandas and smtplib to read spreadsheets and send emails respectively. Save this in the same folder as the sample excel file. Open a text editor and create a file email_send.py.

Python create outlook email with attachment