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?

Microsoft 365 and Office | Development | Office JavaScript API
Outlook | Windows | Classic Outlook for Windows | For business
Microsoft 365 and Office | SharePoint | For business | Windows
Developer technologies | Visual Basic for Applications
{count} votes

2 answers

Sort by: Most helpful
  1. Vasil Michev 119.7K Reputation points MVP Volunteer Moderator
    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 51,846 Reputation points Microsoft External Staff
    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.