Create dataframe from Excel attachment in Outlook
Attachments are MIME-encoded and have to be decoded back into the original format (which essentially means making a disk copy) for programs that are expecting that format.
What you want is to give pandas the identifier of the email, the name of the attachment, the details of the message store, and suitable authentication, and have pandas read the attachment directly. This would entail extending the function pandas.read_csv() or maybe adding a new function read_csv_attachment(). 
While I am sure this is possible, it is a more ambitious project than I (as one unfamiliar with pandas internals) would want to tackle myself. And certainly much more work than saving the attachments manually, unless you have thousands of them.
Is it possible to read an Excel file from an Outlook attachment without saving it, and return a pandas dataframe from the attached file? The file will always be in the same format.