Automation: Send bulk emails using VBA and Outlook

Hello Friends,
In this video you will learn how to send multiple email with attachment by using Excel VBA and Outlook.
Please download this excel file from below given link:
www.pk-anexcelexpert.com/send...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkan-excel-expert-9748...
Pinterest:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert

[@vanessamayer3437]

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

[@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

[@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

[@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.

[@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.

[@ResortRadar]

This is so helpful, I can't thank you enough. I have macros which split a large report into single files and then saves it to a shared drive. I can now take it a step further and automate the distribution process.

[@petropillati9463]

Hey Benjamin can you share a video of the macro that splits a large report in sigle files and then saves it?

[@Teesriflight]

Benjamin Can you share the macro for spliting a large report into single files

[@TheMissSELane]

@@Teesriflight th-cam.com/video/48oUxaL7X6c/w-d-xo.html

[@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

[@virak981]

Very appreciated and thank you for your kind sharing the knowledge. All the best to 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.

[@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

[@0sutra0]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@George-gf9tu]

Legend mate. Thank you very much for this.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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.

[@balrajvirdee1087]

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

[@PKAnExcelExpert]

Most welcome🙏

[@Divya_HareKrishna]

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

[@gabriela_sd260]

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

[@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

[@deepamanmappy]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Tat-cx1lr]

Merci. Simple et efficace. Amicalement

[@kunalkhandelwal5293]

Thanks a lot. Amazing macro. Very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anooruproy3670]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@letsreasontogether3496]

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

[@sumitacer]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sumitacer]

@@PKAnExcelExpert Sir , i m unable to Joined in Telegram

[@stefanozappala9625]

Thanks man you are a life saver!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arjunbabu83]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pawansharma-wo3xh]

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

[@marcohama1]

Thank you, its helped me a lot

[@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

[@veemagaia8892]

Thank you so much for this, eternal blessings to you

[@PKAnExcelExpert]

Glad it was helpful!

[@redguy1993]

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

[@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

[@shamyukthastudio7817]

Thank you so much. it's working fine.

[@infotech5520]

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

[@PKAnExcelExpert]

You're very welcome!

[@haniff4277]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tulip24r]

Amazing tutorial.

[@PKAnExcelExpert]

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

[@viveksatpute3807]

Vivek Satpute
Hello PK its absolutely a fantastic short and sweet code. I have been following some of your videos on TH-cam and could conclude that codeing is exceptionally professional and easy to understand. I have been working in Automotiove OEMs from past 22 years and found this very useful for automating some of my team's task to increase their efficiency.
The only question in this auto email , when there is a promt to allow sending mails appearing on the screen , can we not overcome this so that the mails can go without any decision from user.

[@indorecablefaultworks8962]

Thank you so much . it is very good.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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

[@sp-prakash]

really useful information from your videos.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ajayverma-hn3zt]

Thanks you sir ..for your support 🙏🙏

[@harshahittara-gedara6647]

Hi PK, thank you so much for sharing your knowledge with us. You have done excellent job explaining things step by step. My email signature has company logo picture and special texts. I was able to include signature with company logo by using your “Send Mail with Snapshot” VBA codes. But I don’t know how to combine both this VBA and Snapshot VBA so I could send multiple mails with attachments while my signature will display as desired. Can you please help me?

[@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

[@mayelasanchez560]

Thank you so much for this video. I was wondering if you can tell me how I can I attach different type of files (like PDF, Excel, DOC) all in one folder

[@rohannayal2818]

Thank you very much

[@landwaysinternational1333]

Hello, congratulations for the really nice work. What if I want to include several columns in the body section ?

[@reubenmather8108]

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

[@yogeshjav8089]

Thank You Sir, It was great help

[@PKAnExcelExpert]

You are welcome

[@noobgamerof90s]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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.

[@marshallrego1053]

Hello,
This is an amazing video, I just need help on how can you send only a particular row data in a table format in the outlook body could you please help

[@33cem34]

Thank you PK, and one more question:how to add "SendUsingAccount" function to select from different Outlook accounts?

[@asadhusain4608]

Hi PK! Very useful video. I have a slightly different requirement. I created HTML based email (saved as DRAFT) which I want to send out to several recipients. As excel will NOT support HTML format, what amendment(s) do I need to make in your macro so that instead creating a mail, the macro uses a particular draft email. Will be a great help. Appreciate your work. Cheers

[@keerthikap4915]

Hi, the video is useful. Thank you so much. Please share us the code for Status field(how to update the status column)

[@vizzamis4088]

Thank you Sir
It's really great

[@PKAnExcelExpert]

Most welcome

[@gunjangyansagar4571]

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

[@m10k20032000]

? Thank you very much for the wonderful video, i have one question Can i add photo to the body like my signature

[@zyvsoo311]

Thanks for this video.
I want to know how to send the Excel data with use range of any person's name or code or drop down via VBA paste in outlook mail body with the common mail draft..
If possible please help me friend

[@TastyHubv]

Thanks for the video sir. For attachment we have to specify path specific folder.. its good.. what if file name changing everyday and send that latest file as an attachment... Pls

[@HRVS_DZ]

Thanks you're awsome dude !

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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.

[@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.

[@environmentalsustainabilit1102]

Very useful. Thanks!

[@PKAnExcelExpert]

Glad it was helpful!

[@MrPorkered]

Hi PK thanks for this awesome video, but how do I insert my outlook signature to all the emails? And also how should I format the text to bold or different font. Thank you.

[@Jyotisharma-rr9ve]

Thanks for the Amazing Video PK. Can you please tell me how can I sent multiple attachments

[@SN-fg3rc]

This is an excellent video. Need to know how can i bold or change format for a particular line

[@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!

[@sanavianwar]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@joelrajan3197]

Thankyou PK. Great video. Is there a way to insert the table - Range(("A:G") & i) for each row in a loop

[@bachhoangquan3631]

Hi @PKanExcelExpert, great video sir !!!!. I just have 1 question: How should I modify this VBA code to send multiple attachments in the email ?

[@sushilchaudhari214]

Thanks for the video. I have a requirement where an email body has multiple hyperlinks in it. can you pls help?

[@AlyssonLucatto]

Amazing video and tutorial, just on thing, the second email on my list is receiving 2 attachment, and the third email 3 attachments, can you help me with this?

[@jannacalaunan3413]

This is GOLD.

[@PKAnExcelExpert]

Thanks 👍

[@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

[@prajnanks]

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

[@divinemusic1822]

Hi PK It was great code, could you tell me how to put filters to the flow of emails .

[@aleashamascarenhas9906]

thanks very much Sir for this!! it works perfectly except when the first row has an attachment path and the second row does not. The second email is displayed with the first attachment. Would you know how to resolve?

[@ivans9655]

The best video, thank you! Do you now how to use HTML with VB?

[@anakalandarishvili9981]

hi this is amazing tool and thanks for the template. is it possible to add signature after body?

[@bonithird6303]

I wanted to send not on my email alias but from a team distro.. is this possible? Great tutorial by the way. Helped me a lot.

[@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...

[@vishalshinde29]

Hi PK...Amazing macro...Thanks a ton!!!! One query, how con we modify this macro for using shared Outlook Account instead of Primary? Awaiting for your reply...

[@bajramo1]

Hi, wonderful project, but instead of Outlook, can I use Thunderbird mail client?

[@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

[@naveenpandey7092]

Sir, your video is realy helpful. I would like to know how can I send email from generic email id instead of personal email id. Looking for your response, please suggest.. Thanks in advance

[@SA-nq2il]

This is really helpful video...thank you...
Sir...how to attach signature html file in your coding can you please help? And is there any option for clicking allow button again and again

[@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 😭

[@willleak3737]

Thank you so much for this video! I have one question....how would I modify this macro to send the email from a shared outlook account instead of my primary outlook account?

[@wweindiahighlights]

Dear will.. That's what am looking for.. Do you have the solution?

[@enedakosta7359]

Hello Sir, thank you for your macro.It was my first one and i'really excited. It doesn't work for me the subject. Can you please help? thanks indeed

[@deepakmittal9449]

Very good work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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

[@aparnavegendla]

thanks a lot!!

[@PKAnExcelExpert]

Thanks for watching

[@massimoaldorasi9850]

Thank you so much PK, this is amazing! Is there a way to add read receipt and mark as important?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Yes it is possible. I will definitely try to make such video

[@midhunkannan4801]

Hi bro when we can expect this video?

[@Shlok0811]

hi,
i had seen your video and it's very help full, just required a help on the same video with a extra as per this video we are attaching the attachment from mentioned cells with that i required to open the same workbook and copy data from specific sheet from that workbook and paste the summary on the body, can we do this? please rply me on this,

[@midhunkannan4801]

Hi bro,your video really helped me a lot.how do I send with high importance?and is there any option to get automatic notification in excel with response received in a column?

[@xiang_lu]

MANY THANKS! PK. Just one question, how to create a status sign, "sent"? Thanks again.Lux

[@redguy1993]

Hi, may i know if there's a way to insert a table in the 'body' part based on a cell value?

[@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.

[@vishalsingh127]

Very nice bro

[@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

[@DineshKalel]

Sir, this is very useful... Now I want get data from out look to excel . but I want only table data. Please help on this with VBA thanks in advanced.