Sending bulk messages on WhatsApp is essential to increase sales and build communication across users. Sending the same message to multiple users on WhatsApp is a manual task. Here, I have shared the detailed tutorial to send 100% free bulk messages on WhatsApp using Excel macro.
Suppose, you are working as an office staff at a school and you want to send certain information to all school students regularly. In that situation, you can use this tutorial to send bulk messages using Excel.
Please note that this post is only for educational purposes. If you are sending messages on WhatsApp to unknown persons continuously then you may get banned.
Excel Macro For Sending Free Bulk Messages On WhatsApp
Excel is a powerful tool, you can use it for many purposes. Here, I have shared the simple macro that helps you to send bulk messages on WhatsApp.
Follow the below steps,
Download and Install WhatsApp in your Personal Computer or Laptop
Open your Excel App
Go to settings and Enable the Developer Ribbon
Go to the Developer Option > Click Macros > Provide Macro Name > Click Create
Copy and Paste the Below Macro and hit the Save Button
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
Save the workbook as Macro Enabled Workbook
Now, Go to Developer > Select Insert > Click Button > Draw a Button > Select created macro
Column A is for Mobile Number and Column B is for Message
Please type the mobile number starts with 91XXXXXXXXX in column A and type the message in column B.
Now, click the button to send the message. Your messages will start to deliver.
Conclusion
Using this excel macro, you can send bulk messages on WhatsApp for free. Please do not use this method to send messages to unknown persons. If they report you, then your WhatsApp number will get banned.
If you are facing any issues, please comment in the comment section. I will send you the macro-inserted excel file to you.
Sir Im facing issue like
In 1 device – OLE action required
in 2 nd device – msg not able send
and
the following features cannot be saved in macro free work books:
vb project……………………………………………………………………………………….like that a dialogue box appears.