Send WhatsApp and Email without VBA

#HyperlinkFormula #WhatsappAutomation
Hello Friends,
In this video, You will learn how to create an Excel template to send WhatsApp and Email without using VBA coding. We have used the Hyperlink formula to achieve this.
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download the practice file from the below link:
www.pk-anexcel...
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
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
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

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

[@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
ruclips.net/video/A6tggcOV6ts/видео.html
ruclips.net/video/q9kTgTghN2g/видео.html
ruclips.net/video/QVJDQqYMNdQ/видео.html
for bulk WhatsApp I will upload a video soon

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

[@dineshpawar7869]

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

[@gajendrasingh9486]

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

[@PKAnExcelExpert]

Glad you liked it

[@angelmix2374]

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

[@rkbiswal24]

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

[@PKAnExcelExpert]

Glad you liked it

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

[@user-mw3yc4qr4o]

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?

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

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

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

[@ibrahimsalehalshibi8159]

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

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

[@user-nz7pp9lh2s]

Respected Sir You are great

[@PKAnExcelExpert]

Thanks

[@Balwan_Singh]

PK You are absolute genius.

[@PKAnExcelExpert]

Thanks

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

[@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
ruclips.net/video/A6tggcOV6ts/видео.html
ruclips.net/video/q9kTgTghN2g/видео.html
ruclips.net/video/QVJDQqYMNdQ/видео.html
for bulk WhatsApp I will upload a video soon

[@tanveerbatliwala]

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

[@PKAnExcelExpert]

Glad you liked it

[@mohammadilyas2240]

Excellent زبردست

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

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

[@jyotirani8232]

great video

[@yabassiland9469]

So Great . Thanks

[@PKAnExcelExpert]

Most welcome

[@BHARATHAJAY1026]

Thank u for posting useful video

[@PKAnExcelExpert]

Most welcome

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

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

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

[@kchiranjeevi5662]

Very Good information Sir

[@PKAnExcelExpert]

Thanks

[@farhansagar1270]

youre love bro youre awsome keep it up

[@PKAnExcelExpert]

Thanks! Will do!

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

[@mdexcelpro8495]

great tips and very useful 👌

[@PKAnExcelExpert]

Glad you think so!

[@naeemtahir9352]

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

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

[@akashthakur5615]

Awesome trick sir

[@PKAnExcelExpert]

Thanks

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

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

[@mohamedel-hanfy9140]

I like all the valuable information you provide

[@PKAnExcelExpert]

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

[@Rkeev1]

Another great instruction; you are awesome

[@PKAnExcelExpert]

Thank you! Cheers!

[@raymondchan6168]

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

[@kareemsayeed5906]

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

[@unnikrishnansanthosh]

fantastic one PK, you are really awesome
🤩

[@PKAnExcelExpert]

Thank you so much 😀

[@GeorgeAJululian]

Many thanks Sir very helpful

[@PKAnExcelExpert]

Most welcome

[@prashantpotdar6309]

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

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

[@robineclipse1994]

Very Excellent 👌

[@PKAnExcelExpert]

Thanks a lot

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

[@Bluepanther986]

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

[@GenNextAnalyst]

Excellent tutorial! Thanks

[@PKAnExcelExpert]

Thanks

[@danielnadar404]

Create a profile form with few options 1) Common Announcement 2) B'day & Wedding day wishes 3) Reminder alert of meeting etc via mail or whatsapp on one click the msg should be sent to whtsapp number given in form

[@JohnStewartiv]

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

[@vijaikumarramakrishnan6506]

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

[@PKAnExcelExpert]

will upload a video soon

[@charliearmour1628]

So very clever. Thanks.

[@PKAnExcelExpert]

You are so welcome!

[@Brutech360]

Great work

[@PKAnExcelExpert]

Thank you so much 😀

[@kchiranjeevi5662]

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

[@PossibleTarget24]

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

[@PKAnExcelExpert]

You’re welcome 😊

[@dineshdinu4635]

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

[@mosheslonim3255]

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

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

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

[@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
ruclips.net/video/A6tggcOV6ts/видео.html
ruclips.net/video/q9kTgTghN2g/видео.html
ruclips.net/video/QVJDQqYMNdQ/видео.html
for bulk WhatsApp I will upload a video soon

[@huseyinbakir2017]

Thanks teacher

[@PKAnExcelExpert]

You are welcome

[@sportsclipsasia]

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

[@romamish]

I have try, It's work well, when characters less than 200, but when more than 200, it Will give error' message #value. How to fix it? Thanks

[@atulyasahoo7982]

Thanks man....

[@PKAnExcelExpert]

You're welcome!

[@gowthaman3264]

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

[@hiteshpursnani7322]

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

[@PKAnExcelExpert]

for bulk emails I have already created multiple videos
ruclips.net/video/A6tggcOV6ts/видео.html
ruclips.net/video/q9kTgTghN2g/видео.html
ruclips.net/video/QVJDQqYMNdQ/видео.html
for bulk WhatsApp I will upload a video soon

[@jgun0075]

Most useful 👍👍👍

[@PKAnExcelExpert]

Glad you think so!

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

[@arjunspata1913]

Nice sir

[@PKAnExcelExpert]

Thanks and welcome

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

[@josmaitconsult8913]

Amazing video, can I use this in Ms access.

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

[@sarwonosarwono70]

how to do, if i want to send an image or pdf file wihout macro?

[@kiranps7178]

Great sir 😍😍

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@pintuchoyan9526]

Sir great job,

[@PKAnExcelExpert]

Thanks

[@arjunspata1913]

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

[@balachowdaiah1950]

excellent but error : phone number shared via url in invalid please guide me

[@PKAnExcelExpert]

Make sure that phone number is registered for WhatsApp account and You are using Country code also with phone number

[@raytim764]

99999 tnx :) all your videos are very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@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
ruclips.net/video/A6tggcOV6ts/видео.html
ruclips.net/video/q9kTgTghN2g/видео.html
ruclips.net/video/QVJDQqYMNdQ/видео.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 ruclips.net/video/veyI0zzRfCg/видео.html

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

[@dbdata9836]

thanks

[@PKAnExcelExpert]

Most welcome

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

[@user-mw3yc4qr4o]

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

[@user-mw3yc4qr4o]

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!

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

[@avinashkullarwar9066]

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

[@ManojKatwe]

Hello Sir, is there any formula to send same message to multiple numbre without reloading the whatsapp web. You code is good but everytime is load the new session of whatsapp web and it consumes time.

[@musatenginkeri1823]

Great 👌

[@PKAnExcelExpert]

Thanks ✌️

[@SanviPatil2019]

nice sir..

[@PKAnExcelExpert]

Thanks

[@nixnews2267]

Superb......

[@PKAnExcelExpert]

Thanks 🤗

[@DileepKrsingh-sq8ox]

Usefull

[@PKAnExcelExpert]

Thanks

[@balavenkateshwarbetha2160]

can we send all msgs at a time?? if yes plz say the process

[@sanjaypolekar3476]

Sir how to send attachment on whatts app easily. with Vba or No vba.

[@lokeshkumark2114]

Sir Also kindly suggest a method how to generate a random number between 32.20 to 32.50 .

[@PKAnExcelExpert]

will create a video on this

[@tojin966]

Use regular rand formula between 3220 to 3250, then divide by 100

[@karthikshetty155]

One more thing need solution, can we also maintain record of number of mails sent to person in record.

[@VinodKumar-tp2zy]

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

[@gajendrasingh9486]

Can we use whatsup number and email id in one sheet without vlookup

[@PKAnExcelExpert]

Yes you can