Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]



Excel Functions | Excel Macro | Excel Tools | Popular Articles

Dear friends,

The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by outlook. Thanks to you all for providing me the prompt feedback about the same. I have fixed it but I have not changed the version of the tool as such. It will still remain as version 4.0. This post is just to inform you all about this fix. Therefore, if you are facing any issue, kindly download the latest version from the same link again or the below link provided.

Send Multiple Personalized Email – Excel Tool

Your Feedback

Glad to hear from you all about this tool. I would like to hear more about this tool and how can we improve it in the next version. You can provide your comment on twitter for quick reaction from me.

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

Rahul Tanwar on January 3, 2017 at 11:55 am

Hi vishwa

I tried it but i found error in this file. Like today i used it and send mail to 19 peoples but there was a issue that like i send mail to ABC with attachment 123. Second mail to XYD with Attachment 456. Third mail to PQR with attachment 789. When i send first mail thats fine with attachment, but when i send to second mail id XYD this user get the both attachment of ABC and XYD. Same third PQR get attachment 123, 456, 789.
PLs rechange you Codes.
Reply
- Vishwamitra Mishra on January 3, 2017 at 2:56 pm
  
  Thanks for your response. Changes made. Once available to download, I will inform you.
  Reply
  - Vishwamitra Mishra on January 3, 2017 at 10:56 pm
    
    It is available now. You can download it now.
    Reply
    - Rahul Tanwar on January 5, 2017 at 7:47 am
      
      Hi Vishwa
      
      Issue still not Resolve again all attachment is sending.
      Reply
      - Rahul Tanwar on January 9, 2017 at 12:25 pm
        
        Hi Vishwa
        
        Issue in gmail still not resolve. Pls check it dear.
      - Vishwamitra Mishra on January 13, 2017 at 4:25 am
        
        Hi Rahul,
        
        Gmail issue, is not because of the Macro. You need to allow to access gmail via any external app. The error you are getting is due to that security setting.
    - Junrey Granaderos on January 9, 2021 at 8:21 am
      
      thanks
      Reply
Tabish Ahmad on January 16, 2017 at 5:23 pm

Hello Vishwa,

I need your help while sending an email, I am getting one popup which says A program is trying to send an email message on your behalf. It this unexpected, clikc deny and verify your antivirus software is up to date.

I know this not the macro error but it is causing me an error when running in citrix application.

secondly, i fix the trusted setting issue, However, it is disable so cannot uncheck that option. I need vba code to fix it.

pls. help
Reply
- Vishwamitra Mishra on January 16, 2017 at 8:16 pm
  
  Hi Tabish,
  
  This is an external application security feature which should be enabled in that app etc but can not be done via VBA when you (user id) do not have access to change the security settings.
  Reply
Rahul Tanwar on January 16, 2017 at 6:19 pm

Hi Vishwa

I got your point but u cant understand my point to send mail
like again i m giving u a example
mail id are A, B, C, D and attachments are 1, 2, 3, 4
when i set all mail id and attachment A=1, B=2, C=3, D=4, when i click send mail then A got right attachment no 1, but B got 1 & 2 attachment, C got 1,2&3 and D got all attachment. That problem i m facing to send mails in bulk. And i already enable that option in gmail of external app.
PLs look and test with send mail by gmail. You will see
Reply
- Vishwamitra Mishra on January 16, 2017 at 8:15 pm
  
  Hi Rahul,
  
  Can you download the file again now (same version) from the site and try as this is supposed to be fixed now. I am not facing this issue any longer.
  Reply
  - Rahul Tanwar on January 17, 2017 at 12:47 pm
    
    Dear Vishwa
    
    This issue still not resolve you can also try with sending mail by gmail to 3 mail ids of yours you will get the issue of attachment.
    Reply
    - Vishwamitra Mishra on January 19, 2017 at 9:20 pm
      
      Hi Rahul, Issue is fixed now. Kindly download the latest copy and see if issue still exists.
      Reply
Anant Singh on February 13, 2017 at 12:48 pm

Hi,

I have 64 bit error. My operating system and excel both are 64 bit. Please can you resolve this problem.

Thank you,
Reply
Rahul Tanwar on February 18, 2017 at 10:11 am

Dear Vishwa

I tried all things but your sheet not working in gmail. And i already allow access gmail. But still sending all attachment.
Reply
Jun Ho on January 5, 2018 at 2:03 am

Dear Vishwa,

I’m still getting the attachment issue as well.

Thank you,
Reply
Amit on May 8, 2018 at 9:54 am

Hi Vishwa,
I am grateful for these excel vba macros.
I am new to vba. Just wanted to know if it is possible to have body of email in “Arial” font done directly into your code?
Thanks.
Reply
joy on July 10, 2018 at 5:09 pm

what your password for vba? I want to have some changes.
Reply
Nam on November 28, 2018 at 4:01 am

Dear adm,

I use office 64bit,cannot open file Send_Multiple_Email_Ver_4.0 , Compile error : The code in this project must be updated for use on 64-bit system. Please review and update declare statements and the mark them with the Ptrsafe attribute . Please help fix for me.
Reply
Nam on November 28, 2018 at 4:06 am

I have office 64 bit error. My operating system and excel both are 64 bit. Please can you resolve this problem.below error “Compile error : The code in this project must be updated for use on 64-bit system. Please review and update declare statements and the mark them with the “Ptrsafe attribute
Reply
charlie on January 14, 2019 at 4:04 pm

Im getting a error on the below

Private Declare Function GetVersionEx Lib “kernel32” _
Alias “GetVersionExA” (lpVersionInformation As _
OSVERSIONINFO) As Long

I have a compile error – ” The code in this project must be updated for use on 64-bit system, Please review and update declare statements then mark them with ptrsfe attribute
Reply
Liam Teske on March 19, 2019 at 1:33 pm

Hi, This is amazing and helps me massively. Is there a way to add another column and give a personalised signature?
Reply
Uma sharan Mishra on June 12, 2019 at 1:46 pm

Hi Vishwa,

I am grateful for these excel vba macros.

there is an error showing while sending emails through gmail please fix the issue or help to understand the issue.

below mentioned error is showing – “The transport failed to connect to the server.
(-2147220973)”
Reply
UMA on December 28, 2019 at 8:04 am

Hi vishwa

I tried it but i found error in this file. Like today i used it and send mail to 19 peoples but there was a issue that like i send mail to ABC with attachment 123. Second mail to XYD with Attachment 456. Third mail to PQR with attachment 789. When i send first mail thats fine with attachment, but when i send to second mail id XYD this user get the both attachment of ABC and XYD. Same third PQR get attachment 123, 456, 789.
Reply
JIGAR PANCHAL on June 15, 2020 at 6:34 am

Hi Vishwa,

I am grateful for these Multipal email sending tools of excel vba macros.

there is an error showing while sending emails through gmail please fix the issue or help to understand the issue.

below mentioned error is showing – “The transport failed to connect to the server.

Thank you very much I am waiting for your reply
Reply
William Self on November 1, 2021 at 4:02 pm

Any feedback on how to fix the 64-bit error?
Reply
William on December 11, 2023 at 11:34 pm

Anyone figure out how to fix the Compile Error for 64-bit (Please review and update the declare statements and then mark them with the PtrSafe attribute. Please help if so.
Reply