How to send WhatsApp Bulk Message with image using Excel IIWhatsApp Bulk Message with Image ExcelVBA

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 KZbin Channel: / jmrtechsolutions
►Like us on Facebook / jjaganmohan.ravuri
►Follow me on Instagram: / jmrtechsolutions
Like & Subscribe & Comment
Thank You all members for watching!
హాయ్ .. వ్యూయర్స్ ..
ఈ KZbin 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
KZbin 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?

[@JMRTECHSOLUTIONS]

Download Excel Sheet for Auto Message with Image Click in the Below Link for sheet rb.gy/dhklpf

[@sigmaruleno.1710]

Message send avvatledu bro ❤❤image send avutundi

[@bonamravi]

Only send messages image is not going

[@bskdrycleaner]

Smart phone through also working this code or only laptop computer please reply back sir

[@JMRTECHSOLUTIONS]

@@bskdrycleaner only on desktop and laptop

[@bskdrycleaner]

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

[@arangulaproperties]

Very good information sir

[@vimalkumarkadarla7547]

bro this code not working properly in updated whatsapp windows application.

[@quality45a]

Thank you I did download and test the sheet. I need some help with changing the image. Where did you reference in the code?

[@basha5311]

whatsapp link ravatam ledu, again photo paste avuthudi

[@quality45a]

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.

[@saigoldvlogs2672]

Very good information 👍👍👍keep it up

[@JMRTECHSOLUTIONS]

Thanks a lot

[@reddyankitha6685]

Sir subscript out of range vastundi can you help me out

[@JMRTECHSOLUTIONS]

Check the sheet name and cells

[@sivanadhapriya27]

Sir am getting button image also while sending the msgs and also am not getting always option only allow and cancel is showing

[@JMRTECHSOLUTIONS]

I have a link 🔗 in the description for downloading the file and must use the above 2013 ms office

[@anilkethri9447]

​@@JMRTECHSOLUTIONSwe are using MS Office 2013 but not showing always button its showing only allow or cancel

[@Itsmywishrey]

Nice information

[@JMRTECHSOLUTIONS]

Thank you

[@gethomerealty7461]

Hi Need some help. I tried the same process but somehow my picture is going but the message is not going along with picture

[@naaswitharshitha]

anna, image matrame paste avtundi sheet lo, etuvanti whatsapp msg ravatledu, manam eani numbers istae ani images paste avutundi. pls rectify

[@JMRTECHSOLUTIONS]

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

[@typicalatypical7029]

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

[@santhoshvadlamani-dq4lu]

send whatsapp aani button click chesthunte same 2nd image form avuthundhi then i deleted the image then after i clicked on the button then button is appearing second time how to solve this

[@srinusk6812]

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.

[@vijeshsethiya3471]

Yes

[@bonamravi]

Yes

[@anilkethri9447]

Did you got any solution bro...

[@nagarajuboni1945]

Hi Sir, This video very useful for our organisation. In finnally showing pic only and every number asking allow.. Can u guide on this

[@JMRTECHSOLUTIONS]

When a dialogue box is open check the mark of WhatsApp always

[@CherishfoundationOrgindia]

Unable to send the whats app. On clicking the send whatsapp button it is copying the same image which was already inserted.

[@BhanuPrakash-sh8oi]

Same problem iam also facing

[@MrVenkataSandeepRao]

Hi Bro, Text is allocated to first image posted. can you check how to post text to all numbers

[@JMRTECHSOLUTIONS]

Once Download the file from the comment box link 🔗

[@ramavenkat3204]

Thank you very much sir

[@janashakti-]

👌👌👌

[@mallikarjunayou]

Sir, నేను యూ ట్యూబ్ లో ఒక వీడియో చూసి బల్క్ messeges చేశాను WhatsApp వారు నా వాట్సాప్ app ni ban చేశారు మరి మీరు చెప్పిన విధంగా చేస్తే అలా ఏమైన జరిగే అవకాశం ఉందా

[@JMRTECHSOLUTIONS]

మీరు పంపించిన వారు మిమ్మల్ని స్పాం లిస్టులో పెట్టకపోతే మీకు ఎటువంటి ఇబ్బంది ఉండదు

[@imransharif2142]

CAN WE SEND EXAMINATION MARKS TO STUDENTS INDIVIDUALLY ON ONE TIME BY USING THIS METHOD

[@JMRTECHSOLUTIONS]

Yeah possible

[@murallikatam]

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

[@ramkkopalle]

hi friend , i am using Excel 2007. Help in making this with excel 2007

[@JMRTECHSOLUTIONS]

Once copy the code and do it Sir

[@AVLSamskruthiManikonda]

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

[@kanikaramvinay5254]

Button add chesaka image add cheyyu brother

[@sureshamara88]

very good content

[@JMRTECHSOLUTIONS]

Thank you

[@sureshamara88]

@@JMRTECHSOLUTIONS i am unable to send as per ur video... i have used the link u posted also still not able to send

[@JMRTECHSOLUTIONS]

@@sureshamara88 which version of office your using Now

[@SATISHKUMAR-ug8ze]

Thank you Brother it's working and successfully done 🙏

[@madhulikanayudu]

Please tell me sir How to run asgin

[@JMRTECHSOLUTIONS]

Great 👍

[@CHINNODA52223]

I am facing type error

[@harishchotu2659]

​@@madhulikanayudu okasari elano chepandi sir

[@NavaCHAITANYACompetitions]

నంబర్ బ్యాన్ కాకుండా పంపగలమా

[@pavanreddynalla1715]

Subscript out of range error sir pls solve

[@Propertywithkamal]

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

[@JMRTECHSOLUTIONS]

Try above pinned link

[@universalGlobe369]

Anna send WhatsApp button ni click cheste invalid procedure call or argument ani vastundi

[@JMRTECHSOLUTIONS]

Try once a file in a comment box to download the link

[@typicalatypical7029]

Country code ela detect chestundi anna.What if i need to send to the numbers from different countries

[@senaiasacademy]

Sir i need to your help i can't send messages

[@ShyamalaKarra]

Bro only image sent..shared the file from the comment link. How to send text message too along with image

[@JMRTECHSOLUTIONS]

I already posted bro

[@giriprasadoppangi2574]

Sir namaste sir it's not working sir astamanu message ki allow adugutundi sir

[@JMRTECHSOLUTIONS]

Tick ✔️ tiseyandi adagadhu

[@srcollegeshiramandalam760]

sir good informacation but i want how to sent audio file

[@karthikeyabuddhiraju219]

Doesnt your whatsapp account get banned if you use scripts as these? Is it okay to send bulk messages like this?

[@JMRTECHSOLUTIONS]

Maybe bro I don't have an idea reg this, in my team working last 6months we don't get any issues ⚠️ Thanking you

[@rachapudiaswani6238]

Any suggestions

[@CHINNODA52223]

Thank you sir...

[@ravikumar-fv9ro]

The WhatsApp account number will be banned ? Your comments please

[@JMRTECHSOLUTIONS]

I don't have any information regarding this I was using last 5 months I didn't get any errors from this

[@1319PropertySales]

For how many numbers we can send maximum?

[@ShinyWinslet]

How to create the Code ?

[@prem88018]

Hi bro nenu text messge cheyali bulk lo yela

[@siddusrikanth]

showing error** micro soft excel is waiting for another application complete an OLE action

[@JMRTECHSOLUTIONS]

Install Microsoft Office 2013 and above

[@VesrnTechnologies]

Sir! ఒక ఫోన్ నంబరుకి మాత్రమే msg వెళ్తుంది

[@JMRTECHSOLUTIONS]

Check once comment Section here I give one sheet link pls download that and try it once

[@jcb9177]

అంతా బాగానే work అవుతుంది సర్ కానీ 03:32 sce లో కనిపించే Dialouge box లో Always ask before opening this type of address ఆప్షన్ కనిపించటం లేదు సర్. అందువల్ల ప్రతి నంబర్ కి Allow cliick చేయాల్సి వస్తుంది

[@madhulikanayudu]

అన్నా ఎలా asghin చేయాలి కొంచెం చెప్పరా🙏

[@JMRTECHSOLUTIONS]

Ardham kaleydhu bro mee Question

[@kamalrocks6700]

Anna last lo uke allow ani అడుగుతుంది అన్న

[@JMRTECHSOLUTIONS]

Untick always ask before opening this type of address

[@dhanarajdreamer6734]

Thankyou so much

[@JMRTECHSOLUTIONS]

Thank you too

[@Digitalshivaji]

Unable to send the whats app. On clicking the send whatsapp button it is copying the same image which was already inserted.Nooooo Use

[@AshokChetti]

hi..! how many people i can send by this method in one click?

[@JMRTECHSOLUTIONS]

Up to 1000 above

[@harishchotu2659]

Code in break mode vasthundi sir

[@CherishfoundationOrgindia]

Hello brother I am using Microsoft 16 but unable to send the whatsapp messages could you pls help me out.

[@babas1266]

If it works, thank you so much sir

[@gummasanjeevarayudu611]

Bro ela bro

[@gummasanjeevarayudu611]

Naku ravadam ledu bro

[@hidoot8872]

ila chestey sim block avvada...

[@kalyandas3999]

Mobile lo radha anna e facility

[@JMRTECHSOLUTIONS]

No Brother

[@MADSKULLLeoYT]

Sunscript out of range ostundhi

[@bandariashok3962]

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?

[@ravikumar-wp1ip]

Sir Internet explorer lo whatsup open kavatledu

[@ravikumar-wp1ip]

Same problem if you got any solution pls share

[@rachapudiaswani6238]

Hi need script for bulk WhatsApp message with unique attachments

[@jbfreshiousprawnsjb]

y bro you r showing very speed how to understad content

[@cceongole8626]

Im getting error like Cannot run Macro not available pls guide

[@JMRTECHSOLUTIONS]

Which version of Office you're using?

[@venkatakrishna-wc5cd]

Out of memory Ani vastumdi

[@JMRTECHSOLUTIONS]

Download the above pinned excel file and do it bro

[@mallepogurajeev3991]

Sir Kocham slow ga cheppandi please Sir

[@SATISHKUMAR-ug8ze]

Brother coding plz

[@JMRTECHSOLUTIONS]

View in the Description Bro

[@tallaanitha2055]

Sir code copy avatledhu please help me

[@JMRTECHSOLUTIONS]

I have given a link in the description please download and check it once, Thank You for watching us. Please Subscribe to my channel

[@bskdrycleaner]

Sir code copy avadam ledhu

[@malliKsuryaduvvuri]

code yekkada undi sir..im fail to found it..

[@JMRTECHSOLUTIONS]

Check in description

[@kiranpeddapudi5066]

Code not working please share note pad format ​@@JMRTECHSOLUTIONS

[@SrinivasaRaoPandamaneni]

release kapu corporation white paper

[@gangareddysallaSLNPDS2016]

Meru speed ga chepthunnaru em artham kavatledhu

[@Digitalshivaji]

Trying from 4 days but didn't worked

[@kaluvaladheeraj5537]

Hi bro.. It’s popping up with error : Object doesn’t support this property or method

[@JMRTECHSOLUTIONS]

Which Version of office are your Using

[@kveeru3983]

Plz send code to mi

[@commonman1998]

Subscript out of range ani vastundi

[@JMRTECHSOLUTIONS]

Check the sheet name once sir and cells also

[@abdulshaik7571]

system error

[@Lokeshofficial9]

Not working

[@venkateshpittla9039]

Send me the code

[@futurehr3545]

Wats app na number block chesindhi Ela chesthe

[@JMRTECHSOLUTIONS]

Ala eam leydhu nenu 4 months nundi use cheystunanu no issue

[@karthikeyabuddhiraju219]

Enni rojulu block chesindi? ippudu unblock ayyinda?

[@SATISHKUMAR-ug8ze]

Code plz

[@JMRTECHSOLUTIONS]

Check the Description Bro

[@jcb9177]

Every number ask notification

[@JMRTECHSOLUTIONS]

Uncheck the Message Box

[@Vijaymeesala]

Hi sir me number ivagalara

[@Vijaymeesala]

Sir will you give your number sir

[@manidhar.V.S]

URL highlight avvatledu.please help me

[@JMRTECHSOLUTIONS]

Check once your code or download what I have given the link in the comment box