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

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

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

How to use COUNTIF and COUNTIFS in Microsoft Excel

In this Video You can learn How to use COUNTIF and COUNTIFS in Microsoft Excel  Topics Covered:  a) Count how many times a certain string or number appear in a list  b) Count how many times multiple items appear in a list c) Count how many items are greater than or less than a certain value  d) Count how many items are between certain values  e) Count how many items do not match certain values f) Count how many items begin or end with certain characters  g) Count how many items match certain conditions across multiple columns https://youtu.be/mdURBPoE22U
Post a Comment
Read more