FREE Download : Send Multiple Emails Tool – Ver 4.0



Excel Functions | Excel Macro | Excel Tools | Popular Articles

Dear LEM Readers,

Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of your friends a Happy New Year Email for this coming new year 2017? Sounds good !! but would you put every one’s email in to List and send them all a generic message??

Noooo!! how about sending them all a personalized email just referring to each individual. They will love it. Don’t worry, to do that you don’t need to spend 31st all night long typing and sending email to each one of them. This will help you making your email ready for each of your near and dear ones and send them individually.

Send Multiple Personalized Email – Excel Tool

Want to know more about this tool?

To know more about this tool other previous versions of this tool Ver 3.0 click here

What is new in this version?

1. Look and Feel

As you can see, I have made some changes in look and feel of the tool. Refer the above picture.

2. Bug fixes and few code changes

I have fixed many bugs which were reported by each one of you. I have tried fixing all of them in this version.

3. New Feature – Personalized Email Body Designer

Based on, latest suggestion provided by one of my reader, Tabish, I have included a feature to create personalized email body for each recipient based on their name and other data which you want to include in their emails respectively. This is a free design, where you are free to design as you wish.

Tabish:
Fantastic work bro!
I have one important suggestion. The version doesn’t have the ability to modify the Body. Body as per the version should be same for all. Let me elaborate you what exactly I am referring to you is suppose if I am sending an emails to my employee pertaining to their variable bonus and I wanted to highlight their Employee Name , their New Bonus and Bonus % which will vary with each employee. Thus, in each emails goes to employee will reflects their name, bonus amount and Bonus%.

Hope you add this functionality.

I have some code and tool which I can send to you.

All the instructions are provided in the Email Body Designer tab in the same workbook.

Email Body Desinger – Send Multiple Email – Excel Tool

Download

Here you go with the latest version of this tool. Download it, try sending wishes to your near and dear ones and don’t forget me 😉 Just kidding. If you like the new features and look and feel of the tool, you can simply twit me or provide your feedback by sending me an email or posting a comment here or by leaving a note on my facebook page.

Buy a coffee for the author

Download FREE Tools and Templates

There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

Hurray..Lets Go

Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

Feb 9, 2024

In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

How to Declare a Public Variable in VBA

Feb 3, 2024

While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

How to Copy content from Word using VBA

Feb 3, 2024

As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active...

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

Know more

Tabish on December 30, 2016 at 4:16 pm

Hello Vishwa,

I just downloaded and followed the instructions. But I am not receiving any emails which I have kept in to or CC. However, tool confirms that email sends successfully.

I am using excel 2007 version today.I have also email the tool along with input at info@learnexcelmacro.com.

Please suggest!
Regards,
Tabish
Reply
- Vishwamitra Mishra on December 30, 2016 at 4:32 pm
  
  Hi Tabish,
  
  Are you using Outlook to send emails? If, yes, can you please check if mails are there in your outbox or sent items?
  Reply
  - Tabish on December 30, 2016 at 4:44 pm
    
    Yes, I just saw them in 2007 outlook Outbox folder.
    Reply
    - Vishwamitra Mishra on December 30, 2016 at 4:47 pm
      
      Ok Please check your outlook connection… with VBA the problem is once email moved to Outbox then it sends a message back that successfully sent. Post that it is Outlook’s responsibility to send all the emails in the Outbox folder 🙂 You can test other features as well and provide your feedback.
      
      I appreciate that !!
      Reply
      - Tabish on December 30, 2016 at 4:51 pm
        
        Ah… I agree, I believe that all other version of yours I have tested in 2016 Outlook. Today, only i have downloaded 2007 and thus it impacts my outlook connection.
        
        Let me fix it and will share the feedback to you. I have email one of my tool wherein I need slight changes, can you please check that if at all possible .
        
        Regards,
        Tabish
      - Vishwamitra Mishra on December 30, 2016 at 5:13 pm
        
        You can share it with details. I can have a look at it.
Tabish on January 1, 2017 at 2:00 pm

Hello Vishwa,

Thank you for sharing it.

I have changed the formula in the to increase the length of body as per my business needs. But unfortunately, macro doesn’t allow to sends email. It keeps rotating (Cursor).

I have sent you the attachment at info@learnexcelmacro.com

Can you please check it is very important?

Regards,
Tabish
Reply
Tabish on January 1, 2017 at 3:14 pm

Hello Vishwa,

It takes around 25 minutes to sends emails post changed of Body.

Regards,
Tabish
Reply
- Vishwamitra Mishra on January 1, 2017 at 3:58 pm
  
  Hi Tabish,
  Does macro takes, 25 minutes to run? Or it is the time which outlook takes to send them all from outbox?, If it is macro, then, I can have a look. If it is outlook then, please check your outlook connection?
  
  It also depends on many factors like:
  1. Does it have attachments? If yes, then how many?
  2. Does it have big body in email with images as part of email Body?
  3. And of course how many emails are you talking about here?
  Reply
  - Tabish on January 1, 2017 at 5:30 pm
    
    No, only the body of the email is big, there was no attachment, no images. There are only 2 emails in to/cc.
    
    I believe it can be speed up. Can you please take a look, I have send you an email with attachment version 4 macro.
    
    Regards,
    Tabish
    Reply
    - Vishwamitra Mishra on January 1, 2017 at 5:44 pm
      
      Hi Tabish,
      I did not receive any email. And can you answer my first question : Is macro taking time to Run? Or macro runs fast, but outlook takes time to send it from your outlook.
      Reply
      - Tabish on January 1, 2017 at 6:20 pm
        
        Yes Macro takes time to send one email in 10 mins. I mean to say I can see email sent items after 10 mins.
        
        So, if there are 2 option in to /cc it is taking 2 times of 10 mins each time.
        
        I sent to email to this account info@learnexcelmacro.com.
        
        You must have receive an email from salaamtabish@yahoo.co.in
        
        Regards,
        Tabish
      - Tabish on January 2, 2017 at 1:54 pm
        
        Thank you Vishwa, the body of the email is causing the slowness. Hence, I have made changes in the formula in the Email Designer tab in the area of Body.
        
        I avoid using/ or giving reference of “Generic Mail Body 2″ cell C so on. I add those directly in Formula while concatenation. Like as below.
        
        $C$5 & ” ” &G22 & “,” & CHAR(10) & CHAR(10) & $C$6 & ” ” &TEXT(H22,”$0.00″) & CHAR(10) &”Full Name :”
        
        Regards,
        Tabish
      - Vishwamitra Mishra on January 2, 2017 at 8:56 pm
        
        Ok, so I assume issue is resolved now. Though I have made few minor changes in the code (tuning) you can download it again from the website.
Apurva on January 2, 2017 at 2:46 am

Hello

Thanks for the wonderful tool
we need a macro in which the “Send from” option is needed for sending multiple emails. we have to communicate to vendors, customers,etc. from different functional/shared mailbox.
request your support for the same.
Reply
- Vishwamitra Mishra on January 2, 2017 at 9:37 am
  
  Thanks for your valuable suggestion. I would try to implement that in the next version.
  Reply
- Kundanlal Manwatkar on December 9, 2021 at 5:06 am
  
  Hello Sir.. When I started to this tool, it displayed error like compile error.. The code in this project must be updated for use on – 64 bit system. Please review and update Declare statements and then mark them with the PtrSafe attribute…can you please send me updated version to work on systems. I am using Outlook 2013…thanks
  Reply
Faisal on February 17, 2018 at 1:46 pm

Dear Mishra,

Is there a way to see the emails first before sending them ?

Thanks
Faisal
Reply
Cool on February 7, 2019 at 9:45 am

Hi,

Your innovation is wonderful, can you help me with option do disable other emailing solution apart outlook.

Thanks in advance!!

With Regards
CD
Reply
Cooldeath on February 7, 2019 at 10:01 am

Hi,

Also the shared file is not working with 64 bit setup.

Please do help accordingly.
Reply
Kim Blake on February 4, 2020 at 3:14 am

I receive compile error:
The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.
Reply
rajan on May 3, 2020 at 5:29 am

Hi

When i open the file , i get error that ” Error in Loading DLL”. Can you resolve
Reply
Sendy on May 29, 2020 at 10:05 am

Hi,

It is amazing and help me a lot.
Is it possible to change it as a display email instead of sending it out directly?
Also, any possible to save a list that the email hen and email can be send when we tick multiple boxes?

Thanks a lot.
Reply
Prasanna on December 29, 2021 at 9:32 am

Hi Vishwa,

Your file working fine to me.

But attachments problems

Person1- If i add 2 attachments for person1 – It is going email correctly with 2 attachments but for Person2 he will get attachments 5 ( 2+3)….please help on this…

Person2 – If i add 3 attachments for person2

Prasanna.
prasanna.mg2@gmail.com
Reply

Trackbacks/Pingbacks

Welcome to LearnExcelMacro.com Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes] - […] version of Send Multiple Emails Tool, I released last, there was a small error issue with the mail sent…

Submit a Comment Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.