How to send Whatsapp Bulk Message with image using Excel.
Vložit
- čas přidán 10. 06. 2024
- Hi friends,In this video you will learn how to send the bulk whatsapp message with image using Excel.
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
Kindly like,share and subscribe the channel! Share my website and playlist videos to computer science students and professors you know..
Any Queries/suggestion mail us..
mastereducationugcnet@gmail.com
Excel to Whatsapp bulk long message
• Bulk Long Msg from Exc...
Kindly do your little contribution to us .. it will motivate us to do more awesome videos for you.
UPI ID :manjulavimalesh-1@okhdfcbank
Fill the below form to get the Free softcopy of coding and procedure to your mail ..and let me know what type of videos you need
docs.google.com/forms/d/e/1FA...
Thankyou so much ! Happy learning !Easy Learning!
![How to Send Bulk WhatsApp Messages & Pictures From Excel [Coded From Scratch + Free Template]](http://i.ytimg.com/vi/ScUBSfEqcrY/mqdefault.jpg)
![How to Send Bulk WhatsApp Messages & Pictures From Excel [Coded From Scratch + Free Template]](/img/tr.png)
This is gold ! Very good job guys ! Thank you !
this is the most productive video i have ever seen
thank you so much
Thanks
Thank you so much mam.! It helps me alot.
i tried lots of video tutorial, this is the only one which i got working
Thankyou so much
Thanks Akka
Excellent, It fits exactly my needs!!! Good job
Glad to hear that!
Code actually working. Great.. Many Many thanks.
thankyou so much..kindly share and subscribe
Thank you so much
Thank you so much. It helps me alot
THANKS, A LOT. YOU ARE
GENUINE TEACHER.
So nice of you..thanks for your appreciation.
@@mastereducationcomputersci326
This was working fine in whatsapp old version.
Since the introduction of new whatsapp for windows this code is not working. Any solution?
Thank You .. very nice video
Thanks sandeep
very very helpful
Thank you so much..
Thanks so much. Is it possible to add PDF file , instead of Image. Please suggest. thanks
Thank you
Thank you mam it's very usefull for business how can contact you
And how many send mgs in 1 time pls reply me
The problem is the Allow button that we have to click for every message sent. How do I disable it or set it to ask only once? Kindly help
Same bro bro. Are you got the solution?
You guys resolved this? I have the same problem here...
thankyou
Hi, madam. I am not good at VB. I tried to do the same as per the video but i didn't see the code after clicking view code (F7). I didn't see the description box. Please help.
thank you so much,
Welcome 😊 kindly subscribe my channel
Hi thanks for the video the number atopped at 80
if someone has to send more than one images like 2, or 3 to all numbers ,same images, then we should to do
Good day Mdm, Video at 5:07, after opening Whatsapp application, IE prompts for permission to allow Excel to proceed. To fully automate it, is it possible to auto allow to proceed to the sending? Becos if we are sending bulk msg, we do not need to kept pressing "Left Arrow" + "Enter" to allow 1 at a time.
Same problem bro. Are you got a solution?
same problem
Followed the steps mentioned and it worked a like but message+image doesn't send
Hello mam i tried today on this macro but the message is not going in. It's stays in the whatsApp application I have to manually enter the enter key though sendkeys command is present. Any thoughts?
can we send multiple images , for example 10 images
This is perfect sharing!. I appreciate your kindness. If I have a very long message with space, numbering & bold words in it, can you show me how to write in Excel, so that the message appears in WhatsApp following the paragraph & numbering, with words in bold?
Check the long message video
Hello it's good very useful for messaging,
When I try it's went something wrong it is displaying image "send" the message which is in excel is not going. Please solve the issue
Sir I have company software,but every time that sreenshoot and I am sending whatup....please tell me any solution
can you give code which will work with any default browser installed on a system, not just setting the code to open Internet Explorer.
As Internet Explorer is now retired by its developer since , Microsoft since June 2022
Hi, thanks for sharing this video. I tried, but not working properly
1. Image doesn't get pasted
2. For every number, it asks permission to open whatsApp (using desktop version, didn't work for web whatsApp) and manually need to click on send button.
How these 2 issues can be overcome?
Please guide. Thank you for your support
Same issue
Hi Mam it's going automatically every time I need client button in what app, that option not Coming can please help
How can I disable the "Do you want to allow this website to open a program on your computer?" warning for a specific program
Problem
when i am sending whatsApp a message box pop up comes from internet explorer as do you want following program to open allow or cancel in again and again after allowing as in my computer check box ☑ is not showing so what to doo help me out sir
How did you overcome this problem?
After clicking send button it shows that can't execute code in break mode... Y??
I am sending message without picture it was send but that send button is also going with it
Hello, thank you for the video. I got this message when I clicked SEND button "License information for this component not found. You do not have an appropriate license to use this functionality in the design environment". Can you please advise me how to fix this error?
Same here any feedback so far?
very nice thank you
there is an option to send to a group that i manger?
thanks a lot
@@mastereducationcomputersci326 and about my question? there is an option to send to a group that i manger?
@@HoursMusicChannel no idea
Thank you madam but how to send pdf file aslo plz tell me
How to add multiple images? Like i want to send 3 images to each contact
Thank you very much ❤️❤️❤️❤️
Is there a way to Facebook please?🙏🙏🙏
thanks ..kindly share and subscribe my channel.
no
its not working for me,its opening the whatsapp but not copying and sending the messages
Hello Madam, I tried while am clicking the send the button and getting image pasted in the Excel, what app link is not opening
Thank you, image is not sending I followed all your instructions, please help
I cannot get what she meant by description box? Please advise me. at the minute 2.36
how to attach a pdf file created using vba excel and send via attachment on whatsapp
checked with the steps not working i am using default browser google chorme , keep paste the image same on excel sheet itself
But each time it is asking for allow button madam.. How can i rectify it?
Wen I click SEND button,, it wait for about 10-15 secs and make Copy of SEND Button near by in the same page .. Can any one help me
I am getting overflow error what should I do ??
क्या यह मेथड एंड्रॉयड फोन में भी वर्क करेगा?
यानी की मेसेज फोन में भी मिलेगा?
और मल्टीपल फोन नंबर में काम करेगा?
I have tried this but the message was ready as a draft only, the sending has to be done manually. Please solve this
Your video title is How to send Whatsapp Bulk Message but you did not show how to send more than 1 message at once. What if the number is not on my phone, will this program still work?
can this code change the app to google chrome?
How we will send a PDF using this code please make a new video .
Thanks
In ie it is working . For chrome how to create object
While sending messages we are not able to do any other work on that system ,its front end application, can we ober come this barrier, to work as back end application.
No..
I get this message every time I try to send
License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.
Same here any feedback so far?
i am trying lots of time but when i click on send it copy the double the image.nothing else
Where is the description button to pasted the code
How to automate to do bulk automated sending?
thanks allot , but can we add pdf file or video in the message ? and how , thanks
Check the long message video
Everything worked but when I press send button it is not connecting to WhatsApp
Please help
hello sir
i am geeting error on this line
Next i
this is error
sub or function not defined
this macro not working , it come back to sheet again with copy of image
Wont your number get banned if you do this way?
Getting an error which says License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.
hi the code is working but many numbers are skipped saying "invalid url" how to fix that as these all numbers have a valid whatsapp activation, also is there any way we can add a personlised name of the person we are sending the message to.
no idea so far..will let u know..kindly share and subscribe the channel..
Invalid url means thats not a whatsapp number, no whats app for that number
I follow your step already but the sub whatsapp syntax errors
This app can't be activated by the built in administrator ..
In my PC it is not working so pls help to solve this problem
can this work without Internet explorer?
the images are being pasted back in the excel worksheet itself, whatsapp web is not opening through the sheet as required
M facing the same issue. Please assist
Please help showing error again & again ( Run time error 9, Subscript out of range )
change the excel sheet name correctly. watch the video slowly and try slowly..
Madam, the messages are being sent very slowly and send button is also going with messages , pls help to increase the speed and remove the send button going to the contacts with message
If the send message button goes with the message, delete the button and add it again after adding the image
the sequence should be - add the photo, then add the button
I tried that and it worked for me
Video is good. But live caption is distrubing to watch the video
Can i send 2 images or 1 pdf
I'm getting an error msg "Object required" how to solve it
How many messages we can send per day using this code
for me its not going to whats app but image is getting pages . may be this is because of internet edge as internet explorer is not available now
use google chrome mam
Why it shows forward message while sending
Aafter enter the Whatsapp Allow button, Everty time getting an message as "Do you want to allow this website to open an app on your computer?" can you please fix it permentatly. It is very helpful to me.
Kindly respond me
kindly watch the video again and do it slowly from the first without changing any sequence..patience and preseverance is important in this process..for me also it takes some time to workout..so dont worry..do again and again slowly
@@mastereducationcomputersci326 No Solution at all
Hi....this is not working in the updated versions of watsapp....can u pls give a solution to it...wether new codes are to be inserted?
same problem have you find any solution
I tried ..but the error is showing on the coding line of InternetExplorer.Application . Please guide
mail me your error mastereducationugcnet@gmail.com
It goes till the whatsapp chat, from there it is not sending automatically, i have to click on enter button to send individually. why?
Yes ,we have to click every time so that WhatsApp will think it is done by manual..if it automate then WhatsApp no will be banned..
Can u do a coding for sending WA message with different PDF files to different numbers.
Hi, you got answer? I want to know it too hehe
@@FarahFarhanirr Heard nothing till now.This is a problem we Indians that we avoid responding.There are very few who do respond instantly.
Hi Mam, I am getting 2 copies of the picture after clicking the send button. Please help.
same
same problem how to fix
Don't click the send button.. See the video slowly and do it slowly.. Patience important in this process..
I have tried but which is not connected to whats app
All those will work only in the old version of whatsapp
not working can you help the image is getting copies again
Unspecified error arha ha kindly btaee kaise resolve ho ga
asking allow permission eachtime with this code
How can I secure my num from getting banned
how can i get the code please
i tried with 3 number. i get 3 copied images of what i have given. what to do?
do slowly each step as it mentioned in the video..its work nicely
hi, how to put delay on every sent message to avoid banned WhatsApp account. tq
it is in the coding itself ..we no need to set sir..
@@manjuvimal8114 it works can u share how to sent selected file, image, video using this ?
Can we get the code for using Chrome instead of internet explorer?
it is working in chrome only.
mam are you available now?
how did you ger the code
Couldn't able to write & operator in cell 2
When ever I try to write & in cell it stop or break the comment afterward.
check the long message video.
How can I send msg in group?