Skip to main content

HOW TO SEND BULK WHATSAPP MESSAGE.

 HOW TO SEND BULK WHATSAPP MESSAGE.

In this post i have mentioned the coding for how to send bulk whatsapp message.


Source Code:

Sub WebWhatsAppBot()

'###
'WhatsApp BOT to send bulk message by using VBA Selenium
'###


'Activate Selenium Type Library: Tool > References

Dim bot As New WebDriver
Dim ks As New Keys

'Init New Chrome instance & navigate to WebWhatsApp
bot.Start "chrome", "https://web.whatsapp.com/"
bot.Get "/"

'Ask user to scan the QR code. Once logged it, continue with the macro
MsgBox "Please scan the QR code. After you are logged in, please confirm this message box by clicking 'ok'"

'Get the number of last row in column A
lastrow = Cells(Rows.Count, 1).End(xlUp).Row


'Go to each link, paste text into WebWhatsApp and press enter to send the message
For i = 2 To lastrow
    'Get search text (phone number / or name) from worksheet
    searchtext = ActiveSheet.Range("A" & i).Value
    
    'Get message from worksheet
    textmessage = ActiveSheet.Range("B" & i).Value
    
    'click in searchbox
    bot.FindElementByXPath("//*[@id='side']/div[1]/div/label/div/div[2]").Click
    
    'Wait 500 ms
    bot.Wait (500)
    
    'Insert searchtext (phone number / or name)
    bot.SendKeys (searchtext)
        
    'Wait 1500 ms
    bot.Wait (1500)

    'Press Enter to send message
    bot.SendKeys (ks.Enter)
    
    'Wait 500 ms
    bot.Wait (500)
    
    'Load message into Webwhatsapp
    bot.SendKeys (textmessage)
    
    'Wait 500 ms
    bot.Wait (500)
    
    'Press Enter to send message
    bot.SendKeys (ks.Enter)

Next i

'Get notification once done
MsgBox "Done :)"

End Sub


Labels:

Comments

Post a Comment

Popular posts from this blog

DONT BUY ALEXA!!!... CREATE YOUR OWN USING PYTHON|PROJECT|PYCHARM|

 Any Alexa Lovers???... Then this project is for you, create your own alexa by using Python.. by using 3 simple packages we can create own voice assistant, Packages are... 1. pip speech recognition 2. pip text to speech recognition 3. pip PyAudio IMPORTANT: IN SOME SYSTEMS PYAUDUIO, INSTALLATION PROBLEM OCCURS, IN THAT CASE, CHECK YOUR PYTHON VERSION, USE PYTHON 3.6 OR ABOVE. You can search the things, playmusic, and you can ask the funny question to alexa using below code.. import speech_recognition as sr import pyttsx3 import pywhatkit import datetime import wikipedia import pyjokes listener = sr.Recognizer() engine = pyttsx3.init() voices = engine.getProperty('voices') engine.setProperty('voice', voices[1].id) def talk(text):     engine.say(text)     engine.runAndWait() def take_command():     try:         with sr.Microphone() as source:           ...
Post a Comment
Read more

Create Your Own Browser Using Python | Python Project | PyQt5

This post is about Create Your Own Browser Using Python | Python Project | PyQt5, how to create a basic browser, by using Python, it so simple and easy to create, sometime browser which you're using may get slow down, that time you can use this browser. You may use this as mini-project for UG Programmes.   For Video Tutorial     Subscribe the Blog For More Updates: ______________ SOURCE CODE ______________ import sys from PyQt5.QtCore import * from PyQt5.QtWidgets import * from PyQt5.QtWebEngineWidgets import * class MainWindow(QMainWindow):     def __init__(self):         super(MainWindow, self).__init__()         self.browser = QWebEngineView()         self.browser.setUrl(QUrl('http://google.com'))         self.setCentralWidget(self.browser)         self.showMaximized()   ...
Post a Comment
Read more

How To Download Money Heist Sticker

 Are You Money Heist Fan?? Do you want Money Heist Sticker??.. Then Follow the instructions below to get your Sticker. No Apps Required. 1. Open Whatsapp 2. Open Your Whatsapp Chat, Click On Emoji Icon. 3. Click On Sticker Option. 4. Click on Plus Icon. To add a new Sticker. 5. Now Add Your Money Hesit Sticker. 6. Now Click And Download.....!!!!
Post a Comment
Read more