Share in Facebook


26 June 2020

Free Macro to Send emails with Attachments

Hello Friends,
No discussion on Excel today (!), rather I am giving you one FREE MACRO developed by me to send bulk mails which can be downloaded from the link below this article.

" Please ask for a copy of the macro in the comment box, I will send the link to download the macro free of costs. This is to protect the macro from some malicious cracker. "


"Please remember Cracking a Macro is Easy but making a Macro needs your Planning, Imagination, Knowledge and Skill..." . I will let you know hoe to make this step by step, but it will take time to master Excel like a Pro with compact knowledge.




Auto Mailer Macro Free
    Auto Mailer Macro Free

Why I made this Excel Macro or Excel VBA Code ?

Recently I needed to send few mails with recipient’s data, I thought I could use Mail Merge to get the job done. Yes, it is done but “How to mark ‘CC’ ?”.
I didn’t find it. I Google it, nope, no help.

So, I thought I could use Excel Macro (VBA) to get the job done. Three hours it took to complete this macro using which I can send bulk email from excel with attachment.

After that I made some improvements and decided to provide this excel macro to send emails with or without attachments as FREE DOWNLOAD to you all because I understand the pain you feel sending emails one by one.










I have given you the option to send one universal attachment (Planning to give the option to attach different attachments for different recipient) in this excel macro.


One Request

Please DO NOT use this free macro to send spam mails. It is your responsibility how to use it.

Also, I am not responsible for any problem which may arise after sending mails. This macro is tested by me at least 100 times and I am getting 100 times positive result. Please check two or three mails before sending final mails.

This is a free excel macro to send emails automatically once the data is feed in the excel sheet, do not sale or do not purchase from anybody.

Please write to me in the comment box to improve this Excel Macro – Automatic Mails from Excel without using MS Word Mail Merge. I will add some more features to this FREE MACRO.

Please read this GUIDELINES carefully then enjoy your Office Work.


DOWNLOAD FREE email MACRO HERE   











v This is free version-1 macro to send emails using Outlook where you can’t send (?) mails in CC or BCC; unlike other Add-ins you don’t need to install

v As this is a macro, you need to ‘ENABLE’ macro clicking ‘Enable Macro’ in options below Formula bar or you can do this using File à Options Ã  Enable macro.

v You will notice 25 columns of which one is ‘Identifier’ which is not being used in this macro (you can use it for your understanding) but append your recipient’s mail ids in TO, CC & BCC column header.

v Please note that do not place any special character including space(s) in the TO, CC, BCC column, leave it blank.

v After entering data in the first 3 or 4 columns you can enter data which you need to plot in the mails. You can use maximum ‘21’ field in the mail body as per this version.

v It is strongly recommended to use your Own Field / Column names replacing Data_1, Data_2, Data_3 etc., to post the required data in the Mail Body.

v After cross checking the data click on the button named Click Me for Show Control Panel.

v In the Auto Mailer system

Ø Enter No of e-mails to be sent
Ø Enter the Subject Line
Ø Start typing your mail in ‘Mail Body’ space or you can alternatively copy and paste from MS-Word (RECOMMENDED) or any document.
Ø Place your Cursor where you want to place your appropriate data, tick the data from ‘Insert Data’ data feeder.
Ø You can add one universal attachment in every mails.
Ø Please cross check and click on Send Button to start sending emails.



DOWNLOAD FREE EXCEL MACRO SEND BULK EMAILS

Please ask for a copy of the macro in the comment box, I will send the link to download the macro free of costs. This is to protect the macro from some malicious cracker.


Thank you… Keep visiting and commenting…

34 comments:

  1. Please share the macro for emails to my email id ashroff17@gmail.com Thank you!

    ReplyDelete
    Replies
    1. Download link shared. Please download.
      Thanks for your interest.

      Delete
  2. Please share with me the macro
    Email id- debashisertumpa@gmail.com

    ReplyDelete
  3. Kindly arrange to send me the bulk email sending macro on bhanot1952@gmail.com and oblige. Thanks

    ReplyDelete
  4. Please share the macro file to my email id - nithi.rsn@gmail.com

    ReplyDelete
    Replies
    1. Download link shared. Please download.
      Thanks for your interest.

      Delete
  5. Plese send a copy to sudbrl@gmail.com.

    ReplyDelete
  6. Already shared in Facebook group. Thanks...

    ReplyDelete
  7. Kindly send me the macro to zandee.a@gmail.com

    ReplyDelete
  8. Please give me the macro at mahrusaim@gmail.com Good Article and thank you very much

    ReplyDelete
  9. Please share the macro file to my email id - peaknbk@gmail.com

    ReplyDelete
  10. Please share the file once. below is my email.

    majip50@gmail.com

    ReplyDelete
  11. Pl send to kodarmacircle@gmail.com

    ReplyDelete
  12. Please share the macro file to my email id - vasu3625@gmail.com

    ReplyDelete
  13. Please share the macro for emails to my email id vk.sysadmin@gmail.com Thank you!

    ReplyDelete
  14. Please share macro for emails to my email id sameerchawan222@gmail.com

    ReplyDelete
  15. Please send macro ankita.w@iinfrasolservices.com

    Thanks in advance

    ReplyDelete
  16. Hi,
    Please send macro to: wenatop@hotmail.com

    thanks in advance

    ReplyDelete
  17. Hi

    Plz send macro we need this urgently

    Thanks

    ReplyDelete
  18. Hi

    Plz send macro we need this urgently
    sunnym2010@gmail.com


    Thanks

    ReplyDelete
  19. Please send me the macro.
    Thanks so much
    ninebodies9@gmail.com

    ReplyDelete
    Replies
    1. Download link shared, please download. If any problem, please comment here.

      Delete
  20. Can you share this link to kprasanna.rajendran@sgkinc.com

    ReplyDelete
  21. Hi,
    Plz, use Trunao.com
    its best way to convert excel to online database

    ReplyDelete
  22. Pleas share the macro link at manoj.reply@gmail.com

    ReplyDelete
  23. Please share the macro link at chandrumohan99@gmail.com

    ReplyDelete
  24. Hi,
    Plz, use Trunao.com
    its best way to convert excel to online database.

    ReplyDelete
  25. Hi,
    Plz, use www.trunao.com
    its best way to convert excel to online database.

    ReplyDelete
  26. Please share the macro to noblerajm@gmail.com

    ReplyDelete
  27. Please share the macro link to Vanand3499@gmail.com

    ReplyDelete

Please share your thoughts and please share this blog to motivate us...
Thank you...