Bulk Auto Emailer with Picture Signature and HTML body

#VBA #OutlookAutomation
Hello Friends,
In this video, Bulk Auto Emailer with Picture Signature and HTML body. We have given the 2 form control option button to select the send or display Email. This bulk auto emailer will work with Microsoft Outlook. We have given the Skip column on Column A. You can put "Y" there to skip the email for row. We have used the HTML tags for the format the mail body. It will take your pre-defined signature from outlook.
Download the practice file from below given link:
www.pk-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

[@Darshanam-Jatra]

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

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

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

[@MohanYGK]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@timcraven3543]

PK, you never disappoint! Excellent job my friend.

[@PKAnExcelExpert]

Thanks a lot.

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

[@atsiista]

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

[@PKAnExcelExpert]

Glad you enjoyed it!

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

[@ankursaran2282]

Helpful... Made my work easy :)

[@PKAnExcelExpert]

Thanks🙏

[@mykie4800]

Thanks ... easy to understand

[@krishnaveni6384]

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

[@faridPQ]

Enjoyed it. Excellent

[@PKAnExcelExpert]

Glad you enjoyed it

[@Shahul1982]

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

[@amraevers2797]

You are a genius!

[@PKAnExcelExpert]

Thanks

[@charliearmour1628]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

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

[@mahereddy8425]

Very helpful, thanks😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@midhunkannan4801]

Great video bro 👍keep up the good work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@midhunkannan4801]

Bro..how do we send with high importance?

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

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

[@MohamedAli-co7dc]

GREAT. Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@anvivishalkulkarni9682]

Waaaaw great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@suhailnbd]

Excellent PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

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

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

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

[@raushanpandey4553]

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

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

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

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

[@rabinshrestha9335]

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

[@abdulrehmanmughal8235]

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

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

[@SUR-NI-VARA]

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

[@officereplikka3703]

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

[@navneetasnavi]

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

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

[@AjitSingh-qn1tk]

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

[@sachinsachin689]

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

[@asmitha1234]

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

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

[@kalpeshghati2427]

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

[@rajvenkat3641]

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

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

[@enggsrinivas]

Sir,
Pls suggest how to add the attachment ?

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

[@S.art1396]

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

[@shivannahr780]

Thanks sir
Dear sir inventory system Ms access class video please

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

[@faizansheikhx4320]

How can i send thousands of mail per day?

[@amiitmish3]

Plz take Gmail platform with attachment