Excel macro to send bulk emails using Outlook

SUBSCRIBE Today and receive Tips and Tricks of Excel. And not just Excel, a lot more interesting lectures on AUTOMATION..

In this tutorial, you'll learn how to send emails using excel vba which further uses outlook to send emails.

It will send emails with the name of default sender. Though it gives you full flexibility in configuring recipient email address, cc, bcc, subject, body and lot more other stuff.

You can use this approach to send bulk emails using a simple piece of code in excel.

[lichin]

Your video and VB code worked perfectly for me, thanks for taking the time and effort for doing this!

[TheMilindchankapure]

Thanks Kamal, This video saved me I got project where I required Macro to send Reminders after very 15 day for two months time .

[hans]

Many thanks worked perfectly for my application.

[joem]

Great video. What I learned was the option to use the .to, .cc and .bcc directly off the mailitem object. I use to create recipients and then set the type. The method you show cuts down on the overhead!

[adaptcommercialcleaning]

hi, thank you for this. I need to attach different attachments to different emails and have the source of each different document written in a separate column on the excel sheet. How do i write the code after .Attachments.Add to get it to do this please.

Appreciate your help

[shubhammoonat]

Thanks for the video. I need some help! How can i send personalised email i.e name, code, etc.

[giteganesh]

Thanks sir .. but how we can send different excel attachment...and send at once to all

[leobuitrago]

A big THANK YOU...I must learn more about VBA

[nitinkhtri]

Please help me how can we add column in this same format

[satyatanna]

you guys are awesome! thanks a lot for this.

[logan]

Hello, so i am getting the hang of this. So when i put the line For i = 2 To Sheet1.Cells(Row.Count, 1).End(x1Up).Row it is appearing as an error 424: Object Required

[inspectorjavert]

Very useful Macro! thanks for sharing!

[nikhilkhandelwal]

This is awesome. How can i format outlook mail body text (for instance some text to be bold and some to be underlined”?.

[allabouttruckin]

If i make an email list on a sheet and later what is the easiest way to find 1 email out of 100 and delete if someone wants to cancel the subscription or dosent want to see our emails anymore

[khawajashekeb]

Hello, I want to send an automatic email to organization's employees containing their net salary which is transferred at the end of each month. Doing so, would help me to send emails to each individuals separately. Thanks.

[k.srikanthgoud]

Hello,

My Self Srikanth. First of all Let me thank you for the Video which eased and reduced my effort atleast 30%.

Here is my Query, Sometimes i need to Send eamils having Multiple recipients in To and CC Address fileds which i can't do with your trick. For example see below.

Inline image 1

I am showing this with gamil. i have the exact scenario in Outlook, Can you tell if this Can be done with your by doing some modifications in the Code.

it'll be very helpful for lot of people. request you to make a video based on above Scenario i am sure it'll become very popular!

Thanking you in advance for providing a Solution my Query.

[SUNILGAMINGYTFB]

Hi I have a column to z column data I want send data through outlook with to and cc multiple email reception
Please help do in macro recording

[nareshsharma]

Hi Sir, I hope you are very well, pls try to understand, I want to outlook mail move in separate folder in d drive (date wise folder like - march-1 & March-2 ....) If you can help

I m doing manually copy & ...

[Ivy-qqiy]

Hi Kamal, great video. Can you please add second part where you add attachments to the email or image to the email body. Also, what code needs to be added to convert to html?

[joyhr]

can you help me regarding the option to use the .to, .cc and .bcc directly