Outlook Bulk Email Excel VBA Tool


Add To Cart

This tool helps you to send or draft emails in bulk from Excel using MS Outlook. It reads the recipient details from the Excel sheet and uses MS Outlook installed on your system to generate emails.
The tool support following fields:
1. To
2. Cc
3. Subject
4. Email Body
5. Attachment
6. HTML Table in Email Body

Follow the below steps 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 <<Table>> 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 <<Table>> 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

 

 

  • 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

 

Prerequisite:

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

 

Limitations:

  1. Tool does not support adding Signature in the email body
  2. Tool support only 1 attachment per email

Please drop an email at excelsirji@gmail.com for any support. We will revert you in 24 hours.

 

VBA Tips you Must Know – Part 1
VBA TRICKS
Excel VBA Tips you Must Know – Part 1

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.

How to use Excel Workday Formula in Excel
DATA ANALYSIS TRICKS
EXCEL FUNCTION – WORKDAY

Are you working today? or Do you have Work Off or holiday today?  I am asking this question because I am gonna tell you the most commonly used function in Excel “Workday”. “Workday” as name suggest that it brings the day when you will be working or you are expecting …

Subtotal Function Excel
DATA ANALYSIS TRICKS
Excel Function – SUBTOTAL

Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use this function for different purposes instead of multiple functions i.e. SUM, AVERAGE, COUNT, MAX, MIN, Standard Deviation etc. …

Privacy Preference Center

Necessary

Advertising

Analytics

Other

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn