Bulk Auto Emailer with Picture Signature and HTML body

[@KrishnaKumar-zn9kg]

You are the best! Fantastic simple explanations that are very very clear. You are doing a great job. Please continue forever!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kalpen200]

Cannot thank you enough. So clear and precise. Keep up the good work. God bless.

[@arzach71]

Best video EVER EVER EVER on mail with vba - you save me a huge of time (and maybe also my life :) ) THANK YOU!!!

[@PKAnExcelExpert]

Glad it helped!

[@VIPULDJHAVERI]

Dear PK - amzing trick and very well explained - brilliant show , thanks a lot Priyendra Kuamr ji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@timcraven3543]

PK, you never disappoint! Excellent job my friend.

[@PKAnExcelExpert]

Thanks a lot.

[@MohanYGK]

sir ji, very very helpful and practical video. you are genius!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohanedalwhaibi576]

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

[@PKAnExcelExpert]

You are most welcome

[@atsiista]

Thanks a lot! Amazing explanation, simple, clear and getting right into the point!

[@PKAnExcelExpert]

Glad you enjoyed it!

[@SukeshKutty]

Thaq.... Soo soo much.... I was searching for this kind of issues like adding signature, adding new line it's very useful video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@amiitmish3]

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

[@DM-YouTube]

Thanks for sharing such a great useful utility. Very much useful. Always waiting for your informative videos. Thanks once again 🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@faridPQ]

Enjoyed it. Excellent

[@PKAnExcelExpert]

Glad you enjoyed it

[@ankursaran2282]

Helpful... Made my work easy :)

[@PKAnExcelExpert]

Thanks🙏

[@charliearmour1628]

So good, exactly what I was looking for. Cheers.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mykie4800]

Thanks ... easy to understand

[@midhunkannan4801]

Great video bro 👍keep up the good work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@midhunkannan4801]

Bro..how do we send with high importance?

[@amraevers2797]

You are a genius!

[@PKAnExcelExpert]

Thanks

[@reihanfarizky9862]

sir, thanks for sharing, this is very helpful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@reihanfarizky9862]

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

[@josefsupnet904]

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?

[@suhailnbd]

Excellent PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mahereddy8425]

Very helpful, thanks😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Shahul1982]

Great Mr PK, kindly requesting you to add Attachments also please

[@MohamedAli-co7dc]

GREAT. Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@janinemarabella3173]

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

[@anvivishalkulkarni9682]

Waaaaw great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@krishnaveni6384]

Your videos are best and easy to follow... Plz help to replace outlook with lotus notes mail

[@redhaakhund1271]

As always you are👍👍👍👍👍

[@PKAnExcelExpert]

Thank you so much 😀

[@ExcelWithChris]

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.

[@navneetasnavi]

Can you add status row ? which says "sent" next to every email after its sent.

[@AliKhan-nt3cm]

Thank you very much for sharing this useful code, Can you please make video on how to send bulk emails from Gmail using vba

[@AL-tl7ov]

if i try to .send instead .display i get this error (462): the remote server machine does not exist or is unavailable. any advise?

[@raushanpandey4553]

When I m defining html body...it's saying application define or object define errors..plz suggest?

[@dushanshalina4676]

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.

[@officereplikka3703]

In my Excel 2013 don't have developer mode. can you share excel2013 , i want bulk mail thru word file or excel file

[@AjitSingh-qn1tk]

Hi can you tell how to send the data to multiple email id in table format

[@wasihassan8089]

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?

[@sachinsachin689]

But how to write any lines in html format. Because outlook doesn't support html

[@abdulrehmanmughal8235]

Can we load html file in htmlbody of mail . Html file that the common msg for all with some pictures and links!

[@asmitha1234]

With this code, How to insert a picture range in the center of the body mail? Please help

[@rajvenkat3641]

Sir, How to add the attachment in this script please suggest

[@rabinshrestha9335]

Very helpful and time saving. How can we do same with attachments?

[@vaibhavsrivastava7196]

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.

[@SUR-NI-VARA]

👍 Hi, Can we have the similar code for GMAIL instead Outlook.

[@kalpeshghati2427]

Can you please tell me In this above code, how we cab add table as text or table as pic please provide

[@enggsrinivas]

Sir, Pls suggest how to add the attachment ?

[@prashantjadhav5353]

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.

[@PKAnExcelExpert]

Will try to create a video on this topic.

[@prashantjadhav5353]

@@PKAnExcelExpert Thank you sir....This will help alot!!

[@abhishekkaushik4827]

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!

[@khemrajrana7322]

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

[@lkumar2727]

sir, pls tell how to send mail through gmail from vba automation.

[@PKAnExcelExpert]

Will upload soon

[@sachinshinde5997]

Very very helpful sir... I have Same question. ...

[@amiitmish3]

Plz also teach to out attachment file excel ppt or word

[@vsevolodsyskin9107]

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!

[@terenceyoung1080]

instead of msg.display, change it to msg.send

[@ksravan24]

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.

[@S.art1396]

Sir, kindly explain and make a video about 'Error in loading DLL' in Microsoft Visual Basic.

[@VivekSingh-qh8xp]

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.

[@faizansheikhx4320]

How can i send thousands of mail per day?

[@isabellarocks1000]

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?

[@isabellarocks1000]

@PK: An Excel Expert

[@pacman_]

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?

[@pacman_]

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.

[@shivannahr780]

Thanks sir Dear sir inventory system Ms access class video please

[@aslike4me]

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

[@amiitmish3]

Plz take Gmail platform with attachment