How to send WhatsApp Bulk Message with image using Excel IIWhatsApp Bulk Message with Image ExcelVBA
HTML-код
- Опубликовано: 8 сен 2024
- Hi Guys, In this video, you will learn how to send a bulk WhatsApp message with image using Excel.
coding part:
------------------------------------------------------------------------------------------------------------------
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
=====================================================
Click here for more Latest Videos
►Subscribe to our RUclips Channel: / jmrtechsolutions
►Like us on Facebook / jjaganmohan.ravuri
►Follow me on Instagram: / jmrtechsolutions
Like & Subscribe & Comment
Thank You all members for watching!
హాయ్ .. వ్యూయర్స్ ..
ఈ RUclips Channelలో Videos వలన మీకు Use వుంటే, Valuable Content అయితే, మీకు Time & Money Save అయితేనే ఈ ఛానెల్ ను Subscribe చేసుకోగలరు.
ఈ Channel ని Support చేయండి. Subscribe Button Button ని Click చేయండి. Information చూసుకోండి.
Click here Below Link:-
========================
/ jaganmohanravuri
===========================================================
మైక్రోసాప్ట్ ఎక్సల్ లో అంకెలును అక్షరాలుగా ఇలా మార్చవచ్చు II CONVERT NUMBERS TO TEXT IN EXCEL
• Convert numbers to tex...
VBA LINK
=================
rb.gy/0r5mlv
=================
Each Topic-wise Play list Links :-
================================
CONVERT NUMBERS TO TEXT IN EXCEL
👉 • Convert numbers to tex...
ఈ ఐదు జాగ్రత్తలు మీ ల్యాప్ టాప్ భద్రత కోసం పాటించండి II Tips for laptop users
👉 • Your Laptop Safe Using...
మీరు మాట్లాడే తెలుగును చక్కగా వాస్రే బెస్ట్ యాప్ II JMRSOLUTIONS II BEST TELUGU SPEAKING APP
👉 • Voice to text best App...
ఈ అద్భుతమైన సాప్ట్వేర్ ఆప్లికేషన్ సహాయంతో చాలా చక్కగా మీరు కీబోర్డ్ టైపింగ్ నేర్చుకొనవచ్చు
👉 • Keyboard Typing Practi...
చక్కని కొటేషన్లు తయారుచేసుకునే అద్భుతమైన యాప్ II Quotes Creator App II Quotes Creator
👉 • Amazing best Quotes, S...
Check IP Address in Command Prompt Telugu II Window 10/8.1/8/7
👉 • Check IP Address in Co...
============================================
Facebook fan page
-------------------------------
/ jaganmohan.ravuri
RUclips Channel page
------------------------------------
/ jaganmohanravuri
---------------------------------------------------------------------------------------
Hi Friends. Welcome to JMR SOLUTIONS.
Complete Telugu Video Tutorials.
Ms-office, Tally ERP 9, Accounts, Photoshop, Basics of Computers, Html, Tips & Tricks, Weekly QUIZ.
All Courses Shortcuts keys
Abbreviations, What & Who is This?
Download Excel Sheet for Auto Message with Image
Click in the Below Link for sheet
rb.gy/dhklpf
Message send avvatledu bro
❤❤image send avutundi
Only send messages image is not going
Smart phone through also working this code or only laptop computer please reply back sir
@@bskdrycleaner only on desktop and laptop
Sir ma computer Lo miru pin chesina link ni download chesanu aina Ramadan Ledu. Micro unable anie vastundi. Diniki emaina windows 10 ,9 ,8 ela emaina avasaram sir cheppandi dayachesi
whatsapp link ravatam ledu, again photo paste avuthudi
Very good information sir
Thank you sir...
Very good information 👍👍👍keep it up
Thanks a lot
Thank you very much sir
Nice information
Thank you
If it works, thank you so much sir
Thank you Brother it's working and successfully done 🙏
Please tell me sir
How to run asgin
Great 👍
I am facing type error
@@madhulikanayudu okasari elano chepandi sir
Thankyou so much
Thank you too
👌👌👌
Subscript out of range error sir pls solve
Thank you I did download and test the sheet. I need some help with changing the image. Where did you reference in the code?
Hi Need some help. I tried the same process but somehow my picture is going but the message is not going along with picture
very good content
Thank you
@@JMRTECHSOLUTIONS i am unable to send as per ur video... i have used the link u posted also still not able to send
@@sureshamara88 which version of office your using Now
Can you remotely connect to my desktop and troubleshoot? I did do as you described but is not working for me. You can charge me for your time.
License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.
ee issue vastundi anna
Unable to send the whats app. On clicking the send whatsapp button it is copying the same image which was already inserted.
Same problem iam also facing
i'm getting only the Allow and cancel options, Not showing the Always ask tick mark box. could you please help me on the same. while sending every message i have to click allow button manually.
Yes
Yes
Did you got any solution bro...
Sir am getting button image also while sending the msgs and also am not getting always option only allow and cancel is showing
I have a link 🔗 in the description for downloading the file and must use the above 2013 ms office
@@JMRTECHSOLUTIONSwe are using MS Office 2013 but not showing always button its showing only allow or cancel
sir good informacation but i want how to sent audio file
Marco work auvthundhi, kani oka error sir, image send avatam ledu, text tho patu button image la vasthundhi, insert chesina image send avatam ledu sir
Button add chesaka image add cheyyu brother
Sir, నేను యూ ట్యూబ్ లో ఒక వీడియో చూసి బల్క్ messeges చేశాను WhatsApp వారు నా వాట్సాప్ app ni ban చేశారు మరి మీరు చెప్పిన విధంగా చేస్తే అలా ఏమైన జరిగే అవకాశం ఉందా
మీరు పంపించిన వారు మిమ్మల్ని స్పాం లిస్టులో పెట్టకపోతే మీకు ఎటువంటి ఇబ్బంది ఉండదు
Country code ela detect chestundi anna.What if i need to send to the numbers from different countries
hi friend , i am using Excel 2007. Help in making this with excel 2007
Once copy the code and do it Sir
Hi Bro, Text is allocated to first image posted. can you check how to post text to all numbers
Once Download the file from the comment box link 🔗
Sir subscript out of range vastundi can you help me out
Check the sheet name and cells
అంతా బాగానే work అవుతుంది సర్
కానీ 03:32 sce లో కనిపించే Dialouge box లో Always ask before opening this type of address ఆప్షన్ కనిపించటం లేదు సర్.
అందువల్ల ప్రతి నంబర్ కి Allow cliick చేయాల్సి వస్తుంది
bro this code not working properly in updated whatsapp windows application.
showing error** micro soft excel is waiting for another application complete an OLE action
Install Microsoft Office 2013 and above
motham avutundhi
kani send
whatsapp loading
avutundhi kani send avadam ledu broo...ma company ki edhi chala use anukuna but last lo avaledu bro ...plz reply for this
anna, image matrame paste avtundi sheet lo, etuvanti whatsapp msg ravatledu, manam eani numbers istae ani images paste avutundi. pls rectify
Bro, I was providing a link in the comment box
Once download and check the file
Your MICROSOFT OFFICE 10 OR ABOVE Version it's working well
Bro only image sent..shared the file from the comment link. How to send text message too along with image
I already posted bro
How to create the Code ?
Hi Sir,
This video very useful for our organisation. In finnally showing pic only and every number asking allow..
Can u guide on this
When a dialogue box is open check the mark of WhatsApp always
Sir i need to your help
i can't send messages
Anna send WhatsApp button ni click cheste invalid procedure call or argument ani vastundi
Try once a file in a comment box to download the link
Unable to send the whats app. On clicking the send whatsapp button it is copying the same image which was already inserted.Nooooo Use
The WhatsApp account number will be banned ? Your comments please
I don't have any information regarding this I was using last 5 months I didn't get any errors from this
Code in break mode vasthundi sir
Sir namaste sir it's not working sir astamanu message ki allow adugutundi sir
Tick ✔️ tiseyandi adagadhu
For how many numbers we can send maximum?
ila chestey sim block avvada...
CAN WE SEND EXAMINATION MARKS TO STUDENTS INDIVIDUALLY ON ONE TIME BY USING THIS METHOD
Yeah possible
Any suggestions
Hi sir, error message popped up, - License information for this component not found. You do not have an appropriate license to use this functionality in the design environment. by the way I use Mac book
Try above pinned link
Hi need script for bulk WhatsApp message with unique attachments
Hi bro nenu text messge cheyali bulk lo yela
Doesnt your whatsapp account get banned if you use scripts as these? Is it okay to send bulk messages like this?
Maybe bro I don't have an idea reg this, in my team working last 6months we don't get any issues ⚠️
Thanking you
నంబర్ బ్యాన్ కాకుండా పంపగలమా
Trying from 4 days but didn't worked
Sunscript out of range ostundhi
hi..! how many people i can send by this method in one click?
Up to 1000 above
y bro you r showing very speed how to understad content
అన్నా ఎలా asghin చేయాలి కొంచెం చెప్పరా🙏
Ardham kaleydhu bro mee Question
Anna last lo uke allow ani అడుగుతుంది అన్న
Untick always ask before opening this type of address
Sir Kocham slow ga cheppandi please Sir
Mobile lo radha anna e facility
No Brother
If I send 15000 messages daily, are there any charges or can I do it for free? Is it possible to send a message to 15000 numbers?
release kapu corporation white paper
Sir code copy avadam ledhu
Im getting error like Cannot run Macro not available pls guide
Which version of Office you're using?
Meru speed ga chepthunnaru em artham kavatledhu
Sir
Internet explorer lo whatsup open kavatledu
Same problem if you got any solution pls share
system error
Sir! ఒక ఫోన్ నంబరుకి మాత్రమే msg వెళ్తుంది
Check once comment Section here I give one sheet link pls download that and try it once
Hello brother I am using Microsoft 16 but unable to send the whatsapp messages could you pls help me out.
Plz send code to mi
Not working
Out of memory Ani vastumdi
Download the above pinned excel file and do it bro
Sir code copy avatledhu please help me
I have given a link in the description please download and check it once, Thank You for watching us. Please Subscribe to my channel
code yekkada undi sir..im fail to found it..
Check in description
Code not working please share note pad format @@JMRTECHSOLUTIONS
Brother coding plz
View in the Description Bro
Send me the code
Subscript out of range ani vastundi
Check the sheet name once sir and cells also
Every number ask notification
Uncheck the Message Box
Wats app na number block chesindhi Ela chesthe
Ala eam leydhu nenu 4 months nundi use cheystunanu no issue
Enni rojulu block chesindi? ippudu unblock ayyinda?
Hi bro..
It’s popping up with error :
Object doesn’t support this property or method
Which Version of office are your Using
Code plz
Check the Description Bro
Hi sir me number ivagalara
Sir will you give your number sir
URL highlight avvatledu.please help me
Check once your code or download what I have given the link in the comment box