Extract email attachments from Outlook365 Group

Robert Randall 1 Reputation point
2022-04-21T13:23:54.077+00:00

Hello,

I'm supporting a client that has asked me to extract attachments from an employee's inbox and save those attachments to SharePoint. We've moved his emails to an Outlook 365 Group and from what I understand the browser version of Outlook 365 does not support VBA Editor. The instance of Outlook on my customer's computers is the 2013 version so although VBA Editor would be supported, that version of Outlook does not support Outlook 365 groups. Any suggestions on how to overcome this obstacle?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,267 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
942 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,068 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vasil Michev 100.1K Reputation points MVP
    2022-04-21T13:38:04.953+00:00

    Afaik there's no support for O365 Groups access via VBA anyway. So you'll need to use EWS or the Graph API.

    0 comments No comments

  2. Emily Du-MSFT 44,146 Reputation points Microsoft Vendor
    2022-04-22T07:04:57.11+00:00

    @Robert Randall

    You could save your email attachments into a SharePoint document library through Power Automate template. In this flow template, you should fill in the Folder in the On new email with attachment action, Site Address and Folder Path in the Create file action.

    References:

    https://www.c-sharpcorner.com/article/ms-flow-to-save-email-attachments-to-sharepoint-library/
    https://www.c-sharpcorner.com/blogs/how-save-my-email-attachments-to-a-sharepoint-document-library-using-ms-flow

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.