Now we can send bulk messages in Whatsapp from Excel. Before using the code, you must see above video.
Friends nowadays whatsapp become popular everywhere, and also for business. We send lots of business related messages to our customers or office employees, like outstanding details, invoice details, address etc.
Sometime we need to send bulk whataspp messages to multiple contact. To avoid this lengthy process we need to make a tool that can send bulk whatsapp.
So lets create whatsapp sender in Excel VBA. Follow bellow steps to create whatsapp sender:
- First of all open a Microsoft Excel File
- Goto Developer Tab (If not enable developer tab in your Excel, watch above video)
- Add a module to write codes.
Excel to Whatsapp Code:
Sub Whatsappmst()
On Error Resume Next
Dim rowsz As Long
rowsz = 1000
rowsz = Wapp.Cells.End(xlDown).Row
Dim z As Integer
For z = 2 To rowsz
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
If Wapp.Cells(z, 2) = vbNullString Then
Exit Sub
Else
ie.navigate "whatsapp://send?phone=" & Wapp.Cells(z, 2) & "&text=" & Wapp.Cells(z, 3)
Application.Wait Now() + TimeSerial(0, 0, 3)
SendKeys "~", True
End If
Next z
End Sub- Paste above code in a VBA module
- Create Some contacts and messages in Excel
- We can create Macro Button to send whatsapp messages. (Watch the above video)
Now our whatsapp sender is ready to use.
-
How to Send Invoices Directly from TallyPrime to WhatsApp (New Automation TDL)
In today’s fast-paced digital business environment, waiting days for an email invoice to be opened is a thing of the past. Customers now expect instant communication, and WhatsApp has become the ultimate tool for quick business transactions. But if you are using Tally Prime, exporting a PDF and manually sending it to a client’s WhatsApp…
-
Free Excel to Tally
Tally XML Converter Use Excel,Text,CSV etc file. Columns should be same as Templates. Paste Data-Choose XML Type-Click on Create File and Download. Paste XML file path in Tally Import to Create Entry. Click for Learning Videos LEARNWELL VIDEO. Create file
-
PHP
Import Data into Tally Import Data into Tally Excel File:
