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

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

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

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

[@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 kzbin.info/www/bejne/amnShquXgZyLbMU

[@virak981]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@balrajvirdee1087]

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

[@PKAnExcelExpert]

Most welcome🙏

[@0sutra0]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

[@vsrblr]

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

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

[@George-gf9tu]

Legend mate. Thank you very much for this.

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

[@deepamanmappy]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Divya_HareKrishna]

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

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

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

[@gabriela_sd260]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@viveksatpute3807]

Vivek Satpute Hello PK its absolutely a fantastic short and sweet code. I have been following some of your videos on KZbin 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.

[@pawansharma-wo3xh]

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

[@anooruproy3670]

U R 2 Good. People like u are required in KZbin.

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

[@kunalkhandelwal5293]

Thanks a lot. Amazing macro. Very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

[@johnyouseph4038]

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

[@PKAnExcelExpert]

Glad it helped

[@stefanozappala9625]

Thanks man you are a life saver!!!

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

[@33cem34]

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

[@infotech5520]

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

[@PKAnExcelExpert]

You're very welcome!

[@marcohama1]

Thank you, its helped me a lot

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

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

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

[@sushilchaudhari214]

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

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

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

[@haniff4277]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@redguy1993]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@m10k20032000]

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

[@landwaysinternational1333]

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

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

[@veemagaia8892]

Thank you so much for this, eternal blessings to you

[@PKAnExcelExpert]

Glad it was helpful!

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

[@keerthikap4915]

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

[@shamyukthastudio7817]

Thank you so much. it's working fine.

[@Tat-cx1lr]

Merci. Simple et efficace. Amicalement

[@noobgamerof90s]

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

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

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

[@ajayverma-hn3zt]

Thanks you sir ..for your support 🙏🙏

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

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

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

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

[@redguy1993]

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

[@tulip24r]

Amazing tutorial.

[@PKAnExcelExpert]

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

[@indorecablefaultworks8962]

Thank you so much . it is very good.

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@sp-prakash]

i have multiple excel workbooks in a folder which i need to send it to different people. the multiple list will vary every time. so i want a vba to identify these workbooks and send as attachment with the subject as a1 & G1 cell reference of the respective workbook. Could you help me out

[@sp-prakash]

really useful information from your videos.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@munnawritu]

Hi, I'm learning the Macro, just like a beginner, when I applied this macro I got a error " Can't execute code in break mode" can help me.. where I am getting wrong .

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

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

[@xiang_lu]

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

[@SN-fg3rc]

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

[@bajramo1]

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

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

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

[@saleemsadruddin8425]

Hi, How to add multiple files in each email

[@Jyotisharma-rr9ve]

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

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

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

[@yogeshjav8089]

Thank You Sir, It was great help

[@PKAnExcelExpert]

You are welcome

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

[@trapstar1998]

Can you set it where when a file gets dropped into a watch folder it automate an email with the attachment ?

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

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

[@prajnanks]

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

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

[@reubenmather8108]

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

[@rohannayal2818]

Thank you very much

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

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

[@dmt340]

hi, thank you, what about having the email go to drafts? I tried msg.save but when sending it bounces, have you experienced this?

[@nadeemasgher8724]

Sir i need your help actually i want to make like for example if i give like after 6 days that mail automatically go but like to different different people as per my content how i can make it

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

[@sakthivelcslm]

Hi, Is it possible to send reminder using a macro ? Is there any possibility to send followup / reminder using excel macro ? Reminder / followup should go automatically from 1st email which I send . Can you pls make video like sending remindera

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

[@DJdavefromlondon]

hi - on the body column, how did you get VBA to recognize your line spacing, you have 3 seperate lines, when I do it I get all the body on 1 line. Perhaps this is an excel setting to force a new line ?

[@vizzamis4088]

Thank you Sir It's really great

[@PKAnExcelExpert]

Most welcome

[@mirzahamzic6792]

Thanks! As someone already asked: how to add "SendUsingAccount" function to select from different Outlook accounts?

[@Eric-gz1uw]

Hi Bro, Did you fix this issue now?

[@Squashknee]

Hi Pk, how can I utilize this to use an outlook template that already has the body? Thanks!

[@divinemusic1822]

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

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

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