Connect Outlook Mail To Excel Sheets With Azure Logic App

This article helps you to learn how to create a Logic App between the Outlook Mail and Excel Spreadsheet. 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 into another one Service (such as Twitter). It makes it practical and simple for line-of-business. 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.

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 into 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.

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 Work Flow 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,
 
 Connect The Outlook Mail To Excel Sheet With Azure 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 location where your logic app stored. Then, click on "Create".

 Connect The Outlook Mail To Excel Sheet With Azure Logic App

Here is the dashboard. Click on Logic App Designer.

Connect The Outlook Mail To Excel Sheet With Azure Logic App

Step 3

Now, click on the Blank Logic App.

Connect The Outlook Mail To Excel Sheet With Azure Logic App

Step 4

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

  • Search Facebook on the search bar.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Choose the Triggers.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Sign in to Outlook.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Next, set the Time interval and Frequency for checking the workflow as one minute.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App

Step 5

  • Next, search Excel Online.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Then, choose the Action for the workflow.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Next, we sign in to OneDrive

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • We give permission to access our accounts.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Next, Choose File Name and Table Name for saving the outlook mail from the outlook mail.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • Then, choose the fields you want.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App
  • The Final Workflow will be like this.

    Connect The Outlook Mail To Excel Sheet With Azure Logic App

Step 6

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

 Connect The Outlook Mail To Excel Sheet With Azure Logic App

Output

Send an email to outlook mail ID.

 Connect The Outlook Mail To Excel Sheet With Azure Logic App

Now, the mail should be saved in Excel.

Connect The Outlook Mail To Excel Sheet With Azure Logic App

Summary

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