How to send Bulk Message from Excel to Whatsapp
HTML-код
- Опубликовано: 8 сен 2024
- Hi viewers,In this video you will learn how to send the simple bulk message from excel to whatsapp.This will be very helpful in your business and work place.
Coding:
Sub WhatsAppMsg()
Dim LastRow As Long
Dim i As Integer
Dim strip As String
Dim strPhoneNumber As String
Dim strmessage As String
Dim strPostData As String
Dim IE As Object
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
strPhoneNumber = Sheets("Data").Cells(i, 1).Value
strmessage = Sheets("Data").Cells(i, 2).Value
'IE.navigate "whatsapp://send?phone=phone_number&text=your_message"
strPostData = "whatsapp://send?phone=" & strPhoneNumber & "&text=" & strmessage
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate strPostData
Application.Wait Now() + TimeSerial(0, 0, 5)
SendKeys "~"
Next i
End Sub
Kindly like,share and subscribe the channel! Share my website and playlist videos to computer science students and professors you know..
Any Queries/suggestion mail us..
mastereducationugcnet@gmail.com
Kindly do your little contribution to us to make better videos for you
UPI ID :manjulavimalesh-1@okhdfcbank
Fill the below form to get the Free softcopy of coding and procedure to your mail ..and let me know what type of videos you need docs.google.co...
Thankyou so much ! Happy learning !Easy Learning!
![Send WhatsApp Messages from Excel! [Tutorial]](http://i.ytimg.com/vi/rR-MQej9fdc/mqdefault.jpg)
![Send WhatsApp Messages from Excel! [Tutorial]](/img/tr.png)
Thank you madam.....its working very Useful ❤
isnot working sir please help
Thanks for sharing coding. It is working perfectly. Now, also tell how to send message from multiple columns together?
Call me rameshbabu how is it working in ur system
Excellent. Crystal Clear Madam Voice. Simple / Short / Clear. No Wasting of Time. Worthable. No Thirdparty Tool. Inbuilt Microsoft Environment. No Licence Required. No Copyright Issues.
Thank You So Much.
If you possible, can you provide me "Which way we can see BROADCAST LIST in WhatsApp Web"?. Because in WhatsApp Web Version, we are unable to see BROADCAST LIST. Can you help me regarding ? Thanks in advance.
Thanks sir.. Broadcast is not allowed in what's app so far.. They will ban the no if we do that..
Thank you so much! It works great! How many messages can I send ? Is there any chance of being blocked by WhatsApp?
did you find out?
thank you for the great help
Not working
Whatsapp app is opening but the msgs are not sending
Coding mai message hua hoga? Kyuki baki sab ka hua he work bro
This doesn't work with the latest version of whatsapp desktop application.. anyone experienced and resolved this.
Hi Madam, I try but is not working. I think is because you set the Marco to IE but I am using chrome? Can teach us how? Thank you ❤️☺️
Super sister ..thnku ,nice work
Thank you very much
Madam, I didn't find coding and description box too. Please help
Thanks for the code. My whats app is getting opened but the messages are not getting sent automatically,
can u teel us how this code changes instead of IE to Edge
this message appear to me : License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.
Excellent.mdm plz help. when can't send 500 spelling space message
check the long message video
The code that is "given in the description box", where is that exactly? You did not explain where we get it from. Can you please reply
Take the code from the description..the three dots on right side,click that mam..or ask someone about description..
@@manjuvimal8114 The video would have been great if you show in the video where to get the description from because that is all what I'm missing (and I'm sure other viewers too). I still can't find it and your message did not help, it's ambiguous. Please elaborate
which version of microsoft office you are using
Mam did we have to click allow every time when he send a message.
good day Madam, everything is OK for me
but every time it started, need to click "allow" , can skip this warning? thank you and have a nice day
Mr.prasannakumar, how it is working in mserge
I'm using mozila Firefox browser so the code doesn't work, please explain to me how to edit the code to use Firefox
How to get the code from description box & paste - please explain
I have the same question
where is coding window
How to send bulk massage excel to mobile sms?
Hello, previously message were sending but now it only opens the Whatsapp but is not sending. message is also not typy
sir please update
Hello, it only opens the Whatsapp but is not sending.
Not working madam
Hi madam it will not be working properly what's app , after applying the code
Messages was not send only what's app number is opening. What's the reason!
When i click send, its going to the whatsapp number but no message is created.
What should I do
Exactly! same issue
Clean the showcase 😂
Does it work in whatsapp business?
If we have excel 2007 then
Mine sent blank messages
how to insert the image
Hello madam, jesy ap ny kia hy sara process wesy hi kia hy lkn jb send ka button click krty hy to allow ki window open hojati lkn whatsapp k through msg send nhi hota kindly iska solution to guide kr dein
Hi. If your PHONE NUMBER is column G and your MESSAGE column L, what do you need to change in the code?
I guess Cells(i',1) refers to row2 and down in column1 and Cells(i,2) refers to row2 and down in column 2. So the phone number in column G will be Cells(i,7) and the message will be Cells(i,12)???
Also had to change the RANGE to G.
is this working in excell 2007
Bro upto, that numbers opening in whatsapp, but message is not coming in the text box. pls reply the solution
Same issue bro...did u find any soln.?
@@deepaksainandigana4672 no bro tried a lot.
Any body can show like this. Where is the code for Ms edge not ie
Hi, where Is the code?
Mujhe link dalna he number mai bada long message he kese dalu
unspecified error
For me "SEND" is not working
How can I copy codes
error show horaha
Does not work for me.
not working
plz help
It's not working dear
First of all say any one cintact number if any doubt to ask directly
Pl let me know get code
Please send me the code
can it send up to 1m whatsapp numbers ?
Code error
Word allow alloo ni
not working
didnt work
Syntax error
please send me the coding
In description
I tried so many times but not working totally one day waste
jab bhi send pr click kro
dont press the send button..it will go automatically..chk the video and do slowly
@@manjuvimal8114 mdm plz help. when i press send button whatsaap opening and showing Phone no shred via url is invalid msg showing what should i do plz reply
Not wORKING
Hi madam I need this for my business but it's not working for me can you give me your mail ID I will contact you
kindly watch the video again and do it slowly from the first without changing any sequence..patience and preseverance is important in this process..for me also it takes some time to workout..so dont worry..do again and again slowly..atpresent i am busy in my work..