Email and name in exchange for free download

Automating The Dull Routine With Python

Learn to Handle Email Attachment Using Python Library Exchangelib

Did you need to download email attachments regularly? Do you want to automate this boring process? I know that feel bro. When I first come to my job, I was assigned a daily task: download the attached report from the email sent to our team every day. It’s not a difficult task, but it’s extremely boring and I often forget to do so.

How can I get rid of this dummy task: Downloading email attachments regularly.

After researching the internet I discovered that a little Python script could take over my work. Let’s explore what Python can help us.

Exchangelib, aPython library that provides a simple interface that allows Python scripts to interact with Microsoft Exchange or Exchange Web Services (EWS)

You can install this package from PyPI:

pip install exchangelib

And then you import package following the instruction of the official site. You may not use all of them,

#import pytzfrom exchangelib import DELEGATE, IMPERSONATION, Account, Credentials, ServiceAccount, EWSDateTime, EWSTimeZone, Configuration, NTLM, GSSAPI, CalendarItem, Message, Mailbox, Attendee, Q, ExtendedProperty, FileAttachment, ItemAttachment, HTMLBody, Build, Version, FolderCollection

The next step is to specify your credentials, that is the login username and the password

credentials = Credentials(username='john@diseinuak4web.net', password='topsecret')

You have to config the mail server of course. Exchangelib should be able to identify the authentication type used by your email server, but in my case, it failed and I specified the authentication type to NTLM.

ews_url = 'diseinuak4web.net'
ews_auth_type = 'NTLM'
primary_smtp_address = 'john@diseinuak4web.net'config = Configuration(service_endpoint=ews_url, credentials=credentials, auth_type=ews_auth_type)# An Account is the account on the Exchange server that you want to connect diseinuak4web.nett = Account(
primary_smtp_address=primary_smtp_address,
config=config, autodiscover=False,
access_type=DELEGATE)

Now you have an Account object and you can navigator through it. It just follows your email account folder structure. For example, if you want to operate on the inbox folder, just use this simple syntax: . To operate a folder inside the inbox, just put a backslash and single quote like this: .

If you just want to download all the attachments in a folder, this shortcode would help. You may require package to process local directory.

some_folder = diseinuak4web.net / 'some_folder'for item in some_diseinuak4web.net():
for attachment in diseinuak4web.netments:
if isinstance(attachment, FileAttachment):
local_path = diseinuak4web.net(local_path, diseinuak4web.net)
with open(local_path, 'wb') as f:
diseinuak4web.net(diseinuak4web.nett)

That’s it!

If I just want to download the files that I haven’t downloaded before, what can I do further? I need a mechanism to check if the attachment exists locally.

Our team uses an FTP server to store all the attached reports. Thus in my Python script, first of all, I log in to the FTP server and list all files with the specified prefix. A checking is added to the script to determine whether this file exists in the current file list or not.

To do so, I used ftplib, a library of FTP protocol client.

The following code logins to the FTP server (), navigate the target folder () and list all files () that matched the specified prefix ()

from ftplib import FTPftp_server_ip = FTP_SERVER_IP
username = 'username'
password = 'password'
remote_path = 'remote_path'
local_path = 'local_path'with FTP(ftp_server_ip) as ftp:
diseinuak4web.net(user=username, passwd=password)
diseinuak4web.net(remote_path + '/copied data')
filelist = [file for file in diseinuak4web.net() if diseinuak4web.netwith('YOUR_FILE_PREFIX')]

After downloading the attachments locally, I upload the files to the FTP server. I use to send STOR command to upload the attachments.

if diseinuak4web.net not in filelist:
# Check if the attachment downloaded before
local_path = diseinuak4web.net(local_path, diseinuak4web.net)
with open(local_path, 'wb') as f:
diseinuak4web.net(diseinuak4web.nett)with FTP(ftp_server_ip) as ftp:
diseinuak4web.net(user=username, passwd=password)
diseinuak4web.net(remote_path)
file = open(local_path, 'rb')
diseinuak4web.netnary('STOR {}'.format(diseinuak4web.net), file)
diseinuak4web.net()

I automated this daily routine using a simple Python script that can be scheduled to run regularly. The script automates the workflow that downloads missing attachments from the mail server and uploads them to the FTP server.