
%%file outlook.py

"""all about outlook and python

create virtual environment with name pywinservices

python -m venv pywinservices

activate it using

\pywinservices\Scripts\activate.bat

after activation install following packages

pip install pypiwin32 

following code makes use of MAPI api provided by microsoft
for more advanced cases refer 

https://docs.microsoft.com/en-us/office/client-developer/outlook/outlook-home

"""
import datetime
import os
import win32com.client


def get_outlook():
    return win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI")


def get_inbox(email=None):
    outlook = get_outlook()
    if email == None:
        inbox = outlook.GetDefaultFolder(6)  # this works
    else:
        inbox = outlook.Folders.Items(email).Folders.Items('Inbox')
        # inbox1 = outlook.Folders.Items('123@abc.com').Folders.Items('Inbox') # To access 123@abc.com Inbox
        # inbox2 = outlook.Folders.Items('456@def.com').Folders.Itmes('Inbox') # To access 456@def.com Inbox
    return inbox


def get_default_inbox_messages():
    inbox = get_inbox()
    messages = inbox.Items
    return messages


def saveattachemnts_from_email(subject):
    """saves attachment from email that matches with subject
    """
    messages = get_default_inbox_messages()
    path = os.path.expanduser("~/Desktop/Attachments")
    today = datetime.date.today()

    for message in messages:
        if message.Subject == subject and message.Unread or message.Senton.date() == today:
            # body_content = message.body
            attachments = message.Attachments
            attachment = attachments.Item(1)
            for attachment in message.Attachments:
                attachment.SaveAsFile(os.path.join(path, str(attachment)))
                if message.Subject == subject and message.Unread:
                    message.Unread = False
                break


# print first 3 emails from ...
def print_emails(folderindex: int = 6, emailcount: int = 3):
    """
    folderindex 3, 4, 5, 6 ..Trash, Outbox, Sent, Inbox 
    """                                                    # folders,and emailcount,
    # try different numbers
    messages = get_default_inbox_messages()
    for i in range(emailcount):
        message = messages[i]
        print(message.Subject)
        # this body of message can be parsed to extract table
        print(message.Body)
        print("="*30)


def send_email_with_attachment():
    import win32com.client as win32
    outlook = win32.Dispatch('outlook.application')
    mail = outlook.CreateItem(0)
    mail.To = 'To address'
    mail.Subject = 'Message subject'
    mail.Body = 'Message body'
    mail.HTMLBody = '<h2>HTML Message body</h2>'  # this field is optional

    # To attach a file to the email (optional):
    attachment = "Path to the attachment"
    mail.Attachments.Add(attachment)

    mail.Send()

Writing outlook.py


import json


pydict = {"function":"CURRENCY_EXCHANGE",
         "from_currency":"BTC",
         "to_currency":"USD"}


pydict['function']

'CURRENCY_EXCHANGE'


json.dumps(pydict) # this is json data string

'{"function": "CURRENCY_EXCHANGE", "from_currency": "BTC", "to_currency": "USD"}'


d = {"a":{"a":34},
"b":[1, 2, 3, 4, 4],
"c":[{"one":1},{"two":2},{"three":3}]}


json.dumps(d)

'{"a": {"a": 34}, "b": [1, 2, 3, 4, 4], "c": [{"one": 1}, {"two": 2}, {"three": 3}]}'


jsonstring = '{"a": {"a": 34}, "b": [1, 2, 3, 4, 4], "c": [{"one": 1}, {"two": 2}, {"three": 3}]}'


json.loads(jsonstring)

{'a': {'a': 34},
 'b': [1, 2, 3, 4, 4],
 'c': [{'one': 1}, {'two': 2}, {'three': 3}]}


import requests


resp.status_code # 200 anything is ok, 400 or 500 anything is error

200


data = resp.json() # i know before hand from documenation that this url resturn json data


data

{'Realtime Currency Exchange Rate': {'1. From_Currency Code': 'BTC',
  '2. From_Currency Name': 'Bitcoin',
  '3. To_Currency Code': 'CNY',
  '4. To_Currency Name': 'Chinese Yuan',
  '5. Exchange Rate': '388162.05040200',
  '6. Last Refreshed': '2021-10-27 06:24:07',
  '7. Time Zone': 'UTC',
  '8. Bid Price': '388162.05040200',
  '9. Ask Price': '388162.11424900'}}


data['Realtime Currency Exchange Rate']

{'1. From_Currency Code': 'BTC',
 '2. From_Currency Name': 'Bitcoin',
 '3. To_Currency Code': 'CNY',
 '4. To_Currency Name': 'Chinese Yuan',
 '5. Exchange Rate': '388162.05040200',
 '6. Last Refreshed': '2021-10-27 06:24:07',
 '7. Time Zone': 'UTC',
 '8. Bid Price': '388162.05040200',
 '9. Ask Price': '388162.11424900'}


data['Realtime Currency Exchange Rate']['5. Exchange Rate']

'388162.05040200'


def exchange_rate(from_, to_):
    url = "https://www.alphavantage.co/query"
    params = {"function":"CURRENCY_EXCHANGE_RATE",
          "from_currency":from_,
          "to_currency":to_,
          "apikey":"UKVEF0JLE0TBPDEF"}

    resp = requests.get(url,params=params)
    return resp.json()['Realtime Currency Exchange Rate']['5. Exchange Rate']


exchange_rate("BTC","USD")

'60920.01000000'


exchange_rate("BTC","INR")

'4562568.29632000'

Python Virtual Training For Arcesium - Module III¶

virtual environment¶

Summary¶

reading emails from outlook¶

Downloading data from internet¶

Before we download data¶