Sending whatsapp messages using Excel | Excel tips Malayalam |Whatsapp message |
Sending whatsapp messages using Excel
#excel
#whatsapp
#digitalmarketing
#broadcasting
#exceltips
#forbeginners
#microsoftexcel
#message
#excellearning
-Contents : How to send bulk(Broadcast) messages in whatsapp using excel.
-How to navigate in excel
- Digital marketing tool
-Fast whatsapp messaging
Code for messaging 👇
Sub WhatsAppMsgImage()
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("Sheet1").Cells(i, 1).Value
strMessage = Sheets("Sheet1").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)
Next i
End Sub
Пікірлер: 39
great!!!
Thank you for the video guide. Find how you can fix the error " Phone numbers are not on whatsapp." If the error figured out, the work will be well set.
@lightsoflife1921
Жыл бұрын
It is an alert or warning that the numbers do not having whatsapp
@denisboscato8779
Жыл бұрын
@@lightsoflife1921 "Phone numbers are not on whatsapp" I need to know when this windows will be out, for make a IF Condition. Do you have a vba excel code to do it ? Thanks in advance.
👍
Please send me the new code. The code is not working properly
wanted vba code to escape number which is not on whatsapp messenger.stop process on wrong number
Popup coming for every number ??
Where is the code
Hlo please sent code
Allow Popup coming for every number. what is the way around?
@dionfatra6521
Жыл бұрын
Use auto clik mouse PC,click delay 1- 2 minute
Sorry, but i have win 11 without internet explorer. Does it work the same? otherwise how can i do? Thank you.
@lightsoflife1921
Жыл бұрын
No issue it will work
@agostinomaiorano1151
Жыл бұрын
@@lightsoflife1921 Hallo, sorry, almost everything works, messages remain in drafts. How can I do to send them automatically?
Not working syntax error
sir allow option appear after every message send
@lightsoflife1921
Жыл бұрын
We have to install older version of WhatsApp. Dont worry latest codes i will update soon.
how to prevent this ?
Run time error
Do you want to allow this website to open an app on your computer ? so annoying
This Code not working new WhatsApp software
@lightsoflife1921
Жыл бұрын
I will update new code
കോഡ് not വർക്കിംഗ്
Good video but message send aakunnilla
@lightsoflife1921
Жыл бұрын
Pls share me the issue
@ravishmaliakkal
Жыл бұрын
@@lightsoflife1921 ok now thank u
Hallo, sorry, almost everything works, messages remain in drafts. How can I do to send them automatically?
@lightsoflife1921
Жыл бұрын
Pls check whatsapp application.install latest version
@kalikevehiclesdetails1473
11 ай бұрын
I'm also having same issues
Brother, it's shows that run time error the index into the specified collection is out of bounds pls help me out to find the solution
@lightsoflife1921
Жыл бұрын
Pls check the following 1.sheet name should be sheet1. 2. Copy the code from this video correctly and paste in module. 3. Message and Number heading should be like ‘Message’ and ‘Number’ 4.pls check country code correctly. For india use 091 For oman use 968. etc If again showing same issue .pls comment here.
@sridevisenthamarai1230
Жыл бұрын
Cannot run the macro "file path" the micro may not be available in this works book or all macross maybe disabled
@sridevisenthamarai1230
Жыл бұрын
Can't run the macro brother
@lightsoflife1921
Жыл бұрын
Pls open Macros first..for that open Customize quick access toolbar at the top..then more commands..then popular commands..there you can see macros option..remove all the macros in rightside box (Customice quick access toolbar) and add WhatsappMsgImage to right.. then click Ok… Then the macros will work
Error400
@lightsoflife1921
Жыл бұрын
Pls share me your mail id ..i will send u a code