Join 400,000+ professionals in our courses here 👉 [ Ссылка ]

In this video, I'll show you how to dynamically import data from Outlook to Excel using Power Query! This video is a must-watch for anyone looking to streamline their email data analysis or organization. Whether it's tracking sales emails, project ideas, or any other specific category, we'll show you how to set up a dynamic connection to Outlook that updates with a simple refresh in Excel. Say goodbye to manual data entry and hello to efficiency!

So anytime you want to get the latest email information, you just have to refresh your Excel table. And we'll also apply filters to only export specific emails to Excel and parse the contents so you only get the information you need from the emails. No VBA is used and no external add-ins. Instead I use a feature that belongs to Excel.

🔑 Key Steps Explained:
▪️ How to set up a connection from Excel to a specific Outlook folder.
▪️ Authenticating your Microsoft account to establish the connection.
▪️ Using Power Query to select and transform the relevant data from Outlook.
▪️ Applying filters to select specific data such as emails from a particular folder or with attachments.
▪️ Choosing columns like Subject, Sender Name, and Email Body to be imported into Excel.
▪️ Loading the filtered data into an Excel table for easy analysis and reference.
▪️ Refreshing the data in Excel to reflect new emails added to the Outlook folder.

00:00 How to Use Power Query to Import Data from Outlook
01:05 Setup Connection: Get Data from Microsoft Exchange
02:28 Apply Filters to Select Specific Data
05:01 Load Data to Excel
06:21 Wrap Up

► LINK to more Power Query tutorials: [ Ссылка ]-

⯆ Link to full article: [ Ссылка ]

★ My Online Excel Courses ► [ Ссылка ]

Power Query Data Sources: [ Ссылка ]

➡️ Join this channel to get access to perks: [ Ссылка ]

👕☕ Get the Official XelPlus MERCH: [ Ссылка ]

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: [ Ссылка ]

🎥 RESOURCES I recommend: [ Ссылка ]

🚩Let’s connect on social:
Instagram: [ Ссылка ]
LinkedIn: [ Ссылка ]

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #powerquery

свернуть