{"id":11380,"date":"2025-06-19T13:19:00","date_gmt":"2025-06-19T13:19:00","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=11380"},"modified":"2026-03-19T23:07:21","modified_gmt":"2026-03-19T23:07:21","slug":"how-to-download-outlook-office-365-emails-as-eml-or-msg-files","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-download-outlook-office-365-emails-as-eml-or-msg-files\/","title":{"rendered":"How to download Outlook (Office 365) Emails as .EML or .MSG Files"},"content":{"rendered":"

Introduction<\/h2>\n

\"Outlook In this article, you will learn how to download Outlook (Office 365) emails as .EML or .MSG files using ZappySys SSIS PowerPack without writing any code. We\u2019ll leverage the power of Microsoft Graph API, which provides unified access to Microsoft 365 services like Outlook Mail, and integrate it seamlessly using the API Connector for SSIS Outlook Mail (Office 365)<\/a>, Web API Destination and other components. By the end, you\u2019ll be able to automate the process of extracting emails and saving them to disk in standard email formats directly from your SSIS package.<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    Step 1: Register an Application in Azure Portal<\/h2>\n

    To access Outlook emails via Microsoft Graph API, the first step is to register an application in the Azure Portal. This allows your SSIS package to authenticate securely and retrieve mail data from Office 365.
    \nStep by step info is available here Outlook Mail (Office 365) Connector Authentication section.<\/p>\n

    User Credentials<\/h3>\n

    Use delegated access (User Credentials) whenever you want to let a signed-in user work with their own resources or resources they can access. Whether it’s an admin setting up policies for their entire organization or a user deleting an email in their inbox, all scenarios involving user actions should use delegated access.
    \nRefer to this links for the detailed steps:<\/b>     User Credentials [OAuth]<\/a><\/p>\n

    Application Credentials<\/h3>\n

    Application-only access is broader and more powerful than delegated access (User Credentials), so you should only use app-only access where needed. Use it when:<\/p>\n

      \n
    1. The application needs to run in an automated way, without user input (for example, a daily script that checks emails from certain contacts and sends automated responses).<\/li>\n
    2. The application needs to access resources belonging to multiple different users (for example, a backup or data loss prevention app might need to retrieve messages from many different chat channels, each with different participants).<\/li>\n
    3. You find yourself tempted to store credentials locally and allow the app to sign in ‘as’ the user or admin.<\/li>\n<\/ol>\n

      Refer to this links for the detailed steps:<\/b> Application Credentials [OAuth]<\/a><\/p>\n

      Step 2: Download Outlook (Office 365) Emails as .EML Files using SSIS<\/h2>\n

      Now let\u2019s look at some examples of how to access your Outlook emails using our easy-to-use Outlook Mail Connector in ZappySys SSIS PowerPack. This connector simplifies calling the Microsoft Graph API, so you can retrieve emails with just a few clicks.
      \nIn this section we will learn how to configure and use Outlook Mail (Office 365) Connector in       API Source<\/a> to extract data from Outlook Mail (Office 365).<\/p>\n

        \n
      1. Begin with opening Visual Studio and Create a New Project.<\/li>\n
      2. Select Integration Service Project and in new project window set the appropriate name and location for project.
        \nAnd click OK.<\/li>\n
      3. In the new SSIS project screen you will find the following:\n
          \n
        1. SSIS ToolBox on left side bar<\/li>\n
        2. Solution Explorer and Property Window on right bar<\/li>\n
        3. Control flow, data flow, event Handlers, Package Explorer in tab windows<\/li>\n
        4. Connection Manager Window in the bottom<\/li>\n<\/ol>\n

          \"SSIS<\/p>\n

          Note: If you don’t see ZappySys SSIS PowerPack Task or Components in SSIS Toolbox, please refer to this help link<\/a>.<\/div>\n<\/li>\n
        5. Now, Drag and Drop SSIS Data Flow Task<\/b> from SSIS Toolbox. Double click on the Data Flow Task<\/em> to see Data Flow<\/em> designer.\"SSIS<\/li>\n
        6. From the SSIS toolbox drag and API Source<\/a> (Predefined Templates) on the data flow designer surface, and double click on it to edit it:
          \n\"SSIS<\/li>\n
        7. Select New Connection<\/strong> to create a new connection:
          \n\"API<\/li>\n
        8. Use a preinstalled Outlook Mail (Office 365) Connector from Popular Connector List<\/em> or press Search Online<\/em> radio button to download Outlook Mail (Office 365) Connector. Once downloaded simply use it in the configuration:\n
        9. Proceed with selecting the desired Authentication Type. Then select API Base URL<\/em> (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure<\/strong> which will help set certain parameters. More info is available in Authentication section<\/a>.\n
            \n
          1. User Credentials [OAuth]\n
          2. Application Credentials [OAuth]\n
          3. Select the Get Messsages<\/b> endpoint, change\/pass the properties values, and click on Preview Data<\/strong> button to make the API call.\n
          4. That\u2019s it \u2014 click OK<\/b> and you’re done! In just a few clicks, you\u2019ve successfully configured a connection to Outlook Mail (Office 365)<\/b> using the Outlook Mail Connector<\/b>.<\/li>\n
          5. Now let’s move to the next step \u2014 retrieving the full email content.
            \nYou\u2019ll use the Web API Destination<\/strong> component to make the Get MIME content<\/strong> API call. Within this task, you can dynamically pass the Message ID<\/strong> to fetch each email\u2019s raw .EML<\/code> content from Outlook (Office 365).
            \nFor more details, refer to the official Microsoft documentation:             Get Outlook Mail MIME content<\/a><\/li>\n
          6. Drag and drop the Web API Destination<\/b> component from the SSIS Toolbox onto your Data Flow.
            \nDouble-click to open it, then configure as follows and create a new OAuth Connection if needed:URL:<\/strong><\/p>\n

            https:\/\/graph.microsoft.com\/v1.0\/me\/messages\/<%Id%>\/$value<\/p><\/blockquote>\n

            The <%Id%> placeholder is dynamically replaced by SSIS at runtime with the actual Message ID, allowing the Web API Destination to download each email\u2019s .EML content individually.<\/p>\n

            \"Get<\/a>

            Get MIME content\u2019 API call using the Web API Destination<\/p><\/div><\/li>\n

          7. You\u2019ll also need to create the OAuth connection using the same credentials.
            \nOn the Advanced tab, make sure to set the Redirect URL correctly.For detailed steps, refer to this guide:
            \n            How to set up OAuth 2.0 in SSIS<\/a><\/p>\n
          8. Next, add a Derived Column transformation to create a new column that defines the file path for saving the .EML<\/strong> file.
            \nIn this example, we\u2019ll use the Message ID to generate a unique file name for each email:Expression:<\/p>\n

            (DT_WSTR,1000)”E:\\\\zsTemp\\\\” + [Id] + “.eml”<\/p><\/blockquote>\n

            \"Derived<\/a>

            Derived Column – Dynamic File Path<\/p><\/div><\/li>\n

          9. Now, add an Export Column<\/strong> transformation to save the email content to a file.\n