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…

33 comments:

Ashit said...

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

Excel Trainer said...

Download link shared. Please download.
Thanks for your interest.

Anonymous said...

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

Anonymous said...

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

NITHIN R said...

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

Sudip Baral said...

Plese send a copy to sudbrl@gmail.com.

Excel Trainer said...

Link shared

Excel Trainer said...

Link shared

Excel Trainer said...

Download link shared. Please download.
Thanks for your interest.

Excel Trainer said...

Already shared in Facebook group. Thanks...

Zandee said...

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

Excel Trainer said...

Download link shared... Thanks...

Anonymous said...

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

Peak said...

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

Prasanta said...

Please share the file once. below is my email.

majip50@gmail.com

Satyendra said...

Pl send to kodarmacircle@gmail.com

Vasanth said...

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

hi said...

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

Anonymous said...

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

Anonymous said...

Please send macro ankita.w@iinfrasolservices.com

Thanks in advance

Anonymous said...

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

thanks in advance

Unknown said...

Hi

Plz send macro we need this urgently

Thanks

Unknown said...

Hi

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


Thanks

Excel Trainer said...

Link Shared... Thanks

Marc NineBodies said...

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

Anonymous said...

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

Prasanna said...

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

Anonymous said...

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

Manoj Kumar said...

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

Mohan said...

Please share the macro link at chandrumohan99@gmail.com

Anonymous said...

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

Anonymous said...

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

NOBLE said...

Please share the macro to noblerajm@gmail.com