Advanced Excel Techniques Excel VBA and Macros

Outlook Email Management Tool

Table of Content

About the tool

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

Tool Features

Export email details from Outlook folder and sub-folders to Excel Sheet
Copy emails from Outlook folder and sub-folders to system folder in msg format
Copy email attachments from Outlook folder and sub-folders to system folder
Move emails from Outlook folder and sub-folders to another Outlook folder

Benefits

Save huge time in managing emails
Helps to avoid manual errors

System Requirements

You need to have installed version of MS Outlook 2010 or above
You need to have installed version of MS Excel 2010 or above

Tool Limitations

Due to Outlook security permissions, you may receive following message while using the tool

How to use this tool

Follow the below video which details out how to use this tool.

Recommended Articles

Advance filter in excel

Advanced Excel Techniques

Advance Filter in Excel – how to create and use

BySumit Shrimal

This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.

VBA Code to Remove Duplicate Records

Excel VBA and Macros

VBA Code to Remove Duplicate Rows

Byexcelsirji

Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.

Time-and-Motion-Professional-Tracker

Advanced Excel Techniques

Time and Motion Tracker

Byexcelsirji

Time & Motion Tracker is an MS Excel based tool which helps you to track Start and End time of any type of transaction or activity. The tool is developed using VBA coding which helps you to protect manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time stamp.

Excel_Random

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

RANDOM Sampling Excel Tool

Byexcelsirji

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

VBA Code to Add Items in ListBox Control in Userform

Excel VBA and Macros

VBA Code to Add Items in ListBox Control in Userform

Byexcelsirji

VBA Code To Add Items In Listbox Control Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in…

VBA Code to Count Cells by Color

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

Excel VBA Master Tool Kit