Outlook Bulk Email Tool

Table of Content

About the tool

Complete Excel VBA Course

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
    Email Management ToolOutlook Bulk Email 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
    Outlook Bulk Email Tool
  • 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
    Outlook Bulk Email Tool
  • Enter email body
    Outlook Bulk Email Tool
    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
    Outlook Bulk Email Tool
  • 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
    Outlook Bulk Email Tool
    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.
    Outlook Bulk Email Tool
    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
    Outlook Bulk Email ToolOutlook Bulk Email Tool
  • Ensure that Outlook is up and running on your system before proceeding further, now click on ‘Open Tool’ button
    Outlook Bulk Email Tool

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.

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

Complete Excel VBA Course

Want to Buy this tool?

Outlook Bulk Email Tool

Recommended Articles

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Use Automated Excel Utility Tools to increase productivity

Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community

Similar Posts

VBA Code to Remove Duplicate Rows
|

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.