Connect Outlook Mail To Excel Sheets With Azure Logic App

Azure Logic Apps

Logic App is a cloud-based service. It allows us to react to an event in one service (such as SharePoint online) and do something with the data from that event in another service (such as Twitter). It makes it practical and simple for business processes. The users build workflows that automatically do some business tasks and processes across applications and services. We can connect our business-critical apps and services with Azure Logic Apps, automating your workflows without writing a single line of code.

Before reading this article, please go through some important article links, mentioned below.

• Deep Dive Into Azure Logic Apps
• Connect OneDrive To Google Drive With Azure Logic Apps
• Connect Facebook To Twitter With Azure Logic App

Here, we can save email attachments from Outlook to OneDrive Online automatically.

Outlook

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taking, journal, and web browsing. Login here

Excel

Microsoft Excel a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Why we save Outlook Email to Excel Spreadsheet

Outlook stores and organizes your email messages, but it cannot perform advanced analysis on them. For example, Outlook cannot count the number of messages that individual customers or clients send to your business. It cannot count the number of messages that you received during specific periods, and it cannot display information on charts. But Microsoft Excel can do all this and more using its spreadsheet functions. Export your Outlook inbox as an Excel file to open it with Excel. We have to manage all these Logic Apps introduce the Flow that saves your outlook Emails to Excel sheet which is present in the Onedrive. As soon as we receive your email, your mail will automatically appear in your Excel.

How to Create a Logic App to save Outlook Email to Excel Spreadsheet

Here, we can connect Outlook and Excel.

Prerequisites

• Microsoft Azure Account.
• Outlook Account.
• OneDrive-Excel Online.

Follow the below steps to build a Workflow using a template.

Step 1. Login to https://portal.azure.com/

In the dashboard, choose Create a resource and click on Integration. Now choose Logic App,

Step 2. Enter the name you want to assign to the logic, choose the subscription and resource group where you organize related resources, and the location where your logic app stored. Then, click on "Create".

Here is the dashboard. Click on Logic App Designer.

Step 3. Now, click on the Blank Logic App.

Step 4. Configure the data by signing in to Outlook and Excel Online.

• Search Facebook on the search bar.
  
• Choose the Triggers.
  
• Sign in to Outlook.
  
• Next, set the Time interval and Frequency for checking the workflow as one minute.
  

Step 5

• Next, search Excel Online.
  
• Then, choose the Action for the workflow.
  
• Next, we sign in to OneDrive
  
• We give permission to access our accounts.
  
• Next, Choose File Name and Table Name for saving the outlook mail from the Outlook mail.
  
• Then, choose the fields you want.
  
• The Final Workflow will be like this.
  

Step 6. Now, we save and run the workflow and run it.

Output

Send an email to Outlook mail ID.

Now, the mail should be saved in Excel.

Summary

I hope you understand how to save Email from Outlook.com to Excel automatically and how to run it. Stay tuned for more Logic App articles.