Send WhatsApp and Email without VBA

[@amitmishra1513]

Excellent teaching technic, very helpful. Can we send WhatsApp msg directly without clicking send button on web whatsApp window? I Mean as we clicked in excel cell WhatsApp msg directly sent noneed to click again on send button

[@supershipping6936]

create a loop with macro in openworkbook

[@SUBHASHMEGH]

First time I find interesting Video in excel
Excellent creator 👌

[@PKAnExcelExpert]

Thank you so much 😀

[@rkbiswal24]

Impressive. I was searching for something like this sending WhatsApp messages in bulk. Thanks again.

[@PKAnExcelExpert]

Glad you liked it

[@excel_master_habib]

AAPKI JITNI TAARIF KI JAYE SAB KAM HAI SIR BAHUT BAHUT SUKRIYA

[@PKAnExcelExpert]

Thanks

[@piarchanddogra1659]

Fantastic.... your every video is a watcher and learns a lot. You always deserve a thumbsup. Kindly guide how to do bulk message with carbon copy in it.

[@PKAnExcelExpert]

for bulk emails I have already created multiple videos
th-cam.com/video/A6tggcOV6ts/w-d-xo.html
th-cam.com/video/q9kTgTghN2g/w-d-xo.html
th-cam.com/video/QVJDQqYMNdQ/w-d-xo.html
for bulk WhatsApp I will upload a video soon

[@gajendrasingh9486]

So informative and helpful video...first time seen this type video for excel...

[@PKAnExcelExpert]

Glad you liked it

[@tanveerbatliwala]

Too good.... Made a very complex requirement work very easy

[@PKAnExcelExpert]

Glad you liked it

[@Balwan_Singh]

PK You are absolute genius.

[@PKAnExcelExpert]

Thanks

[@jyotirani8232]

great video

[@ukemeisaac]

Fantastic teaching! I wish I can always like your videos more than once. Let me go and learn. Thank you so much.

[@PKAnExcelExpert]

Thanks a ton!

[@mrCetus]

Thanks PK, Such a wonderful simple teaching !! Step by step approach from scratch !! Hats Off

[@PKAnExcelExpert]

Most welcome!

[@muthuraja3128]

It's amazing PK you always rock and teaching new tricks for us in this video, i want to know how to after click the hyperlinks it will redirect to mail or web after that we have to click send button instead of this how to click send button automatically while clicking the hyperlinks, please make an video

[@PKAnExcelExpert]

I will make a video on this topic

[@srmchinni3]

Awesome one. Illustration is really great.

[@PKAnExcelExpert]

Thank you! Cheers!

[@hmonem]

Thanks for the informative video.. After having such sheet.. Is there a way to send all Whatsapp messages in one go or it needs to be one by one? If the same text will be sent, can there be kind of distribution list so we do not need to send it as one by one?

[@NeangBona]

hi PK! even without VBA code your file also looked so magic creative I do like it so much!

[@PKAnExcelExpert]

Glad you like it!

[@AbdellahB-y3x]

Hi PK, what a wonderful job you're doing!!! I am still learning (I'm in high school...) and thank you for ther work, it's so valuable!!!. Do you think that sending a whatsapp message with a customized image (based on an excel table) with data changing depending on the person supposed to receive the message is feasible?

[@dineshpawar7869]

Thanks..it's very useful...
Also please help us in sending multiple emails or whatsapp messages at one click.

[@aakritisinghal3865]

Sir, I watched your video/channel for the first time today and I was like 😲......this is truly fabulous...... But I am new learner due to which I found it going too fast when you were so fluently using short cuts like changing the date format, etc.
Could you please also tell what all shortcuts keys you used here and what you generally use performing these tasks.....
That would be really helpful
Thank you so much

[@odurojoseph435]

Thanks for the great work. It has really helped me. I have one problem: I have a large number of contacts I have to send a WhatsApp message. can you help me send the message at once without using VBA? With your technic, the msg has to be sent one after the other which will be time consuming.

[@angelmix2374]

Very Clear and helpful. However, can we add attachment to Email or Whatsapp?

[@umehtoch]

Great work there PK. Thanks alot.
But how can I automate the email sending or WhatsApp messages without clicking the icon before the message is sent?

[@PKAnExcelExpert]

for emails I have already created multiple videos
th-cam.com/video/A6tggcOV6ts/w-d-xo.html
th-cam.com/video/q9kTgTghN2g/w-d-xo.html
th-cam.com/video/QVJDQqYMNdQ/w-d-xo.html
for bulk WhatsApp I will upload a video soon

[@mohamedel-hanfy9140]

I like all the valuable information you provide

[@PKAnExcelExpert]

Thanks

[@TrendXone]

Respected Sir You are great

[@PKAnExcelExpert]

Thanks

[@ganeshbabu276]

Super sir!!! Your are awesome. I have one doubt... How to export the excel sheet as pdf and send it via mail or whatsapp message? Please give me a solution sir.

[@PKAnExcelExpert]

Will upload soon

[@BHARATHAJAY1026]

Thank u for posting useful video

[@PKAnExcelExpert]

Most welcome

[@mdexcelpro8495]

great tips and very useful 👌

[@PKAnExcelExpert]

Glad you think so!

[@Rkeev1]

Another great instruction; you are awesome

[@PKAnExcelExpert]

Thank you! Cheers!

[@mohammadilyas2240]

Excellent زبردست

[@PKAnExcelExpert]

Thanks

[@IbrahimSAlshibi]

Can be done for either whatsapp or email to be send automatically without pressing send, or without showing the page for email or whatsapp

[@unnikrishnansanthosh]

fantastic one PK, you are really awesome
🤩

[@PKAnExcelExpert]

Thank you so much 😀

[@kchiranjeevi5662]

Very Good information Sir

[@PKAnExcelExpert]

Thanks

[@farhansagar1270]

youre love bro youre awsome keep it up

[@PKAnExcelExpert]

Thanks! Will do!

[@robineclipse1994]

Very Excellent 👌

[@PKAnExcelExpert]

Thanks a lot

[@cristhiancabra184]

thanks for your video, is very helpfull, i have a question, when i do the hiperlink for the email, it opens my browser and my personal gmail account, how can i open outlook application with the hiperlink?

[@akashthakur5615]

Awesome trick sir

[@PKAnExcelExpert]

Thanks

[@bskrmusic3932]

Sir, thanks a lot Informative sesssion, Could you please let us konw how to add attachement files on teh same without VBA. Appreicate your quick support !

[@kareemsayeed5906]

Sir. Thanks for sharing your wonderful knowledge. Is it possible to attach any file in the same auto mail.

[@raafat1975]

it is good video, but this method is only for sending message to each WhatsApp number separately, is it possible to arrange the file for sending a message to multiple numbers at once ?

[@Brutech360]

Great work

[@PKAnExcelExpert]

Thank you so much 😀

[@jgun0075]

Most useful 👍👍👍

[@PKAnExcelExpert]

Glad you think so!

[@GenNextAnalyst]

Excellent tutorial! Thanks

[@PKAnExcelExpert]

Thanks

[@yabassiland9469]

So Great . Thanks

[@PKAnExcelExpert]

Most welcome

[@raytim764]

99999 tnx :) all your videos are very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@charliearmour1628]

So very clever. Thanks.

[@PKAnExcelExpert]

You are so welcome!

[@kiranps7178]

Great sir 😍😍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@paravandashafeeq5028]

Hi PK,Thanks for a great informative vedio, one clarification please whether we can send all in one click or set a time limit to send automatically at any particular time a day

[@PKAnExcelExpert]

Yes you can. I will upload a video on this topic

[@cheeyuenchan7276]

@@PKAnExcelExpert May I know where to find this video?

[@GeorgeAJululian]

Many thanks Sir very helpful

[@PKAnExcelExpert]

Most welcome

[@raymondchan6168]

Hi PK, love your TH-cam. Can you show us how to send picture from excel to whatsapp without VBA? Is it possible? Image file maybe jpg or png? Thanks

[@muhammadkhalil5712]

Hi, nice information ♥️
Sir can you explain formulas you put for email and WhatsApp by hyperlink .
Kindly make detailed video...
And please when you make videos kindly do zoom on each and every step...♥️
Thanks

[@mosheslonim3255]

Incredible!
Can this work with Gmail, or only with Outlook?

[@vijaikumarramakrishnan6506]

Good explanation, Is there any option to send Picture link image to whatsapp

[@PKAnExcelExpert]

will upload a video soon

[@PossibleTarget24]

Thank you so much, I really appreciate your desk...💯💐🏅

[@PKAnExcelExpert]

You’re welcome 😊

[@prashantpotdar6309]

Hi Pk very nice video
Is it possible to send message to multiple numbers with single click

[@JDubaiCDubai]

Hi PK , i see the learning practice doc is payable ?

[@musatenginkeri1823]

Great 👌

[@PKAnExcelExpert]

Thanks ✌️

[@6SUPERMAGA]

Sir, kindly share video to send bulk messages on WhatsApp without VBA
Thanks a lot for your effort

[@PKAnExcelExpert]

I will upload soon but it will be with VBA

[@6SUPERMAGA]

Ok sir. Anyhow you will share code too..
Thanks a lot...God bless you

[@suryakantthakur1879]

Lots of thanks PK. It is worthy

[@PKAnExcelExpert]

Thanks

[@nixnews2267]

Superb......

[@PKAnExcelExpert]

Thanks 🤗

[@VinodKumar-tp2zy]

Excellent sir, can we send whatsapp message to group instead of personal number?

[@HealthyBhavah-byTanyaArora]

Hello sir. Pls tell me if we need to send the MSG or mail ,one by one ? Or we can send in bulk in one click too?

[@marwanmohammad7821]

Hi PK. This is nice job.. how from you to provide me how to send message for many contacts on whatsapp in one click... I need it as soon as possible... best wishes

[@fernandocaceres9930]

Congrats and many thanks PK!!! Very useful. Please, Do you mean the unique way is Whatsapp web, not by cel?

[@PKAnExcelExpert]

Yes, correct. You need to login into web WhatsApp web.whatsapp.com/

[@fernandocaceres9930]

@@PKAnExcelExpert Thanks PK. Can you send some image by Whatsapp in your method?

[@josmaitconsult8913]

Amazing video, can I use this in Ms access.

[@nimeshdoshi323]

Superb.
How do I download the excel file

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏. Download link has been given in videos description box or visit our website www.PK-AnExcelExpert.Com

[@osmanbas7701]

It is excellent, but I couldn't do it even though I typed the same formula. Is there a way that you help me? looking forward to hearing from you.

[@PKAnExcelExpert]

You can download our file from the link given in description box or visit our website WWW.PK-AnExcelExpert.Com

[@pintuchoyan9526]

Sir great job,

[@PKAnExcelExpert]

Thanks

[@arjunspata1913]

Nice sir

[@PKAnExcelExpert]

Thanks and welcome

[@huseyinbakir2017]

Thanks teacher

[@PKAnExcelExpert]

You are welcome

[@DileepKrsingh-sq8ox]

Usefull

[@PKAnExcelExpert]

Thanks

[@Fazwaans]

Thanks for sharing your knowledge with us, the only think i don't understand is the whats app, If i have what's number and person name and the message which i need to send on same sheet. how do i do that?

[@dineshdinu4635]

Great work there PK. Thanks alot. But how can I add more letters to send WhatsApp messages? Kindly help me.

[@atulyasahoo7982]

Thanks man....

[@PKAnExcelExpert]

You're welcome!

[@Andrea-od9ws]

Very useful, thank you, i tried this method with telegram but it does not select the recieving number. Is it possible? i tried it by changing the whatsapp address to the telegram address. Any suggestions? thank you.

[@naeemtahir9352]

Just amazing brother!
I have some problems while sending whats app. Whats app is only showing 25 spells. How to fix it?

[@SanviPatil2019]

nice sir..

[@PKAnExcelExpert]

Thanks

[@Sherazkhan-ll4sp]

Hi PK, Your work is amazing! Is there a way to create a custom report where you pull specific data or certain columns from multiple different spreadsheets into one using folder path?

[@PKAnExcelExpert]

will upload soon

[@AbdellahB-y3x]

Thanks PK for your reply. An excel application for whatsapp with dynamic photo, longtime

[@AbdellahB-y3x]

Correction:
Thanks PK for your reply. An excel application for whatsapp with dynamic photo, I'm sure that such an application s eagerly looked for by may and so since longtime. Keep going, it's fabulous!

[@JohnStewartiv]

Thanks a lot; however, I would like to know how this can be done with WhatsApp desktop version instead of the web version.

[@jobiyachan]

Hello PK, this tutorial is really amazing. It works great. Thanks for the same. At the same time if I do this in a table, a fresh new row shows #N/A under headings: Mail Body, Send Mail and Send WhatsApp colums. As I start entering data in the validated field, #N/A will be disappeared. But still the last two columns display "*" and ")" with underlines and they change also their size, colour. Could you please find a solution for this problem and reoly me? Thank you sir!

[@abhijitdutta4790]

All your presentation is awesome, but if I want to send them all at once in one click, how it will work?

[@PKAnExcelExpert]

for bulk emails I have already created multiple videos
th-cam.com/video/A6tggcOV6ts/w-d-xo.html
th-cam.com/video/q9kTgTghN2g/w-d-xo.html
th-cam.com/video/QVJDQqYMNdQ/w-d-xo.html
for bulk WhatsApp I will upload a video soon

[@rafeeqabdulla5279]

Excellent and Very useful step by step details.
I am unable to send the WhatsApp message without manually clicking the SEND button. Please help to resolve this sir.

[@PKAnExcelExpert]

I will create a separate video on this topic

[@rafeeqabdulla5279]

@@PKAnExcelExpert Also please try to include how to attach an image along with the text
Thanks in advance

[@sportsclipsasia]

HI PK
Can we add attachment and send Email directly without using VBA? or in same sheet?

[@hforu1706]

Thanks, i get a lot of mails per day at my work, how can i track some of them from outlook to excel without vba? to make it dynamic, thnx!

[@PremKumar-rf3mo]

super.

[@PKAnExcelExpert]

Thank you! Cheers!

[@PremKumar-rf3mo]

@@PKAnExcelExpert Do you have any guidance or you may guide for me the VBA... ? i'M NEED...

[@sisoader7391]

THANK YOU. IT IS VERY INTERESTING. PLEASE CAN I APPLY PROGRESSBAR CODE IN ACCESS DATABASE TO IMPORT EXCEL FILES ? IF SO HOW CAN I DO IT? THANKS

[@gowthaman3264]

Explain about %0A, How it's working,is it the same new function in excel???

[@mosheslonim3255]

Great video! does the WhatsApp recipient has to be in my contact list?

[@PKAnExcelExpert]

No, It is not required.

[@Bluepanther986]

Also help us to know if we want to add person in cc as well

[@harshchowdhury5591]

THANKYOU

[@PKAnExcelExpert]

Most welcome

[@avinashkullarwar9066]

Sir, I have some issue, how i can connect you. Your help required.

[@pa2happiness13]

👌🏼♥️

[@PKAnExcelExpert]

Thanks

[@dbdata9836]

thanks

[@PKAnExcelExpert]

Most welcome

[@ravibabushika]

Hi sir, is there any limit for mail body characters?

[@hiteshpursnani7322]

Sirji please help us with the same programming for bulk mailing and WhatsApp

[@PKAnExcelExpert]

for bulk emails I have already created multiple videos
th-cam.com/video/A6tggcOV6ts/w-d-xo.html
th-cam.com/video/q9kTgTghN2g/w-d-xo.html
th-cam.com/video/QVJDQqYMNdQ/w-d-xo.html
for bulk WhatsApp I will upload a video soon

[@kchiranjeevi5662]

Sir Please Explain Pivot table with students Marks and finance report Sir

[@arjunspata1913]

Sir kya hm es tarah text sms custom with name and amount m send kr sakte h

[@PossibleTarget24]

Dear Prother, I would like to ask a doute in excel So, how do we calculate the words to number in excel. Exa: I have 10 APPROVED Status , but money "APPROVED" We cannot calculate one by one, So how can calculate as number? Can you help me??

[@chetansarvaiya9679]

Hello Sir,
How to Send Messages from Excel to Signal Messenger.
Pls Guide!
Thanks! ❤️

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@MedicoverHospitalsKNR]

Is it possible to insert an attachment in the same email, looks like lot of other people are waiting for your response on the same.

[@pankajjaswani9155]

Good but it can be dynamic when we can able to send bulk achievement on a single click.

[@PKAnExcelExpert]

for bulk emails I have already created multiple videos
th-cam.com/video/A6tggcOV6ts/w-d-xo.html
th-cam.com/video/q9kTgTghN2g/w-d-xo.html
th-cam.com/video/QVJDQqYMNdQ/w-d-xo.html
for bulk WhatsApp I will upload a video soon

[@GenNextAnalyst]

@@PKAnExcelExpert Waiting for it! Thanks a lot

[@pankajjaswani9155]

​@@PKAnExcelExpertI've viewed all of the vids. I'd want to send all employees's Target versus achievements from Excel as a text message/image via Whatsapp with a single click.

[@pankajjaswani9155]

@@PKAnExcelExpert th-cam.com/video/veyI0zzRfCg/w-d-xo.html

[@chandrasekarparamanandham5155]

Hello sir my Excel sheet mail inbox window not opening after completing all formula.
Please clarify whether your method work in excell 2007 or any add on required. ?

[@PKAnExcelExpert]

Please check default App setting in widows setting. for Email it should be Outlook.

[@chandrasekarparamanandham5155]

@@PKAnExcelExpert thanks you for your quick response...