How to send Whatsapp Messages from Excel - Malayalam Tutorial

എക്സലിൽ ഉപയോഗിച്ച് ഒറ്റ ക്ലിക്കിൽ നൂറു കണക്കിന് ആളുകൾക്ക് വാട്സാപ്പ് മെസ്സേജ് അയക്കുന്ന ടെക്നിക്ക്.
How to send WhatsApp messages from Excel, explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/...
Subscribe to the channel ‪@AjayAnandXLnCAD‬ for more.
/ ajayanandxlncad
Check this video for sending WhatsApp messages from Excel using WhatsApp for the Web.
• Send WhatsApp Message ...
VBA Code to send Whatsapp messages from Excel
Sub XLToWhatsApp()
Dim LastRow As Long
Dim i As Integer, strip As String
Dim strPhoneNumber As String, strMsg As String, strPostData As String
Dim IE As Object
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
strPhoneNumber = Sheets("Payment").Cells(i, 3).Value
strMsg = Sheets("Payment").Cells(i, 4).Value
strPostData = "whatsapp://send?phone=" & strPhoneNumber & "&text=" & strMsg
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate strPostData
Application.Wait (Now + TimeValue("00:00:01"))
Call SendKeys("^v")
Application.Wait (Now + TimeValue("00:00:01"))
Call SendKeys("{Enter}", True)
Next i
End Sub
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/...
#exceltowhatsapp #whatspptricks #excelmalayalam

[@The-anav.]

അടിപൊളി. അയക്കുന്നവരോട് 1000 നമ്പറിൽ കൂടുതൽ ഒരു ദിവസം അയച്ചാൽ വാട്സാപ്പ് ബ്ലോക്കാവനുള്ള സാധ്യതയുണ്ട്

[@XLnCADMalayalam]

👍

[@shafeek_yeppi8273]

Maximum എത്ര പേർക് അയക്കാം ഡെയിലി

[@vallavilasreekumar4420]

വളരെ ഉപകാരപ്രദമായ ട്യൂട്ടോരിയൽ

[@MrStalinAlex]

ഇത് ഉപയോഗിച്ച് ഫോട്ടോ അയക്കാൻ പറ്റുമോ 🤔🤔

[@sreenathkdeva1001]

Your voice is also superb as your presentation

[@XLnCADMalayalam]

Thank you :)

[@dingandheeran6289]

Ajay chetta... Awesome Work.. മാസങ്ങൾ ആയിട്ട് waiting ആയിരുന്നു.. Pwoli♥️

[@sojanavarghese4831]

ഇത് work ആവുന്നുണ്ടോ

[@THOMASPAYIKATTUVAYALILABRAHAM]

Wow greate. ക്യാഷ് അല്ലാതെ നോർമൽ ടെക്സ്റ്റ്കളോ ലിങ്കുകളോ അയക്കാൻ പറ്റുമോ

[@lijoidukki]

Atha njanum nokkunne

[@Simplepencildrawings]

Yes

[@benoyav9779]

Wow, this is super useful. Thank you 👍.

[@rapirabu]

Great work. Nicely explained.

[@XLnCADMalayalam]

Thank you :)

[@mmbcampus]

Great... Can we add attachment automatically ??

[@shefeeks123]

Whatsapp message going with VB code as well

[@XLnCADMalayalam]

Press Win +V to activate the Windows Clipboard. Clear it and try again.

[@danishgopi7490]

thank uuu

[@lailashihab7506]

ലിങ്ക് ചെയ്ത മൊബൈലിൽ നിന്നല്ലേ msg പോകുക.... മൊബൈൽ നമ്പർ ഇല്ലാതെ msg അയക്കാൻ പറ്റുമോ

[@indikuzhiyil]

Most awaited video. Can we send video and audio messages in the same way?

[@sanut811]

Same question

[@mahimathresiasujoy563]

Very useful video...thanks

[@CostingFeri]

Do you want to allow this website to open an application on your computer? how to solve this problem ...... pls reply to me

[@Flyhigh-hi]

നിങ്ങൾ ഒരു മാസാണ് സർ ❤️❤️❤️💖💖💖

[@XLnCADMalayalam]

😇🙌

[@muhammedfairooz2059]

Aashaane pwoli saanam❤

[@nithinjoyvidheyan]

Hi.. Thank you for this useful video. I'm getting a pop up saying "Do you want to allow this website to open an application on your computer? Application: WhatsApp" When I give Allow, it's going to each contact and exiting without sending the message. pls help

[@RaghavBhatt-vh6wh]

facing same issue

[@AbyJo7338]

Nice presentation.. Thank you.. Expecting more videos related to excel data comparison and it's formulas.

[@XLnCADMalayalam]

😀

[@ahdabofficial]

Hi When sending messages showing like "Do you want to allow this website to open an app on your computer" How to remove this

[@techknowtip5835]

kittiyo

[@ksfehelpline3152]

Excellant Sir, very easily explained... thank you so much.. Any method to add files as attachment along with message sir

[@ponkudukka]

Do you want to allow this website to open an application on your computer? ഇത് എന്താ സംഭവം

[@hiteshprajapati5219]

After clicking on the link created after steps given by you, system ask for permission to open whatsapp. if I click "allow" then whatsapp gets open and chat of specified number open but thenafter no process is being done. Any solution for this?

[@mohammedajmal6319]

is you got solution

[@haksarch]

messages are not going through. could you please suggest some corrections if possible. requesing for access to open the whatsapp. but no messages are being sending

[@kiranrr4781]

NIce presentation, How to add a group of people to an existing WhatsApp group without saving the numbers. can you make a video for that..

[@HealthyIssues]

Your presentations are simply superb. Those are always great references for anyone try to explore MS Excel. Regarding this particular video, Can we follow this procedure to share a poster or image with an explanatory message.? If so what should be the modifications in procedure.? Wish to know about it. Please let me know about it.

[@anv123]

Thank YOU 😄👍

[@XLnCADMalayalam]

😀

[@ShaneefKPoyil]

Can we send to groups? Pls reply it will be very useful if I can send to grp.

[@MOHAMMEDRASHIDVP-r2j]

ഇത് ചെയ്ത് നോക്കി. പക്ഷെ ആദ്യത്തെ നമ്പറിലേക്ക് മാത്രമേ default ആയിട്ട് പോകുന്നുള്ളൂ. ബാക്കി ഉള്ളവർക്ക് അയക്കാൻ വീണ്ടും allow button ന്റെ window ok അടിച്ചു കൊടുക്കാൻ പറയുന്നു. അത് clear ചെയ്യുമോ

[@amaanabi8281]

Send bulk. Msg with image attached for marketing purpose ee model. Ill. Oru video chayamooo

[@muneer1258]

Very useful

[@XLnCADMalayalam]

Glad to hear that 😀

[@arumamakan]

Thanks

[@XLnCADMalayalam]

Thank you 😀

[@jithinantonyv]

Internet Explorer Do you want to allow this website to open an application on your computer? Application: WhatsApp Allow Cancel How can I avoid this popup and continue?

[@JayashankarMP]

Same problem here can anyone help

[@zakariyaptpl]

Have you found any solution? Am also getting same.

[@syamlal9692]

awaited video. Thanks a lot.

[@thomasmathew4469]

Sir, I am getting an error " Do you want to allow this website to open an application on your computer" Even if I press Allow, its is asking me each time while sending to the next contact. Pease help... The debug section is highlighting "IE.navigate strPostData". Note: I got this corrected. This will work only if you download the exe file from the internet and run whatsapp . This will not work with whats app from windows store

[@JoshyRS]

how to download it ?

[@anv123]

sir now the code is not working i think , 1) for every contact popup showing to allow 2) no message is going to contact how to update this code??

[@sunildasramachandran8562]

IE ക്ക്‌ പകരം GOOGLE CHROME ആണ് ഉപയോഗിക്കുന്നത്, SO CREATE OBJECTIVE ഇൽ എന്തു മാറ്റം ആണ് വരുത്തേണ്ടത്

[@DhanyaDays]

Thank you .. image send cheyyan patumo

[@lailashihab7506]

മെസ്സേജിനും നമ്പറിലും ഇടക്ക് മറ്റൊരു കോളം കൊടുക്കാൻ പറ്റുമോ എന്തു ചെയ്യണം...? മലയാളം msg അയക്കാമോ

[@santhoshkumar-zu5vk]

Great work , it's sending to all XL contacts at ease... but if any contact number which is not in WhatsApp comes in between , the module kind of crashes , can u help me ?

[@sachin..kumarr.]

Do let me know if u know

[@grazielledamasceno8964]

Perfect!

[@gopikrishna2451]

Sir, I need same vba code to use edge instead of IE. Is it possible

[@ajmalmangalassery3332]

Hloi.. Photos nammuk inagne send cheyyan patumoo?

[@prabhukumarprabhu5448]

Contactൽ ഇല്ലാത്ത നമ്പറിലേക്കും ഇത് അയക്കാൻ പറ്റുമല്ലോ അല്ലെ ??

[@faizelpk9646]

yes

[@MeshalJoseph333]

Yes

[@lithinthampi5819]

Thank you. Please add new video to share a poster or image

[@sparezone-c4k]

കഴിഞ്ഞ 4,5 മാസം ആയിട്ട് ഞാൻ ഈ method ഉപയോഗിക്കുന്നുണ്ടായിരുന്നു.. പക്ഷെ ഇപ്പൊ കുറച്ചായിട്ട് work ആവുന്നിlla...what's problem!!

[@Mubirafeek]

Sir ഇത് ഉപയോഗിച്ചു course details share ചെയ്യാൻ കഴിയുമോ

[@AJMALABDULLA]

Very informative video. Thanks WhatsApp web il ninnu message pokumo?

[@vijeeshkalathil6171]

"The number shared by url is invalid" - Sending to only one number among a list of 5 persons - Kindly resolve - This is an Excellent tool !!

[@dhaneshs5446]

same issue i have

[@RiyazHyder]

This is amazing... 👍 How can we send messages to a group?

[@abdulrauef8961]

ഞാൻ ശ്രമിച്ചു നോക്കി പക്ഷെ വാട്സാപ്പിലേക്ക്‌ വരുന്നില്ല... ക്ലിക്കാവുന്നിണ്ട്‌

[@randysjobs]

Pwoli😍

[@XLnCADMalayalam]

Thank you :)

[@celebrityworld2161]

Appreciated 👍

[@XLnCADMalayalam]

😀

[@dhaneshkm5519]

Superb..

[@XLnCADMalayalam]

Thank you! Cheers!

[@mabrookedathole899]

ഇതുപോലെ ഫോട്ടോസ് സെൻറ് ചെയ്യാൻ പറ്റുമോ ?

[@malayalamprosolutions8149]

🤩🤩🤩🤩Thank you!! I expect more

[@XLnCADMalayalam]

👍

[@abdulsamadv]

Super presentation, can we attach a file in msg?

[@weconsultations4890]

Hi. When i try this every time Whatsapp is asking for message - allow - Is there anyway to remove it

[@sudhikkhalid5944]

Hi... oru pdf file orupad perkk send cheyyanulla option paranj tharamo?? Broadcastil all my contacts ilekk send avanilla...

[@VimalrajMothiravally]

What needs to be done to work this with Google Chrome (Not IE)

[@manesh48]

Is it mandatory to have those contacts in our contact list?

[@shameerek]

no....

[@MeshalJoseph333]

No

[@manojkgeorge7314]

thankyou

[@XLnCADMalayalam]

You're welcome!

[@siljunk6905]

Exel listil ഉള്ള എല്ലാ whatsapp numberum fone contactil saved aakanam yennundo..??

[@jobiyachan]

This is an amazing work. Thank you Ajay sir

[@XLnCADMalayalam]

You are most welcome :)

[@വചനതീരം]

@@XLnCADMalayalam ഞാന്‍ ചെയ്തു നോക്കി മെസ്സേജ് whatsapp ഓപ്പണ്‍ ആയി ഓരോരുത്തരുടെയും മെസ്സേജ് ബാറില്‍ enter ആകുന്നുണ്ട് പക്ഷേ പോസ്റ്റ് ആകുന്നില്ല.എന്താണെന്ന് അറിയില്ല

[@cis8969]

@@വചനതീരം same issue, chilappol adyathe aalk msg send akunnu, bakkiyullavark send akunnilla... oronninum permission mathram chodikkunnu

[@storiesunlimitedmbjayand]

Thanks... നമ്പറിൽ 91 ചേർക്കണോ?

[@sabuisac75]

I tried not working. what could be the possible reason? Clearing the clipboard did not come up in the same way you have shown.

[@lavenderlover369]

ithu googgle sheet use chaithum cheyyamo

[@XLnCADMalayalam]

Google Sheets won't support VBA.

[@vivekiv6696]

superb

[@XLnCADMalayalam]

Thank you! Cheers!

[@muhammedmubashirap2040]

Hi sir.. ഒരു ഡൗട്.. ഒന്നു ക്ലിയർ ചെയോ.. ഇങ്ങനെ ചെയുമ്പോൾ സെന്റിനു shesham എനിക്ക് ഓരോന്നും സെപ്പറേറ്റ് ok കൊടുക്കേണ്ടി വരുന്നുണ്ട്.. അതെങ്ങനാ മാറ്റം വരുത്തുക...😢

[@sojanavarghese4831]

Solution aayo

[@shyjuphilip2476]

Can we mention the date in this message. Example make payment before this date.

[@MehfilJaleelvelom]

Sir.Your vedios is very helpfull .and i tried this vedio content.but am failed.after coming issuses( Set IE = CreateObject("InternetExplorer.Application") pls help me what is the problem

[@abinz_in]

may be you are using mac. same problem i am also facing. IE is not available in mac

[@mohamadabdulsalam9757]

@@abinz_in I have the same problem even using windows 7...

[@creativemediausa]

Nice, what is the difference between this and the broadcast feature in WhatsApp?

[@XLnCADMalayalam]

Customization!

[@creativemediausa]

@@XLnCADMalayalam thanks

[@indikuzhiyil]

You can address each person by name. Message will be very personal

[@manojtjoy]

For broadcast, it is mandatory that your number is to be saved in the contacts of the receiver.Else they will not receive the message

[@hmr_zz]

Chat open avunathe ullu.. not sending

[@Nidhin502]

Ee Text pakaram image send cheyuvan sathikumo?

[@habeel3622]

Sir nammakk text allaaadhe images ingane ayakan patumo ?

[@Bullish-y7v]

Listil 1st numberilekk matrame msg send akunnollu.oro numberilekkum Allow chodikkunnu

[@vgrvishnu15]

Superb👌👌👌

[@Fairooza-so6lf]

Sir posters okke share akaan patuvo

[@rasheedwayanad3847]

Msg അയക്കേണ്ട എല്ലാവരുടെയും നമ്പർ exel ലിൽ അടിക്കണോ?

[@Poojasathyam]

Asking Allow for each time and give allowed the msgs were not send. Can you please help me

[@trincoboys5860]

Can’t sent the msg as it’s showing error couldn’t look up phone number bcox it’s either missing country code or wrong number I used uae number pls help how to enter correctly

[@miscellaniousvideos9010]

can we autotrigger the send message button,once it reaches the due date

[@RaghavBhatt-vh6wh]

Date in cell is showing different when used like &b2& where date is available in b2 eg: 8/3/2024 showing like 42256. can you help ?

[@risnajmal7090]

sir, how to send a table which include salary details.

[@anjanajayachandran6570]

Whatsapp update chythappol work avunilla. Any suggestions

[@hashifc8885]

msg automatic aayi send aakunnilla, athinte kaaranam enthhanu sir

[@nuaimyhasan1675]

Can we send a message to unsaved numbers?

[@worldsbestweddingdj2753]

Can you do this video in English please :) many thanks

[@nihalnazer6148]

Ithil images send cheyyan pattumo?

[@UnniKrishnan-wv6hz]

Good evening. How to insert one excel file with other files? Your response is highly appreciated. Example one Excel file I am having 3 sheets and I want to insert some additional sheets from other files....

[@NIKHILKANNANCHERY]

Use copy and move option.

[@muhammedajmal1784]

കുറേ ഗ്രൂപ്പിലേക്ക് message ചെയ്യാൻ പറ്റുമോ

[@vandananair1274]

" the macro may not be available in this wotk book" why this error is occurring?

[@sanalkumarar503]

File Attachments Add cheyyan പറ്റുമോ ?

[@vijesh]

Google sheet il pattumo ithu?

[@lijin.k1688]

Ethil Enikk error kaanikkund ath enthkondaan vann Enn parayaamo

[@NanduKrishna-u5z]

Can I send a link through this

[@Creatoro855]

Hi, can this be done in googlesheet?

[@shahaskal]

Hi, My WhatsApp automatically logged out after sending first message, now am unable to link my WhatsApp in windows.

[@sunilfrancisp2523]

Google sheetil pattumo

[@Aldrinbritto]

sir can you update.. now we cant send the messages. can you please update or try for the solutions. thankyou