In this video we will see how we can send bulk messages in whatsapp using microsoft excel. We will write some lines of VBA code and we are good to go. The main requirement for using this code is you must have whatsapp desktop application pre installed in your computer system.
Download whatsapp : www.whatsapp.com/download
**********************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
ActiveSheet.Shapes(1).Copy
'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 + TimeValue("00:00:05"))
Call SendKeys("^v")
Application.Wait (Now + TimeValue("00:00:05"))
Call SendKeys("{Enter}", True)
'Application.Wait Now() + TimeSerial(0, 0, 5)
'SendKeys "~"
Next i
End Sub
************************************************
#thesketcher #howto #excel
Subscribe to our other channels :
The sketcher : kzfaq.info...
Tech ALERT : kzfaq.info?...
Information Techy :kzfaq.info...
Follow us on fb : / thesketcherat
Follow us on instagram : / thesketcherat
Follow us on twitter : @thesketcherat
Follow us on Linkedin : / the-sketcher-0131631b3
Follow us on Tumblr : / thesketcherat
Follow us on Pinterest : / pins
Follow us on Flickr : www.flickr.com/people/1930373...
SEO:
excel to whatsapp,send message from excel to whatsapp with images,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,whatsapp to excel,excel send whatsapp message,excel to whatsapp bulk message,automatically send whatsapp message from excel,whatsapp from excel,bulk whatsapp from excel,whatsapp bulk sender excel,send whatsapp message excel,spreadsheet to whatsapp,Excel to Whataspp BULK messages with Photos |एक्सेल से व्हाट्सएप्प पर फोटो वाले अनलिमिटेड मेसेज भेजे