Advanced Excel Techniques Excel VBA and Macros

Outlook Bulk Email Tool

Table of Content

About the tool

Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.

Tool Features

Draft or Send Bulk Emails using MS Outlook
Supports attachments and table in email body
Auto insert email signature in the email

Benefits

Save Time
Increase Accuracy

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

Download the Automated tool professionally designed Given Below :-

Tool Limitations

Due to Outlook security permissions, you may receive following messages while using the tool
To resolve the security prompts in Outlook, you can update Outlook Trust Center settings as displayed in below screenshot. Note that you need to open Outlook as Administrator to make these changes
Tool support only 1 attachment per email

How to use this tool

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

Open the tool and fill To, Cc (Optional), Subject in ‘Home’ sheet
Enter email body

Note: If you want a table inside the email body, use <> keyword in the email body like in above screenshot.
If you want to add an attachment in the email, enter the full path of the file
If you have mentioned <> keyword in the Email Body, then you need to mention the Lookup value in column G (Table Data Lookup Value). This value is used to filter the data available in ‘Table Data’ sheet

How Lookup Value works?If you want to add a table in the email body, then you need to add your table data in ‘Table Data’ sheet. Note that there is no limit on number of rows or column.

Note: Here first column (Lookup Data) is important. Tool uses this column to filter the data and add in Email Body like in below screenshots
Ensure that Outlook is up and running on your system before proceeding further, now click on ‘Open Tool’ button

Select or type account name from which you want to generate emails. Also select the email importance and checkbox to draft emails instead of sending them directly.

Excel VBA Master Tool Kit

Done, click on ‘Generate Email’ button see the tool working for you.
Once the activity is completed, you will see a confirmation message and you can also refer column A (Status) for status of each email

Sample Email:

why to waste effort when we have ready tool specially designed for you which make your work super easy and quick.. click below link for download.

Recommended Articles

Excel VBA Tips you Must Know – Part 1

Excel VBA and Macros | Productivity and Automation

Excel VBA Tips you Must Know – Part 1

Byexcelsirji

Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

VBA Code to Check if Folder Exist

Productivity and Automation | 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…

Outlook-Email-Management-Tool

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

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.

Efficient Work Allocation in Excel

Advanced Excel Techniques

Efficient Work Allocation in Excel: A Practical Guide

Byexcelsirji

Table of Content Introduction Create a Detailed Work Allocation Template Define Case Types, Users and Status Configure Dropdowns in the Template Allocate Tasks Based on Skillsets Track Progress with Pivot Table Implement Conditional Formatting Regularly…

Xlookup function in excel

Excel Functions | Advanced Excel Techniques

XLOOKUP function in Excel with formula examples

BySumit Shrimal

This tutorial introduces XLOOKUP, a new function in Excel for both vertical and horizontal lookups. Tasks that used to feel super complicated, like left-side lookups, finding the last match, or using VLOOKUP with multiple criteria, are now much easier with XLOOKUP.
Before, you had to choose between VLOOKUP for vertical lookups, HLOOKUP for horizontal ones, or more complex options like INDEX MATCH or Power Query. But now, you don’t have to pick anymore. XLOOKUP can handle all those tasks in one simple function.

Choose function in excel

Excel Functions | Advanced Excel Techniques | Excel Basics

Excel CHOOSE function

BySumit Shrimal

The tutorial explains how to use the CHOOSE function in Excel, showing you the basics and some interesting examples. While CHOOSE might seem simple on its own, when you combine it with other functions, it can be powerful. Essentially, the CHOOSE function helps you pick a value from a list based on its position. The tutorial also covers some advanced ways to use CHOOSE that you might find very useful.

Excel VBA Master Tool Kit