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

Streamlining Work Allocation with an Outlook-Based Excel Tool

Advanced Excel Techniques

Streamlining Work Allocation with an Outlook-Based Excel Tool

Byexcelsirji

Table of Content Introduction Benefits of Using Outlook and Excel for Work Allocation Setting Up Your Outlook-Based Excel Tool Managing Work Allocation Conclusion Download Free Excel Template Introduction Efficient work allocation is crucial for organizations…

Protect Excel Sheet for Manual Input but Allow Programming Inputs

Excel VBA and Macros

Protect Excel Sheet for Manual Input but Allow Programming Inputs

Byexcelsirji

Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you.

Duplicate Data Identifier

Advanced Excel Techniques

Duplicate Data Identifier Tool

Byexcelsirji

Duplicate Data Identifier is an MS Access based tool which helps to identify duplicates from any Excel based data. The tool supports up to 10 conditions and 25 types of matching conditions to find the exact duplicate. You can also define formatting conditions to first format the data before checking for duplicates.

VBA Code to Delete File

Excel VBA and Macros

VBA Code to Delete File

Byexcelsirji

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

VBA Code to Check if Folder Exist

Excel VBA and Macros

VBA Code to Check if Folder Exist

Byexcelsirji

VBA Code to check if folder exist Validation is one of the important parts of any programming language. As per few studies, 60% of the code is focused on validating input or output. In this…

VBA Code to Add New Sheet at Beginning or End of Excel File

Excel VBA and Macros | Productivity and Automation

VBA Code to Add New Sheet at Beginning or End of Excel File

Byexcelsirji

VBA Code To Add New Sheet In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet…

Excel VBA Master Tool Kit