How to send Whatsapp Messages from Excel - Malayalam Tutorial

എക്സലിൽ ഉപയോഗിച്ച് ഒറ്റ ക്ലിക്കിൽ നൂറു കണക്കിന് ആളുകൾക്ക് വാട്സാപ്പ് മെസ്സേജ് അയക്കുന്ന ടെക്നിക്ക്.
How to send WhatsApp messages from Excel, explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
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/course/learn-mi...
#exceltowhatsapp #whatspptricks #excelmalayalam

Пікірлер: 231

  • @benoyav9779
    @benoyav9779 Жыл бұрын

    Wow, this is super useful. Thank you 👍.

  • @vallavilasreekumar4420
    @vallavilasreekumar4420 Жыл бұрын

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

  • @syamlal9692
    @syamlal9692 Жыл бұрын

    awaited video. Thanks a lot.

  • @muhammedfairooz2059
    @muhammedfairooz2059 Жыл бұрын

    Aashaane pwoli saanam❤

  • @abybaby7338
    @abybaby7338 Жыл бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @The-anav.
    @The-anav. Жыл бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    👍

  • @shafeek_yeppi8273

    @shafeek_yeppi8273

    Жыл бұрын

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

  • @mahimathresiasujoy563
    @mahimathresiasujoy563Ай бұрын

    Very useful video...thanks

  • @ksfehelpline3152
    @ksfehelpline31522 ай бұрын

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

  • @dingandheeran6289
    @dingandheeran6289 Жыл бұрын

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

  • @sojanavarghese4831

    @sojanavarghese4831

    27 күн бұрын

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

  • @danishgopi7490
    @danishgopi749011 ай бұрын

    thank uuu

  • @RiyazHyder
    @RiyazHyder Жыл бұрын

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

  • @vgrvishnu15
    @vgrvishnu15 Жыл бұрын

    Superb👌👌👌

  • @grazielledamasceno8964
    @grazielledamasceno89643 ай бұрын

    Perfect!

  • @malayalamprosolutions8149
    @malayalamprosolutions8149 Жыл бұрын

    🤩🤩🤩🤩Thank you!! I expect more

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    👍

  • @sreenathkdeva1001
    @sreenathkdeva1001 Жыл бұрын

    Your voice is also superb as your presentation

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Thank you :)

  • @lithinthampi5819
    @lithinthampi5819 Жыл бұрын

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

  • @abdulsamadv
    @abdulsamadv Жыл бұрын

    Super presentation, can we attach a file in msg?

  • @rapirabu
    @rapirabu2 ай бұрын

    Great work. Nicely explained.

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 ай бұрын

    Thank you :)

  • @navasnr
    @navasnr Жыл бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😇🙌

  • @amaanabi8281
    @amaanabi8281 Жыл бұрын

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

  • @HealthyIssues
    @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.

  • @celebrityworld2161
    @celebrityworld2161 Жыл бұрын

    Appreciated 👍

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @kiranrr4781
    @kiranrr47814 ай бұрын

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

  • @mmbcampus
    @mmbcampus3 ай бұрын

    Great... Can we add attachment automatically ??

  • @AJMALABDULLA
    @AJMALABDULLA Жыл бұрын

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

  • @dhaneshkm5519
    @dhaneshkm5519 Жыл бұрын

    Superb..

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Thank you! Cheers!

  • @shefeeks123
    @shefeeks123 Жыл бұрын

    Whatsapp message going with VB code as well

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

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

  • @anv123
    @anv123 Жыл бұрын

    Thank YOU 😄👍

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @MrStalinAlex
    @MrStalinAlex Жыл бұрын

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

  • @ahdabschool9115
    @ahdabschool9115 Жыл бұрын

    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

    @techknowtip5835

    6 ай бұрын

    kittiyo

  • @nithinjoyvidheyan
    @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

    @RaghavBhatt-vh6wh

    4 ай бұрын

    facing same issue

  • @muneer1258
    @muneer1258 Жыл бұрын

    Very useful

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Glad to hear that 😀

  • @jobiyachan
    @jobiyachan Жыл бұрын

    This is an amazing work. Thank you Ajay sir

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    You are most welcome :)

  • @user-wm3ro8ms9l

    @user-wm3ro8ms9l

    Жыл бұрын

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

  • @cis8969

    @cis8969

    Жыл бұрын

    @@user-wm3ro8ms9l same issue, chilappol adyathe aalk msg send akunnu, bakkiyullavark send akunnilla... oronninum permission mathram chodikkunnu

  • @indikuzhiyil
    @indikuzhiyil Жыл бұрын

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

  • @sanut811

    @sanut811

    Жыл бұрын

    Same question

  • @randysjobs
    @randysjobs Жыл бұрын

    Pwoli😍

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Thank you :)

  • @robinsjoseph2347
    @robinsjoseph2347 Жыл бұрын

    I want to add image along with the text .... so what am I suppose to do? and without giving names on the columns coz I have 100 numbers without names too

  • @vivekiv6696
    @vivekiv6696 Жыл бұрын

    superb

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Thank you! Cheers!

  • @gopikrishna2451
    @gopikrishna2451 Жыл бұрын

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

  • @ShaneefKPoyil
    @ShaneefKPoyil Жыл бұрын

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

  • @UnniKrishnan-wv6hz
    @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

    @NIKHILKANNANCHERY

    Жыл бұрын

    Use copy and move option.

  • @AMJATHKHANKT
    @AMJATHKHANKT Жыл бұрын

    Great

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @anv123
    @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??

  • @shyjuphilip2476
    @shyjuphilip2476 Жыл бұрын

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

  • @manojkgeorge7314
    @manojkgeorge7314 Жыл бұрын

    thankyou

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    You're welcome!

  • @THOMASPAYIKATTUVAYALILABRAHAM
    @THOMASPAYIKATTUVAYALILABRAHAM Жыл бұрын

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

  • @lijoidukki

    @lijoidukki

    Жыл бұрын

    Atha njanum nokkunne

  • @arumamakan
    @arumamakan Жыл бұрын

    Thanks

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Thank you 😀

  • @prashanttiwari4274
    @prashanttiwari42746 ай бұрын

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

  • @user-gj8jo8ks6w
    @user-gj8jo8ks6w5 ай бұрын

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

  • @miscellaniousvideos9010
    @miscellaniousvideos90103 ай бұрын

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

  • @jithinantonyv
    @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

    @JayashankarMP

    Жыл бұрын

    Same problem here can anyone help

  • @zakariyaptpl

    @zakariyaptpl

    Жыл бұрын

    Have you found any solution? Am also getting same.

  • @junujaan7557
    @junujaan7557 Жыл бұрын

    Nice

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @risnajmal7090
    @risnajmal70905 ай бұрын

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

  • @santhoshkumar-zu5vk
    @santhoshkumar-zu5vk6 ай бұрын

    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.

    @sachin..kumarr.

    Ай бұрын

    Do let me know if u know

  • @hiteshprajapati5219
    @hiteshprajapati52194 ай бұрын

    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

    @mohammedajmal6319

    21 күн бұрын

    is you got solution

  • @vijeeshkalathil6171
    @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

    @dhaneshs5446

    Жыл бұрын

    same issue i have

  • @jahfarkottoor8646
    @jahfarkottoor8646 Жыл бұрын

    Can you send documents and image files?

  • @VimalrajMothiravally
    @VimalrajMothiravally Жыл бұрын

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

  • @haksarch
    @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

  • @RaghavBhatt-vh6wh
    @RaghavBhatt-vh6wh4 ай бұрын

    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 ?

  • @ratheeshjaganath
    @ratheeshjaganath Жыл бұрын

    Having issue with phone number format. In excel I have formated the column 3 with country code. I am getting a pop up that the number is not on whatsapp. Is any one having similar issue and is it resolved..Will be grateful to know how to fix this issue.

  • @user-sv5qp5md1r
    @user-sv5qp5md1r8 ай бұрын

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

  • @sreejithsl5477
    @sreejithsl5477 Жыл бұрын

    sir, any way to forward pdf files... eg. payslip

  • @omotolaonigbinde5588
    @omotolaonigbinde55882 күн бұрын

    Thankk you...but this didn't work with my Excel 2013

  • @sabuisac75
    @sabuisac757 ай бұрын

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

  • @mithunamrutha3122
    @mithunamrutha3122 Жыл бұрын

    How to send teams application messages from Excel. ?? Video ondo ?

  • @Poojasathyam
    @Poojasathyam3 ай бұрын

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

  • @shahaskal
    @shahaskal Жыл бұрын

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

  • @KrishnaKumarDS
    @KrishnaKumarDS Жыл бұрын

    is it nessary to have the phone numbers in our contact list ??? if those number are not in your whats app contact list - then ?

  • @lailashihab7506
    @lailashihab75065 ай бұрын

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

  • @thomasmathew4469
    @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

    @JoshyRS

    Жыл бұрын

    how to download it ?

  • @pelim1036
    @pelim10367 ай бұрын

    Error in red when i paste the ecode. excel error message : Compile error : Expected :end of statement . strPhoneNumber and the next line in red

  • @Creatoro855
    @Creatoro8554 ай бұрын

    Hi, can this be done in googlesheet?

  • @trincoboys5860
    @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

  • @lineeshvtk1
    @lineeshvtk1 Жыл бұрын

    👍

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @MehfilJaleelvelom
    @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

    @abinz_in

    Жыл бұрын

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

  • @mohamadabdulsalam9757

    @mohamadabdulsalam9757

    Жыл бұрын

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

  • @sandeeps18
    @sandeeps18 Жыл бұрын

    Is it possible to send msgs to many groups like this?

  • @mohammedbatheri706
    @mohammedbatheri706 Жыл бұрын

    👍👍👌👌👍👍

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @Aneeshmbaa
    @Aneeshmbaa Жыл бұрын

    Any options to send messages from web. WhatsApp

  • @shameeromer5540
    @shameeromer5540 Жыл бұрын

    Thank you. Can you please suggest how we can use line break?. I tried alt+enter and CHAR(10) and both of them are not working.

  • @mohammedsameer2737

    @mohammedsameer2737

    10 ай бұрын

    use &"%0A" IN THE FORMULA SECTION FOR A SINGLE LINE BREAK, REPEAT IT TO MULTIPLE LINE BREAK

  • @worldsbestweddingdj2753
    @worldsbestweddingdj27533 ай бұрын

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

  • @gokuls6288
    @gokuls6288 Жыл бұрын

    Thank You! How to send 4 or 5 paragraphs in s single message? While trying to send in the same way, paragraph separation is not happening.

  • @christinantony6203

    @christinantony6203

    9 ай бұрын

    Alt+Enter

  • @creativemediausa
    @creativemediausa Жыл бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Customization!

  • @creativemediausa

    @creativemediausa

    Жыл бұрын

    @@XLnCADMalayalam thanks

  • @indikuzhiyil

    @indikuzhiyil

    Жыл бұрын

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

  • @manojtjoy

    @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

  • @ArunKumar-rs8um
    @ArunKumar-rs8um Жыл бұрын

    Can I send a picture in the same way?

  • @kkishork
    @kkishork Жыл бұрын

    🥰🤗

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    😀

  • @Parnitha_G
    @Parnitha_G6 ай бұрын

    Asking Allow for each time, Can you help me here..

  • @vandananair1274
    @vandananair1274Ай бұрын

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

  • @Drvishnucnair
    @DrvishnucnairАй бұрын

    ❤❤❤

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Ай бұрын

    😀👍

  • @dr.basanthkb
    @dr.basanthkb Жыл бұрын

    Is it possible with Google sheets ?

  • @ArchanaAyyappan-iq4qp
    @ArchanaAyyappan-iq4qp8 ай бұрын

    Hello sir, എക്സൽ ഷീറ്റിൽ ഒരു ഇൻവോയ്സ് തയാറാക്കി അതിന്റെ ഇമേജ് വാട്സാപ്പിൽ അയക്കുന്നതിന് ഹെൽപ് ചെയ്യുമോ

  • @ponkudukka
    @ponkudukka3 ай бұрын

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

  • @ziagi0076
    @ziagi007611 ай бұрын

    Asking permission for sending and it’s not working automatically. Please help me anyone knows about this bug. 😊

  • @sudhikkhalid5944
    @sudhikkhalid5944 Жыл бұрын

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

  • @weconsultations4890
    @weconsultations48902 ай бұрын

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

  • @camuhammedfaisal7280
    @camuhammedfaisal7280 Жыл бұрын

    this work only in IE only?

  • @noushadgdr1
    @noushadgdr1 Жыл бұрын

    Very helpfull...... but how to save the file, when saving shows error

  • @XLnCADMalayalam

    @XLnCADMalayalam

    Жыл бұрын

    Save the Excel Workbook as 'Macro Enabled Workbook' (.xlsm format). Check my videos Excel Macros/Programming in Excel. I have explained this procedure in most of them.

  • @noushadgdr1

    @noushadgdr1

    Жыл бұрын

    @@XLnCADMalayalam Sir, it was working good but now it shows...."Do you want to allow this website to open an app on you computer?" if i give allow still not sending message.... pls help me...🙏🙏

  • @irshadahammedop2270
    @irshadahammedop2270 Жыл бұрын

    whatsapp chat window is opened for each contacts . but messages are not sent

  • @renuoswal7048
    @renuoswal70487 ай бұрын

    HI, DO YOU HAVE IT IN ENGLISH OR HINDI ?

  • @vineeshv8300
    @vineeshv8300 Жыл бұрын

    Hi , issue 1: automatically msg not sending. for each msg asking allow comment. issue 2 : msgs not sending to any one. note - msg mentioned in correct column can you help to resolve this issue

  • @SUHAILPMabukhadeeja

    @SUHAILPMabukhadeeja

    2 ай бұрын

    I have also this problem

  • @savadpts
    @savadpts Жыл бұрын

    Run- time error 9 Subscript out of range Showing this error message while sending

  • @manesh48
    @manesh48 Жыл бұрын

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

  • @shameerek

    @shameerek

    Жыл бұрын

    no....

  • @MeshalJoseph333

    @MeshalJoseph333

    Жыл бұрын

    No

Келесі