Automation: Send bulk emails using VBA and Outlook

[@AdamMad83]

Just wanted to thank you so much for the fantastic code !! So well put together and user friendly. For those that need to put two attachments I just added a column, an extra IF and shifted column letter in the code - I'm sure @PKanExcelExpert would come up with a more eloquent solution....
Anwayz,... just replace the portion between "msg.body = sh.Range("D" & i).Value" and "Next i" with the below and add a column in the excel so E F are for attachments and G is that sent status.
If sh.Range("E" & i).Value "" Then
msg.attachments.Add sh.Range("E" & i).Value
End If
If sh.Range("F" & i).Value "" Then
msg.attachments.Add sh.Range("F" & i).Value
End If
msg.send
sh.Range("G" & i).Value = "Sent"

[@PKAnExcelExpert]

Hi Adam,
You have done fantastic job to send two attachments.

[@ganeshkrishnan4021]

I was looking for multiple attachment method .. thanks a lot for above.. I have simply repeated same formula for Columns E,F,G,H and worked like charm.. much appreciate all the help

[@hemantjethwani380]

I have used this code and i am very happy to see the magic.....
Just wanted to add one thing.....Files saving should be in Micro enable workbook.

[@chajam]

dude, thank you so much! I was looking for a simple VBA that could do the work until I found your video, and that’s all I needed.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@balrajvirdee1087]

Thanks again brother, really appreciate you putting this tutorial out there. We can all learn a lot from you. 👍🏽

[@PKAnExcelExpert]

Most welcome🙏

[@Teesriflight]

Oh My God, PK Bhai. You killed it man. You made me a hero in my office. Thank you very much. God bless you bhai :)

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@javedrasheed9200]

Hi sir ...i have a few doubts about the macro.. kindly assist me

[@gabriela_sd260]

Best teacher! Best of the Best! Best videos! Thank you, Kumar!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@0sutra0]

This is a life-saver! You are a VBA hero

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anooruproy3670]

U R 2 Good. People like u are required in UA-cam.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vanessamayer3437]

This is fantastic! So useful and can be used over and over. Thank you!

[@lorddalhousie807]

Thanks Pal, you really helped. "Thanks" is just the word but I mean it a lot more than this.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lorddalhousie807]

@@othernewsid2 I just wanted to find a bad name with which I ever do some bad things. So I found this name. I always use this email for fake registration, watching po*n etc. I hate Lord Dalhousie who ruled over us for years. I'm an Indian and I love my nation.

[@jonneygadder]

If I had to send 2000 mails then I had to click 2000 times.. great I love it

[@minhnguyennhat3547]

Thank you so much!!!! Worked flawlessly and like a charm with no effort from my side! Really useful and super thank you for sending us your sample, really appreciated!! Wish you best of luck

[@PKAnExcelExpert]

Thanks for your valuable feedback. Request you to please share this with your friends and colleagues

[@arjunbabu83]

Thanks for very much for the video.
I wrote my first program learning from you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nemaznachenie9997]

you are amazing, the way you show everything, how you explain it and your instructions are fantastic. Thank you very much. I liked your video and subscribed to your channel.

[@infotech5520]

Thank you so much for sharing your knowledge its absolutely a fantastic short and sweet code

[@PKAnExcelExpert]

You're very welcome!

[@noobgamerof90s]

Thank you so much Sir it helped me in office to minimise my workload ❤️❤️

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@HHHGeorge]

Mr. Kumar, that was a truly excellent and informative video. I am very impressed with your style of coding and presentation. Everything explained, at the right pace with working results. You now have another subscriber. Thank you.

[@veemagaia8892]

Thank you so much for this, eternal blessings to you

[@PKAnExcelExpert]

Glad it was helpful!

[@JyotiKumari-tm4kz]

I needed to send few thousand emails, which I was able to do it within with minutes with your code...thanks

[@PKAnExcelExpert]

Glad it helped!

[@trevormeisel]

Excellent video - direct and to the point. I think you forgot the very last part where you update the sent column but most users should find that easy enough to do.
Thanks for the video and keep up the great work. I'm going to look through all your other videos now with the time I have saved on this particular challenge.
Regards, Trevor

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@redguy1993]

thank you so much for this. you're a lifesaver

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sp-prakash]

really useful information from your videos.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vsrblr]

Nice video. Explanation and making was awesome. Lucky to have your videos on this subject

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@allengilbert8836]

You are the best man😎😎

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@johnyouseph4038]

Thanks a lot. This one I was trying to fix it. This video helped a lot 👍👍

[@PKAnExcelExpert]

Glad it helped

[@SuperHanme]

Dear Sir, Thank you so much. You are so smart software developer. I learn a lot from you. I appreciate it.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@HRVS_DZ]

Thanks you're awsome dude !

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@environmentalsustainabilit1102]

Very useful. Thanks!

[@PKAnExcelExpert]

Glad it was helpful!

[@jannacalaunan3413]

This is GOLD.

[@PKAnExcelExpert]

Thanks 👍

[@pawansharma-wo3xh]

Extremely useful for sending the bulk mails
Very very creative PK...... great
However little difficult to understand..

[@deepamanmappy]

That's really incredible thanks a lot for sharing this wonderful experience

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@stefanozappala9625]

Thanks man you are a life saver!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@thebaigs258]

Amazing priyendra

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rabinderca]

you are the best

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@virak981]

Very appreciated and thank you for your kind sharing the knowledge. All the best to you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gunjangyansagar4571]

Thanks sir, very happy really it for my official help..

[@jwalker4765]

Awesome video! Thanks for sharing! Two questions:
1. Is there a way to add a signature into the text body?
2. Is there a way to send the e-mails from a shared e-mail address in Outlook instead of your primary e-mail address?

[@excelonlineadvisor]

1. You can add the signature on the mail text body.
2. Set your default e-mail address as primary email account in outlook. Hope it will help.

[@mc.roneilfuggan1780]

i have image signature how to add that

[@ashishvariya1960]

Sir you Rock 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MrRanjitsihag]

Amazing bro 👌👌👌👌👌😃😃👍

[@yogeshjav8089]

Thank You Sir, It was great help

[@PKAnExcelExpert]

You are welcome

[@bharatchaudhari5694]

Great Help.
Just suggest to make it more powerful.
1. How to stop if already emails that are shown "sent" status.
2. Schedule for particular date and time.

[@shamyukthastudio7817]

Thank you so much. it's working fine.

[@vizzamis4088]

Thank you Sir
It's really great

[@PKAnExcelExpert]

Most welcome

[@ajayverma-hn3zt]

Thanks you sir ..for your support 🙏🙏

[@haniff4277]

PK. I enjoy your training videos. Keep it up....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Tat-cx1lr]

Merci. Simple et efficace. Amicalement

[@marcohama1]

Thank you, its helped me a lot

[@deepakmittal9449]

Very good work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kunalkhandelwal5293]

Thanks a lot. Amazing macro. Very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Divya_HareKrishna]

Its very helpful thanks a lot 👍
And
Thank u for sharing file as well..

[@ursvenky6394]

Ur explanation is awesome, can u do video on how get email info? Only unread mails, only readmails, which account like that? If we have multiple accounts, we need to get from all inbox, or selected accounts. Please pk it is more helpful to ur followers. Thank u in advance.

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video very soon. It is a great suggestion.

[@avisekguchhait3508]

Incredible.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@avisekguchhait3508]

@@PKAnExcelExpert but some error sir, on attachment. Can you help me sir?

[@ashishsachdev6154]

Thankyou PK, your videos are so informative and help us a lot to make our job easier. Please keep on sharing your knowledge an God Bless you. I would request for one query that can we set a timer of multiple reports I have made in advance and fix it in excel so that the reports would automatically get sent by its defined timeline.

[@PKAnExcelExpert]

Thanks for your valuable feedback. Yes we can use schedule in VBA. I will definitely try to make such video very soon.

[@indorecablefaultworks8962]

Thank you so much . it is very good.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sanavianwar]

Thank you so much Brother..........

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tajuddinidrisi6610]

thanks PK

[@PKAnExcelExpert]

Welcome

[@BaankeBaabu]

you are legend man..but only issue m facing is displaying and able sent manually received the same mail in inbox...greaatttt dude......but ple solve the issue not going auto...

[@krunalgandhare4026]

Amazing!! Keep up the good work sir! saved lot of my time! But faced difficulty sending mails via outlook using gmails' email id.. please help to fix!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AnupKumar-bk4gj]

Thanks PK, really this will help me a lot. What i should do if i have more than one attachments. Kindly let me know. Thanks

[@shantaneelhalder2692]

Thank you the video. Very helpful. Can you please also help, as how I can add different sets of email I'd in the cc column?

[@katerinabilleisen6613]

This is great! My question is how can you automatically add signature to all the outgoing emails? I have it set to add signature automatically when I send emails but it doesn't seem to work with this bulk email file.

[@ibrahim82649]

Hey PK, you videos are very useful. I am having tried working on my own template and followed every procedures you have shared but when it comes to running the macro to display the emails my work book just keeps running the out look application doesnt pop up.

[@aussieraver7182]

Nice!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ahmedsherif5698]

Thank you

[@PKAnExcelExpert]

Welcome

[@George-gf9tu]

Legend mate. Thank you very much for this.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DineshVishwakarma-sp5uf]

Very Good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DeepakSingh-pd8nu]

thank you sir

[@PKAnExcelExpert]

Most welcome

[@harryharry2109]

This is super useful. I want to know how can i bypass this allow button so that I don't have to click on it everytime while sending the mail.

[@vishalsingh127]

Very nice bro

[@ajithprasath7815]

Thank you very much PK san. Thank you for posting videos. I want how to automatic remainder mail in Excel VBA programming. Please guide me

[@riteshvishwakarma9595]

Thank you for share wonderful video, how we can add one more attachment in same mail (i want to sent mail with 2-3 attachment). please suggest.

[@reubenmather8108]

thnx sir ji..........for making the video

[@ekosoejudi9998]

god bless you

[@amitmishra1513]

Can we send emails through outlook, email content is present in specific word document and email list present in excel file using excel OR word vba need to send emails like mail merge??

[@FRAN-vd9rl]

Hi, great simple macro you created, cheers!, Two questions: 1) what if i want to send more than one attachment? is it possible? 2) how can i insert some image in the body of the email? or some type of formatting like bold underlines sizes? Thanks

[@muhammadsulemanahmad197]

How can I increase size of text/ formatting
Any one help please

[@rohannayal2818]

Thank you very much

[@bridgetalulema3312]

Hi! This was very helpful! I noticed in column F you have a status section. How do you tell the macro that in column F, the email has been sent. That's very helpful to make sure you have a double check the email has been sent and not rehitting the macro again to send a duplicate email.
I also noticed that the font in the body of the email is small, is there a way to add a code to have the font a certain size in the email. Appreciate any help! Thanks!

[@AMStallions]

Same query. PK Excel expert we demand an answer.

[@durgesh91tomar]

Awesome... Dost..

[@PKAnExcelExpert]

Thanks Durgesh

[@arjunc1936]

Thank you bro

[@PKAnExcelExpert]

Welcome

[@amitmishra1513]

Nice explanation!!!
Can we send email from gmail account using excel vba?

[@selimakcakil2325]

Thank you it is very simple and working perfectly. Just one question if I would like to send more than 1 attachment to the same person how should I adjust attachment column. Thank you

[@selimakcakil2325]

I fixed with adding additional column (F) than repeated code for column E. Thank you again.

[@PKAnExcelExpert]

Thanks

[@sagarmarri2728]

Awesome.....if we don't want to click on allow everytime...what is the option ???

[@tulip24r]

Amazing tutorial.

[@PKAnExcelExpert]

Thanks for your valuable feedback. Request you to please share this with your friends and colleagues

[@vijaykulkarni7724]

Many thanks for sharing such wonderful video. I also want to know that do you have any Macro by which we can send reminder on same email which we have send using this Macro.

[@PKAnExcelExpert]

Will upload soon

[@vijaykulkarni7724]

@@PKAnExcelExpert thanks even if you share code to pop out email in reply all mode using subject will also do

[@AmitRoy-xg8ph]

Amazing.... Thnx for sharing the Tutorial PK. Can we send multiple attachments like this to multiple person?

[@PKAnExcelExpert]

Yes, absolutely

[@AmitRoy-xg8ph]

@@PKAnExcelExpert can you please share a video on that, how can we send a mail through vba with multiple attachment please...

[@eaglehew9518]

Thanks, is very helpful. Kindly need your help, may I know how to insert the attachment?

[@preethamacharya]

How can I do Allow to all at the end of the macro as I am looking to send it across to 400 odd participants?

[@ben-thought1182]

Thank you pk. How about the status as sent? How do I declare it in vb to display if the message is sent?

[@letsreasontogether3496]

Thank you this is fantastic. Just what I needed!!!
1 question... How do I format the text in the body?

[@vacilando86]

Thank you so much. it's working fine. But I would lite to send all emails automatically without Allow buton. How to build it ?

[@prajnanks]

Thank you very much👍👍
But i also want to learn reminder mail bulk with the same subject

[@nihitmhatre2241]

Thank you Sir for awesome video, I’m learning macro and I try this code. I save this file in my system and try to change file name but after changing file name I’m getting error

[@melissaaguirre3193]

Hello thanks so much for this- can I add a line to change the from address ? I use a generic email address to send out mass emails but outlook defaults to my email instead of the generic one - maybe adding msg.from? And adding a column with the generic email address?

[@kehindeolajide6870]

Great Video and really helpful. Thanks for sharing. one question pls. is there a way to add hyperlinks to the email body instead of attachment?

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@kehindeolajide6870]

@@PKAnExcelExpert Thank you

[@davidecardella8585]

Hi mate, this video is amazing! Really. I have just two questions. Can you please help on on to set the sender email (msg.from looks not working) and on how to ask the tool to send just an email corresponding to a specific line istead of the entire sheet? Thanks in advance

[@PKAnExcelExpert]

To add the "From" email id, you can watch the below video:
ua-cam.com/video/4buxxnoNMKE/v-deo.html

[@kaknikachamroeun4810]

Thank so much for your useful VBA. However, how can I also include my HTML outlook signature when running this code? Really appreciate for your kind help.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kaknikachamroeun4810]

@@PKAnExcelExpert Please also help me what VBA code should I add to also include my outlook signature? Thank in advance.

[@vipulshankar1031]

Sir, how we can send automatic email reminders as if stocks gets empty, it will send mail automatically

[@rrvillareal2011]

How about, if you want it to automatically, allow, instead of you clicking allow all the time? What code do you use?

[@mdasifiqbal1972]

I have been using this XML, but can you also develop and xml which identifies unique statement to be sent not as an attachment but on the body of the mail

[@MultiChanelo]

Hello PK, thanks alot for sharing such important tips.
But I have a question : how do I do to attach more than one file on each email?

[@PKAnExcelExpert]

Of course! If you're looking for a more detailed guide on how to attach multiple files to an email, we've already created a video on this. Please follow this link to view the video: ua-cam.com/video/4buxxnoNMKE/v-deo.html. This should give you a clear, step-by-step walkthrough. Let us know if you have any other questions!

[@loldarshan4235]

Thank you so much for this ,can u plz tell me how can we add image to body ,or how can we send bulk image mail? Plz

[@kamalakkannank2239]

Me also please

[@wendyanugrah]

Yes please, can u share with pictures in body emails?

[@adamliang8567]

YES pleasseeee

[@raselmia961]

Me also please...otherwise 😭