Рет қаралды 71,862
#techalert #technical #howto
In this video, we will see how we can send messages from excel to whatsapp, but the twist is, we will not send only the messages but along with it, we will attach images, audio, video, pdf, etc. Also we will be using whatsapp web version instead of whatsapp desktop as used in the last video.
we need to install some extensions to perform this task.
Chrome driver : chromedriver.chromium.org/dow...
Selenium basic : selenium-basic.software.infor...
Selenium Wrapper : seleniumwrapper.software.info...
Dot net framework 3.5 : www.microsoft.com/en-in/downl...
Code Notepad file: drive.google.com/file/d/14g8p...
Code :
============================================
'Chrome Driver
'Selenium Basic
'Selenium Wrapper
Option Explicit
Dim driver As New WebDriver
Dim keys As New SeleniumWrapper.keys
Sub SendDataUsingExcel()
Dim LastRow As Long
Dim filepath As String, myMessage As String
Dim i As Integer
Dim strPhoneNumber As String
driver.Start "chrome"
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
strPhoneNumber = Sheets("Data").Cells(i, 1).Value
myMessage = Sheets("Data").Cells(i, 2).Value
filepath = Sheets("Data").Cells(i, 3).Value
driver.Get "web.whatsapp.com/send?phone=" & strPhoneNumber & "&text=" & myMessage
driver.Window.Maximize
driver.Wait 60000
driver.FindElementByXPath("//div[@title='Attach']").Click
driver.Wait 20000
driver.FindElementByXPath("//input[@accept='image/*,video/mp4,video/3gpp,video/quicktime']").SendKeys (filepath)
driver.Wait 20000 ' this wait time depends on the size of your file max 64 mb
driver.FindElementByXPath("//span[@data-icon = 'send']").Click
driver.Wait 50000
driver.SendKeys (keys.Enter)
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...
Timestamp:
0:00 Introduction
1:04 Installing extensions
8:15 Installing dot net framework ( If required)
8:45 Coding in MS Excel
11:45 Understanding CODE
16:27 Saving the file
16:48 Design & Link the button
17:12 Send message from excel to whatsapp
20:59 Stop the code in between
21:38 Understanding whatsapp code
SEO:
Send Message from Excel to Whatsapp,Audio, Video, Images, PDF | Whatsapp bulk message,हिंदी में ,
Products :
teespring.com/presentator
my-store-ef3535.creator-sprin...