Hi sir i edited my message to thank you so much for this video i had a question before but it was solved Thank you again for the explain it was awesome, clear and useful in real life
Very nice sir ,u r really great and doing great work as teaching such important techniques and subject which helps every individual stand out from others
Thanks for the video! What if I need to attach certain lines coming from a table to the body of the email? For example, in a table with 5 lines, I will be sending lines 1 & 2 to the 1st email and the next 3 lines to the next email?
Great. Thanks. Going to use it for sure. It's channels like this that gives me inspiration and motivated me to also start my own channel. Hopefully I will have 100 Subscribers soon so I can create my own URL for users. That would be great. Thanks for your hard work and keeping the users motivated and informed.
What to do in case if I wants to add multiple organization names through excel sheet in Subject field? 1) I am actually looking for mail merge to send queries to different companies to get the quotation. Like for example in "To" field I could use multiple e-mail addresses and also in "Cc" too. 2) How do we draw a table and insert our data in it and send queries by mail through Macros? 3) Can we design a specific form or template and whenever I want to send queries to different organizations it will directly obtain the data from excel sheet and link with the template?
Thank you sir for this valuable information, it is really great. I have a similar requirement, where we would like to send birthday cards as images in the outlook email along with the image of the person on that image card whenever his/her birthday comes. Is there any way to achieve this requirement, so that these emails gets shoot automatically when the person's birthday comes. Looking forward to hear from you!
Hi PK, Thanks for this amazing video. I am facing one problem. when I am setting option button as display and running the For loop. It is only showing the person's draft. others are somehow disappearing and also not showing in draft. I tried to ".save" but still no success. how can I see all the mails which I am drafting through this code.
Ram ram my friend, thank you so much for your video. I have a question, is that possible somehow to skip this pop up windows where we need to press send to each of the email? Just run macro and then all the emails will be send automatically without clicking on send button in the outlook. Thank you so much in advance!
I want to add a neme list to the email body. And that list range keeps changing. It means Row count is fluctuating. Please teach me the way to do that.
This is a great video. Found this after finding your first video that didn't show you how to add in signatures. It looks like the download link for this document / macro in the description isn't working currently. Are you able to update it?
I stand corrected. It was timing out on our office network but as soon as I tried it from my phone it worked. Guess I have some other bugs to work out. I'm good now. Thanks again for these informative videos.
Hello Sir, Thank you for sharing and this is very useful. But I need to send it from a generic mailbox using the same code. Please help me with the codes. Please reply.
Thanks PK for this video & utility tool. I have a question. What will be code if our headings are in 02 rows. For example, headings are- A1 (Merged A1 to A2) = Name B1(Merged B1 to D1) = Quantity B2 = Target C2 = Achievement D2 = Balance E2 = Mail id Values would start from row 3 Please reply.
sir i have purchase a new laptop & preinstall 2019 excel some day i will work smooth but now a days shortcut key Alt +E+S+V is not work for excel sir but i have anydesk to other pc work than work this shortcut but not work in my laptop how to fix this issue sir please rply
Thank you for the video, i really appreciate. One question i have, can you please tell - how to remove extra spacing( 2 line breaks) before signature. Thanks and regards Sajid
Everything works perfectly in display but when I press send I get a "run-time error '287: Application-defined or object-defined error." Can anyone tell me what I am doing wrong?
Cannot thank you enough. So clear and precise. Keep up the good work. God bless.
Hi sir i edited my message to thank you so much for this video i had a question before but it was solved Thank you again for the explain it was awesome, clear and useful in real life
You are most welcome
Best video EVER EVER EVER on mail with vba - you save me a huge of time (and maybe also my life :) ) THANK YOU!!!
Glad it helped!
You are the best! Fantastic simple explanations that are very very clear. You are doing a great job. Please continue forever!
Thanks for your valuable feedback
PK, you never disappoint! Excellent job my friend.
Thanks a lot.
Dear PK - amzing trick and very well explained - brilliant show , thanks a lot Priyendra Kuamr ji
Thanks for your valuable feedback
Thanks a lot! Amazing explanation, simple, clear and getting right into the point!
Glad you enjoyed it!
Thaq.... Soo soo much.... I was searching for this kind of issues like adding signature, adding new line it's very useful video.
Thanks for your valuable feedback
sir ji, very very helpful and practical video. you are genius!!!
Thanks for your valuable feedback
Thanks ... easy to understand
Thanks for sharing such a great useful utility. Very much useful. Always waiting for your informative videos. Thanks once again 🙏
Thanks for your valuable feedback
Enjoyed it. Excellent
Glad you enjoyed it
Very nice sir ,u r really great and doing great work as teaching such important techniques and subject which helps every individual stand out from others
You are a genius!
Thanks
Helpful... Made my work easy :)
Thanks🙏
Excellent PK
Thanks for your valuable feedback
So good, exactly what I was looking for. Cheers.
Thanks for your valuable feedback
As always you are👍👍👍👍👍
Thank you so much 😀
Great video bro 👍keep up the good work.
Thanks for your valuable feedback
Bro..how do we send with high importance?
Very helpful, thanks😊
Thanks for your valuable feedback
Waaaaw great
Thanks for your valuable feedback
Your videos are best and easy to follow... Plz help to replace outlook with lotus notes mail
Thanks for the video! What if I need to attach certain lines coming from a table to the body of the email? For example, in a table with 5 lines, I will be sending lines 1 & 2 to the 1st email and the next 3 lines to the next email?
sir, thanks for sharing, this is very helpful.
Thanks for your valuable feedback
sir i have problem once click send and run as follow your instruction, is there any missing code? due to the tutorial just explained display button
GREAT. Thank you so much.
Thanks for your valuable feedback
Great Mr PK, kindly requesting you to add Attachments also please
Great. Thanks. Going to use it for sure. It's channels like this that gives me inspiration and motivated me to also start my own channel. Hopefully I will have 100 Subscribers soon so I can create my own URL for users. That would be great. Thanks for your hard work and keeping the users motivated and informed.
Thank you sir! The video was really helpful. Request you to advise how we can extract multiple row data in single email using above code.
Will try to create a video on this topic.
@@PKAnExcelExpert Thank you sir....This will help alot!!
Thank you very much for sharing this useful code,
Can you please make video on how to send bulk emails from Gmail using vba
Hi, i am not sure what i am doing wrong but after creating the macro, email is being to the first email only.. Not the rest of the eamil ids
What to do in case if I wants to add multiple organization names through excel sheet in Subject field?
1) I am actually looking for mail merge to send queries to different companies to get the quotation. Like for example in "To" field I could use multiple e-mail addresses and also in "Cc" too.
2) How do we draw a table and insert our data in it and send queries by mail through Macros?
3) Can we design a specific form or template and whenever I want to send queries to different organizations it will directly obtain the data from excel sheet and link with the template?
Very helpful and time saving.
How can we do same with attachments?
Thank you sir for this valuable information, it is really great. I have a similar requirement, where we would like to send birthday cards as images in the outlook email along with the image of the person on that image card whenever his/her birthday comes. Is there any way to achieve this requirement, so that these emails gets shoot automatically when the person's birthday comes. Looking forward to hear from you!
Can you add status row ? which says "sent" next to every email after its sent.
Hi can you tell how to send the data to multiple email id in table format
Hi PK,
Thanks for this amazing video. I am facing one problem. when I am setting option button as display and running the For loop. It is only showing the person's draft. others are somehow disappearing and also not showing in draft. I tried to ".save" but still no success. how can I see all the mails which I am drafting through this code.
Ram ram my friend, thank you so much for your video. I have a question, is that possible somehow to skip this pop up windows where we need to press send to each of the email? Just run macro and then all the emails will be send automatically without clicking on send button in the outlook. Thank you so much in advance!
instead of msg.display, change it to msg.send
In my Excel 2013 don't have developer mode.
can you share excel2013 , i want bulk mail thru word file or excel file
When I m defining html body...it's saying application define or object define errors..plz suggest?
I want to add a neme list to the email body. And that list range keeps changing. It means Row count is fluctuating. Please teach me the way to do that.
Can we load html file in htmlbody of mail . Html file that the common msg for all with some pictures and links!
if i try to .send instead .display i get this error (462): the remote server machine does not exist or is unavailable. any advise?
This is a great video. Found this after finding your first video that didn't show you how to add in signatures. It looks like the download link for this document / macro in the description isn't working currently. Are you able to update it?
I stand corrected. It was timing out on our office network but as soon as I tried it from my phone it worked. Guess I have some other bugs to work out. I'm good now. Thanks again for these informative videos.
👍 Hi, Can we have the similar code for GMAIL instead Outlook.
Thanks sir
Dear sir inventory system Ms access class video please
With this code, How to insert a picture range in the center of the body mail? Please help
But how to write any lines in html format. Because outlook doesn't support html
Sir,
How to add the attachment in this script please suggest
Hello Sir, Thank you for sharing and this is very useful. But I need to send it from a generic mailbox using the same code. Please help me with the codes. Please reply.
Can you please tell me
In this above code, how we cab add table as text or table as pic please provide
Sir,
Pls suggest how to add the attachment ?
Thanks PK for this video & utility tool. I have a question. What will be code if our headings are in 02 rows. For example, headings are-
A1 (Merged A1 to A2) = Name
B1(Merged B1 to D1) = Quantity
B2 = Target
C2 = Achievement
D2 = Balance
E2 = Mail id
Values would start from row 3
Please reply.
Sir, kindly explain and make a video about 'Error in loading DLL' in Microsoft Visual Basic.
sir, pls tell how to send mail through gmail from vba automation.
Will upload soon
Very very helpful sir...
I have Same question. ...
Plz also teach to out attachment file excel ppt or word
sir i have purchase a new laptop & preinstall 2019 excel some day i will work smooth but now a days shortcut key Alt +E+S+V is not work for excel sir but i have anydesk to other pc work than work this shortcut but not work in my laptop how to fix this issue sir please rply
Thank you for the video, i really appreciate. One question i have, can you please tell - how to remove extra spacing( 2 line breaks) before signature.
Thanks and regards
Sajid
Everything works perfectly in display but when I press send I get a "run-time error '287: Application-defined or object-defined error." Can anyone tell me what I am doing wrong?
@PK: An Excel Expert
Plz take Gmail platform with attachment
How can i send thousands of mail per day?