Styjun

How is the idea of "girlfriend material" naturally expressed in Russian?

Math symbols in math operators

What mathematical theory is required for high frequency trading?

How do I find which software is doing an SSH connection?

What is this airplane that sits in front of Barringer High School in Newark, NJ?

Is there a polite way to ask about one's ethnicity?

Synaptic Static - when to roll the d6?

How can I improve my violin intonation for enharmonic notes?

What kind of chart is this?

Why does a Force divides equally on a Multiple Support/Legs?

How can I take pictures like these examples with a yellowish tone and point & shoot film camera look?

How would you explain #1 and #2 below using standard quotes?

I just entered the USA without passport control at Atlanta airport

What is that ceiling compartment of a Boeing 737?

Can a character learn spells from someone else's spellbook and then sell it?

In Street Fighter, what does the M stand for in M Bison?

Does there exist a non-trivial group that is both perfect and complete?

What is the name of the person who reconciled a line from Rudram to dakshinamurthy and Adi Shankaracharya?

Scaling an object to change its key

How can I restore a master database from its bak file?

Leaving job close to major deadlines

Implementation of the Jacobi Symbol in C

Is declining an undergraduate award which causes me discomfort appropriate?

How to write a nice frame challenge?

How to fetch an attachment from Outlook Web App in Python

How can I represent an 'Enum' in Python?How do I copy a file in Python?How can I safely create a nested directory?How do I parse a string to a float or int?How to get the current time in PythonHow can I make a time delay in Python?How do I get the number of elements in a list?How do I concatenate two lists in Python?How do I lowercase a string in Python?How to remove a key from a Python dictionary?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

2

I want to download an excel attachment from MS Outlook Web App - https://webmail.xyz123.com.sg/owa/auth/logon.aspx?

I have a generic email ID to which my users will be sending source data in an excel format. I want to fetch that attachment with a particular subject and load that in my SQL server.

1. I cannot access this email ID from outlook desktop app as it is a generic email ID.


2. I don't have SMTP server details.


3. I do have credentials for this email ID

I tried some of the codes like below but all of them are trying to access Inbox folder (folder index = 6 ) to access emails, in my case that is not possible as I don't have this email ID's setup in desktop app.

from win32com.client import Dispatch
import datetime as date

outlook = Dispatch("Outlook.Application").GetNamespace("MAPI")
inbox = outlook.GetDefaultFolder("6")
all_inbox = inbox.Items
val_date = date.date.today()

I expect the output to be -

1. Access my generic email ID from Outlook web app


2. Download the excel attachment.

python python-3.x outlook-web-app

share|improve this question

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This might be helpful. github.com/O365/python-o365 .github.com/O365/python-o365/blob/master/O365/mailbox.py#L134 This method lets you download attachments. Or you can fetch already downloaded attachments from onedrive.
  
  – Nihal Sangeeth
  Mar 25 at 7:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for your comment. github.com/O365/python-o365 - this link asks me for client_secret which I cannot setup, and the other link doesn't seem to serve the purpose. Any other way to get this working? Thanks!
  
  – Sanket Kelkar
  Mar 26 at 7:55
  

  
  
  
  

add a comment | 

2

I want to download an excel attachment from MS Outlook Web App - https://webmail.xyz123.com.sg/owa/auth/logon.aspx?

I have a generic email ID to which my users will be sending source data in an excel format. I want to fetch that attachment with a particular subject and load that in my SQL server.

1. I cannot access this email ID from outlook desktop app as it is a generic email ID.


2. I don't have SMTP server details.


3. I do have credentials for this email ID

I tried some of the codes like below but all of them are trying to access Inbox folder (folder index = 6 ) to access emails, in my case that is not possible as I don't have this email ID's setup in desktop app.

from win32com.client import Dispatch
import datetime as date

outlook = Dispatch("Outlook.Application").GetNamespace("MAPI")
inbox = outlook.GetDefaultFolder("6")
all_inbox = inbox.Items
val_date = date.date.today()

I expect the output to be -

1. Access my generic email ID from Outlook web app


2. Download the excel attachment.

python python-3.x outlook-web-app

share|improve this question

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This might be helpful. github.com/O365/python-o365 .github.com/O365/python-o365/blob/master/O365/mailbox.py#L134 This method lets you download attachments. Or you can fetch already downloaded attachments from onedrive.
  
  – Nihal Sangeeth
  Mar 25 at 7:38
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for your comment. github.com/O365/python-o365 - this link asks me for client_secret which I cannot setup, and the other link doesn't seem to serve the purpose. Any other way to get this working? Thanks!
  
  – Sanket Kelkar
  Mar 26 at 7:55
  

  
  
  
  

add a comment | 

I want to download an excel attachment from MS Outlook Web App - https://webmail.xyz123.com.sg/owa/auth/logon.aspx?

I have a generic email ID to which my users will be sending source data in an excel format. I want to fetch that attachment with a particular subject and load that in my SQL server.

1. I cannot access this email ID from outlook desktop app as it is a generic email ID.


2. I don't have SMTP server details.


3. I do have credentials for this email ID

I tried some of the codes like below but all of them are trying to access Inbox folder (folder index = 6 ) to access emails, in my case that is not possible as I don't have this email ID's setup in desktop app.

from win32com.client import Dispatch
import datetime as date

outlook = Dispatch("Outlook.Application").GetNamespace("MAPI")
inbox = outlook.GetDefaultFolder("6")
all_inbox = inbox.Items
val_date = date.date.today()

I expect the output to be -

1. Access my generic email ID from Outlook web app


2. Download the excel attachment.

python python-3.x outlook-web-app

share|improve this question

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183

from win32com.client import Dispatch
import datetime as date

outlook = Dispatch("Outlook.Application").GetNamespace("MAPI")
inbox = outlook.GetDefaultFolder("6")
all_inbox = inbox.Items
val_date = date.date.today()

share|improve this question

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183

share|improve this question

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183

asked Mar 25 at 5:56

Sanket KelkarSanket Kelkar

183