How to send Bulk Message from Excel to Whatsapp

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

*Kindly do your little contribution to us to make better videos for you*
Thankyou so much ! Happy learning !Easy Learning!

[janakiramagupta]

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.

[Mera_Nivesh]

Thanks for sharing coding. It is working perfectly. Now, also tell how to send message from multiple columns together?

[raymondchan]

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 ❤️☺️

[giselaolavarria]

Thank you so much! It works great! How many messages can I send ? Is there any chance of being blocked by WhatsApp?

[tkamal]

which version of microsoft office you are using

[apagarawal]

Not working
Whatsapp app is opening but the msgs are not sending

[crazyblack]

can u teel us how this code changes instead of IE to Edge

[mohanraj-qgnr]

Mr.prasannakumar, how it is working in mserge

[ahmedsameir]

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.

[MsArchiu]

Thanks for the code. My whats app is getting opened but the messages are not getting sent automatically,

[Deepchand-zpjh]

Mam did we have to click allow every time when he send a message.

[birurai]

Madam, I didn't find coding and description box too. Please help

[ivanlaw]

Excellent.mdm plz help. when can't send 500 spelling space message

[harishpatel]

Hello, previously message were sending but now it only opens the Whatsapp but is not sending. message is also not typy

[harshiljadav]

Messages was not send only what's app number is opening. What's the reason!

[ahladandy]

How to get the code from description box & paste - please explain

[abdulhafeezshaik]

Hi madam it will not be working properly what's app, after applying the code

[heshamhelmy]

I'm using mozila Firefox browser so the code doesn't work, please explain to me how to edit the code to use Firefox

[soumitrahldr]

How to send bulk massage excel to mobile sms?

[uqimotx]

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