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"
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
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.
@@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.
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?
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.
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.
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...
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.
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.
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.
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, 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
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
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??
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: th-cam.com/video/4buxxnoNMKE/w-d-xo.html. This should give you a clear, step-by-step walkthrough. Let us know if you have any other questions!
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
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
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
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
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!
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.
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?
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
awesome video tutorial easy to understand. also is it possible to use a different email program other than outlook? is it a settings in excel or do I need to change "Outlook.application"? I did try to change it but its just an error any tips?
As per your given precious guidelines, I have done it successfully except getting message in specified "Mails Sent". The message how to show in specified field ? Help me.
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"
Hi Adam,
You have done fantastic job to send two attachments.
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
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.
Best teacher! Best of the Best! Best videos! Thank you, Kumar!
Thanks for your valuable feedback🙏
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.
Thanks for your valuable feedback
Thanks again brother, really appreciate you putting this tutorial out there. We can all learn a lot from you. 👍🏽
Most welcome🙏
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 for your valuable feedback🙏
Hi sir ...i have a few doubts about the macro.. kindly assist me
This is a life-saver! You are a VBA hero
Thanks for your valuable feedback
U R 2 Good. People like u are required in TH-cam.
Thanks for your valuable feedback
Thanks for very much for the video.
I wrote my first program learning from you.
Thanks for your valuable feedback
Thank you so much Sir it helped me in office to minimise my workload ❤️❤️
Thanks for your valuable feedback
Thank you so much for sharing your knowledge its absolutely a fantastic short and sweet code
You're very welcome!
Thank you so much for this, eternal blessings to you
Glad it was helpful!
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.
really useful information from your videos.
Thanks for your valuable feedback
If I had to send 2000 mails then I had to click 2000 times.. great I love it
You are the best man😎😎
Thanks for your valuable feedback
Thanks Pal, you really helped. "Thanks" is just the word but I mean it a lot more than this.
Thanks for your valuable feedback
@@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.
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?
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.
i have image signature how to add that
I needed to send few thousand emails, which I was able to do it within with minutes with your code...thanks
Glad it helped!
thank you so much for this. you're a lifesaver
Thanks for your valuable feedback
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.
Very useful. Thanks!
Glad it was helpful!
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.
Thanks for your valuable feedback. I will definitely try to make such video very soon. It is a great suggestion.
Thanks a lot. This one I was trying to fix it. This video helped a lot 👍👍
Glad it helped
This is fantastic! So useful and can be used over and over. Thank you!
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 the video. Very helpful. Can you please also help, as how I can add different sets of email I'd in the cc column?
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...
Nice explanation!!!
Can we send email from gmail account using excel vba?
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.
This is GOLD.
Thanks 👍
Nice video. Explanation and making was awesome. Lucky to have your videos on this subject
Thanks for your valuable feedback
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.
Extremely useful for sending the bulk mails
Very very creative PK...... great
However little difficult to understand..
you are the best
Thanks for your valuable feedback
Amazing priyendra
Thanks for your valuable feedback
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.
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.
1) How can we save these emails into Drafts? So that i can check and send them later. 2) Does this work with Outlook web app too?
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.
Thanks for your valuable feedback. Yes we can use schedule in VBA. I will definitely try to make such video very soon.
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!
Thanks for your valuable feedback
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
How can I increase size of text/ formatting
Any one help please
Awesome.....if we don't want to click on allow everytime...what is the option ???
Thanks sir, very happy really it for my official help..
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
Thanks for your valuable feedback
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??
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?
Great suggestion! I will try to create a video on this topic.
@@PKAnExcelExpert Thank you
How about, if you want it to automatically, allow, instead of you clicking allow all the time? What code do you use?
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?
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: th-cam.com/video/4buxxnoNMKE/w-d-xo.html. This should give you a clear, step-by-step walkthrough. Let us know if you have any other questions!
Thank you pk. How about the status as sent? How do I declare it in vb to display if the message is sent?
Nice video, if I want to select sheets within workbook and send email how to achieve that?
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
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
To add the "From" email id, you can watch the below video:
th-cam.com/video/4buxxnoNMKE/w-d-xo.html
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
I fixed with adding additional column (F) than repeated code for column E. Thank you again.
Thanks
Dear Sir, Thank you so much. You are so smart software developer. I learn a lot from you. I appreciate it.
Thanks for your valuable feedback
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?
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.
PK. I enjoy your training videos. Keep it up....
Thanks for your valuable feedback
Sir you Rock 👍
Thanks for your valuable feedback
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
Thanks for your valuable feedback. Request you to please share this with your friends and colleagues
Thank You Sir, It was great help
You are welcome
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.
Thanks, is very helpful. Kindly need your help, may I know how to insert the attachment?
Amazing bro 👌👌👌👌👌😃😃👍
Thanks you're awsome dude !
Thanks for your valuable feedback
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
Thanks man you are a life saver!!!
Thanks for your valuable feedback
Thank you Sir
It's really great
Most welcome
Thank you so much. it's working fine. But I would lite to send all emails automatically without Allow buton. How to build it ?
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!
Same query. PK Excel expert we demand an answer.
Very good work.
Thanks for your valuable feedback
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.
Will upload soon
@@PKAnExcelExpert thanks even if you share code to pop out email in reply all mode using subject will also do
Thank you so much. May i ask how to add the status "Sent" as it shows in your video. but there are no code for it?
That's really incredible thanks a lot for sharing this wonderful experience
Thanks for your valuable feedback
GREAT HELP SIR!! IS THERE A WAY TO ADD SIGNATURE TO THE BODY THOUGH?
Amazing.... Thnx for sharing the Tutorial PK. Can we send multiple attachments like this to multiple person?
Yes, absolutely
@@PKAnExcelExpert can you please share a video on that, how can we send a mail through vba with multiple attachment please...
wonderful and helpful video, can you help me how to change the default email ID or send the email from a different email ID.
Thank you. Helpful code. How to send body with html text?
Please watch below video for HTML body-
th-cam.com/video/q9kTgTghN2g/w-d-xo.html
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?
good video its help alot , but not able to download excel sheet from link..
Thank you so much. it's working fine.
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
thanks PK
Welcome
excellent work. quick question, what if in each bodu you want to type Hi [name] and the rest of your text, is there any way to automatize this ?
Very nice sir... Is it possible to send bulk emails using gmail or rediff. If yes then plz make video...
Incredible.
Thanks for your valuable feedback
@@PKAnExcelExpert but some error sir, on attachment. Can you help me sir?
It's very helpful. I have copied the code & it's working. But sir I did not get the interface with "allow" option.
Thanks for your valuable. It means you have already allowed programmatic access. So don't worry 😉
@@PKAnExcelExpert sir but I want get the interface. Can you tell me how I get this
awesome video tutorial
easy to understand.
also
is it possible to use a different email program other than outlook?
is it a settings in excel or do I need to change "Outlook.application"?
I did try to change it but its just an error any tips?
Thank you sir ...
Sir is it possible to send same mails using Gmail...
If yes, please make video on it...
Please reply...
Excellent vidio it work very well. Can you explain how to do this using WhatsApp with PC
Nice!
Thanks for your valuable feedback
This is an excellent video. Need to know how can i bold or change format for a particular line
Very appreciated and thank you for your kind sharing the knowledge. All the best to you.
Thanks for your valuable feedback
Please make same video using Gmail account instead of outlook...
It will save my time...
Please reply sir...
will upload soon
@@PKAnExcelExpert desperately waiting for your video...thank you very much sir....
Thank you very much👍👍
But i also want to learn reminder mail bulk with the same subject
Thank you, its helped me a lot
Very good thanking you. Pls. Tell me, how can I attach two or more attachment ?
As per your given precious guidelines, I have done it successfully except getting message in specified "Mails Sent". The message how to show in specified field ? Help me.
Merci. Simple et efficace. Amicalement
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.