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
Wow, this is super useful. Thank you 👍.
വളരെ ഉപകാരപ്രദമായ ട്യൂട്ടോരിയൽ
awaited video. Thanks a lot.
Aashaane pwoli saanam❤
Nice presentation.. Thank you.. Expecting more videos related to excel data comparison and it's formulas.
@XLnCADMalayalam
Жыл бұрын
😀
അടിപൊളി. അയക്കുന്നവരോട് 1000 നമ്പറിൽ കൂടുതൽ ഒരു ദിവസം അയച്ചാൽ വാട്സാപ്പ് ബ്ലോക്കാവനുള്ള സാധ്യതയുണ്ട്
@XLnCADMalayalam
Жыл бұрын
👍
@shafeek_yeppi8273
Жыл бұрын
Maximum എത്ര പേർക് അയക്കാം ഡെയിലി
Very useful video...thanks
Excellant Sir, very easily explained... thank you so much.. Any method to add files as attachment along with message sir
Ajay chetta... Awesome Work.. മാസങ്ങൾ ആയിട്ട് waiting ആയിരുന്നു.. Pwoli♥️
@sojanavarghese4831
27 күн бұрын
ഇത് work ആവുന്നുണ്ടോ
thank uuu
This is amazing... 👍 How can we send messages to a group?
Superb👌👌👌
Perfect!
🤩🤩🤩🤩Thank you!! I expect more
@XLnCADMalayalam
Жыл бұрын
👍
Your voice is also superb as your presentation
@XLnCADMalayalam
Жыл бұрын
Thank you :)
Thank you. Please add new video to share a poster or image
Super presentation, can we attach a file in msg?
Great work. Nicely explained.
@XLnCADMalayalam
2 ай бұрын
Thank you :)
നിങ്ങൾ ഒരു മാസാണ് സർ ❤️❤️❤️💖💖💖
@XLnCADMalayalam
Жыл бұрын
😇🙌
Send bulk. Msg with image attached for marketing purpose ee model. Ill. Oru video chayamooo
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.
Appreciated 👍
@XLnCADMalayalam
Жыл бұрын
😀
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..
Great... Can we add attachment automatically ??
Very informative video. Thanks WhatsApp web il ninnu message pokumo?
Superb..
@XLnCADMalayalam
Жыл бұрын
Thank you! Cheers!
Whatsapp message going with VB code as well
@XLnCADMalayalam
Жыл бұрын
Press Win +V to activate the Windows Clipboard. Clear it and try again.
Thank YOU 😄👍
@XLnCADMalayalam
Жыл бұрын
😀
ഇത് ഉപയോഗിച്ച് ഫോട്ടോ അയക്കാൻ പറ്റുമോ 🤔🤔
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
6 ай бұрын
kittiyo
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
4 ай бұрын
facing same issue
Very useful
@XLnCADMalayalam
Жыл бұрын
Glad to hear that 😀
This is an amazing work. Thank you Ajay sir
@XLnCADMalayalam
Жыл бұрын
You are most welcome :)
@user-wm3ro8ms9l
Жыл бұрын
@@XLnCADMalayalam ഞാന് ചെയ്തു നോക്കി മെസ്സേജ് whatsapp ഓപ്പണ് ആയി ഓരോരുത്തരുടെയും മെസ്സേജ് ബാറില് enter ആകുന്നുണ്ട് പക്ഷേ പോസ്റ്റ് ആകുന്നില്ല.എന്താണെന്ന് അറിയില്ല
@cis8969
Жыл бұрын
@@user-wm3ro8ms9l same issue, chilappol adyathe aalk msg send akunnu, bakkiyullavark send akunnilla... oronninum permission mathram chodikkunnu
Most awaited video. Can we send video and audio messages in the same way?
@sanut811
Жыл бұрын
Same question
Pwoli😍
@XLnCADMalayalam
Жыл бұрын
Thank you :)
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
superb
@XLnCADMalayalam
Жыл бұрын
Thank you! Cheers!
Sir, I need same vba code to use edge instead of IE. Is it possible
Can we send to groups? Pls reply it will be very useful if I can send to grp.
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.
Great
@XLnCADMalayalam
Жыл бұрын
😀
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??
Can we mention the date in this message. Example make payment before this date.
thankyou
@XLnCADMalayalam
Жыл бұрын
You're welcome!
Wow greate. ക്യാഷ് അല്ലാതെ നോർമൽ ടെക്സ്റ്റ്കളോ ലിങ്കുകളോ അയക്കാൻ പറ്റുമോ
@lijoidukki
Жыл бұрын
Atha njanum nokkunne
Thanks
@XLnCADMalayalam
Жыл бұрын
Thank you 😀
Sir, I need same vba code to use google chrome instead of IE. Is it possible
Do you want to allow this website to open an application on your computer? how to solve this problem ...... pls reply to me
can we autotrigger the send message button,once it reaches the due date
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.
Nice
@XLnCADMalayalam
Жыл бұрын
😀
sir, how to send a table which include salary details.
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
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
21 күн бұрын
is you got solution
"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
Can you send documents and image files?
What needs to be done to work this with Google Chrome (Not IE)
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
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 ?
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.
sir can you update.. now we cant send the messages. can you please update or try for the solutions. thankyou
sir, any way to forward pdf files... eg. payslip
Thankk you...but this didn't work with my Excel 2013
I tried not working. what could be the possible reason? Clearing the clipboard did not come up in the same way you have shown.
How to send teams application messages from Excel. ?? Video ondo ?
Asking Allow for each time and give allowed the msgs were not send. Can you please help me
Hi, My WhatsApp automatically logged out after sending first message, now am unable to link my WhatsApp in windows.
is it nessary to have the phone numbers in our contact list ??? if those number are not in your whats app contact list - then ?
ലിങ്ക് ചെയ്ത മൊബൈലിൽ നിന്നല്ലേ msg പോകുക.... മൊബൈൽ നമ്പർ ഇല്ലാതെ msg അയക്കാൻ പറ്റുമോ
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 ?
Error in red when i paste the ecode. excel error message : Compile error : Expected :end of statement . strPhoneNumber and the next line in red
Hi, can this be done in googlesheet?
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
👍
@XLnCADMalayalam
Жыл бұрын
😀
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...
Is it possible to send msgs to many groups like this?
👍👍👌👌👍👍
@XLnCADMalayalam
Жыл бұрын
😀
Any options to send messages from web. WhatsApp
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
10 ай бұрын
use &"%0A" IN THE FORMULA SECTION FOR A SINGLE LINE BREAK, REPEAT IT TO MULTIPLE LINE BREAK
Can you do this video in English please :) many thanks
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
9 ай бұрын
Alt+Enter
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
Can I send a picture in the same way?
🥰🤗
@XLnCADMalayalam
Жыл бұрын
😀
Asking Allow for each time, Can you help me here..
" the macro may not be available in this wotk book" why this error is occurring?
❤❤❤
@XLnCADMalayalam
Ай бұрын
😀👍
Is it possible with Google sheets ?
Hello sir, എക്സൽ ഷീറ്റിൽ ഒരു ഇൻവോയ്സ് തയാറാക്കി അതിന്റെ ഇമേജ് വാട്സാപ്പിൽ അയക്കുന്നതിന് ഹെൽപ് ചെയ്യുമോ
Do you want to allow this website to open an application on your computer? ഇത് എന്താ സംഭവം
Asking permission for sending and it’s not working automatically. Please help me anyone knows about this bug. 😊
Hi... oru pdf file orupad perkk send cheyyanulla option paranj tharamo?? Broadcastil all my contacts ilekk send avanilla...
Hi. When i try this every time Whatsapp is asking for message - allow - Is there anyway to remove it
this work only in IE only?
Very helpfull...... but how to save the file, when saving shows error
@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
Жыл бұрын
@@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...🙏🙏
whatsapp chat window is opened for each contacts . but messages are not sent
HI, DO YOU HAVE IT IN ENGLISH OR HINDI ?
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
2 ай бұрын
I have also this problem
Run- time error 9 Subscript out of range Showing this error message while sending
Is it mandatory to have those contacts in our contact list?
@shameerek
Жыл бұрын
no....
@MeshalJoseph333
Жыл бұрын
No