FREE Download : Send Multiple Emails Tool – Ver 4.0

.

bulk-email-sender
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

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

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.


Download Now

Buy a coffee for the author

Adsense

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.

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

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
How to Declare a Public Variable in VBA

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

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 (=).

You May Also Like…

24 Comments

  1. Tabish

    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

      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

        Yes, I just saw them in 2007 outlook Outbox folder.

        Reply
        • Vishwamitra Mishra

          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

            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

            You can share it with details. I can have a look at it.

  2. Tabish

    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
  3. Tabish

    Hello Vishwa,

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

    Regards,
    Tabish

    Reply
    • Vishwamitra Mishra

      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

        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

          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

            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

            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

            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.

  4. Apurva

    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

      Thanks for your valuable suggestion. I would try to implement that in the next version.

      Reply
    • Kundanlal Manwatkar

      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
  5. Faisal

    Dear Mishra,

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

    Thanks
    Faisal

    Reply
  6. Cool

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

    Hi,

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

    Please do help accordingly.

    Reply
  8. Kim Blake

    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
  9. rajan

    Hi

    When i open the file , i get error that ” Error in Loading DLL”. Can you resolve

    Reply
  10. Sendy

    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
  11. Prasanna

    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

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

Your email address will not be published. Required fields are marked *

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

Join and get a FREE! e-Book

Don't miss any articles, tools, tips and tricks, I publish here

You have Successfully Subscribed!

Pin It on Pinterest