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

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.

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.

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

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.

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

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.

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.

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

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

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

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

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"

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

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

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

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

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

Legend mate. Thank you very much for this.

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

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

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

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

Thanks man you are a life saver!!!

Thanks a lot. Amazing macro. Very useful

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

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 :)

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

Thank you so much for this, eternal blessings to you

Thank you, its helped me a lot

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

Merci. Simple et efficace. Amicalement

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

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

Amazing tutorial.

Thank you so much. it's working fine.

Thank you very much

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

Thanks you sir ..for your support 🙏🙏

really useful information from your videos.

Thank you so much . it is very good.

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.

Very useful. Thanks!

Thank You Sir, It was great help

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

Thank you Sir It's really great

Thanks you're awsome dude !

thanks a lot!!

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

This is GOLD.

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

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

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

Very good work.

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

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.

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?

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

Very nice bro

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

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?

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

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

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

you are the best

Amazing bro 👌👌👌👌👌😃😃👍

Sir you Rock 👍

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

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.

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

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

Thank you bro

thanks PK

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!

You are the best man😎😎

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.

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

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

Thank you

Incredible.

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.

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

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

Gr8 brother!

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

Nice!

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

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?

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

thank you sir

Awesome... Dost..

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

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.

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

Amazing priyendra

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?

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

genius!

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.

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