Рет қаралды 29,613
In this video, we will how we can send unlimited whatsapp messages to various different contacts using microsoft excel. We will do this task with the help of VBA code.
इस विडियो में हम देखेंगे की कैसे हम माइक्रोसॉफ्ट एक्सेल से व्हात्सप्प पर अनलिमिटेड मेसेज भेज सकते है वो भी अलग अलग नंबर्स पर. यह काम हम VBA कोडिंग की सहायता से करेंगे.
#techalert #technical #howto
****************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 "~"
SendKeys "~"
Next i
End Sub
********************************************
Our social media accounts :
Facebook : / techalertr
Instagram : / techalertr
Twitter : / techalertr
Pinterest : / techalertr
Reddit : / techalertr
Tumblr : techalertr.tumblr.com
Our Other channels :
1. kzfaq.info...
2. kzfaq.info...
SEO:
Send Unlimited messages from EXCEL to Whatsapp automatically,एक्सेल से व्हात्सप्प पर मेसेज भेजें ,excel to whatsapp,send bulk whatsapp message from excel,send free unlimited whatsapp bulk message from excel,excel to whatsapp message,whatsapp excel,excel whatsapp,send whatsapp message from excel,send message from excel to whatsapp,send whatsapp from excel,excel to whatsapp message code,download excel to whatsapp,
excel to whatsapp bulk message,whatsapp message from excel,whatsapp message to excel,automatically send whatsapp message from excel,bulk whatsapp from excel,whatsapp bulk sender excel,spreadsheet to whatsapp,