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

Like & Subscribe & Comment
Thank You all members for watching!

హాయ్ .. వ్యూయర్స్ ..
ఈ YouTube Channelలో Videos వలన మీకు Use వుంటే, Valuable Content అయితే, మీకు Time & Money Save అయితేనే ఈ ఛానెల్ ను Subscribe చేసుకోగలరు.
ఈ Channel ని Support చేయండి. Subscribe Button Button ని Click చేయండి. Information చూసుకోండి.

Click here Below Link:-
========================
===========================================================
మైక్రోసాప్ట్ ఎక్సల్ లో అంకెలును అక్షరాలుగా ఇలా మార్చవచ్చు II CONVERT NUMBERS TO TEXT IN EXCEL
VBA LINK
=================
=================
Each Topic-wise Play list Links :-
================================
CONVERT NUMBERS TO TEXT IN EXCEL
ఈ ఐదు జాగ్రత్తలు మీ ల్యాప్ టాప్ భద్రత కోసం పాటించండి II Tips for laptop users
మీరు మాట్లాడే తెలుగును చక్కగా వాస్రే బెస్ట్ యాప్ II JMRSOLUTIONS II BEST TELUGU SPEAKING APP
ఈ అద్భుతమైన సాప్ట్వేర్ ఆప్లికేషన్ సహాయంతో చాలా చక్కగా మీరు కీబోర్డ్ టైపింగ్ నేర్చుకొనవచ్చు
చక్కని కొటేషన్లు తయారుచేసుకునే అద్భుతమైన యాప్ II Quotes Creator App II Quotes Creator
Check IP Address in Command Prompt Telugu II Window 10/8.1/8/7
============================================
Facebook fan page
-------------------------------

Youtube Channel page
------------------------------------
---------------------------------------------------------------------------------------
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

[qualitya]

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

[SATISHKUMAR-ugze]

Thank you Brother it's working and successfully done 🙏

[basha]

whatsapp link ravatam ledu, again photo paste avuthudi

[qualitya]

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.

[mallikarjunayou]

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

[PropertySales]

For how many numbers we can send maximum?

[srcollegeshiramandalam]

sir good informacation but i want how to sent audio file

[gethomerealty]

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

[typicalatypical]

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

[MrVenkataSandeepRao]

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

[nagarajuboni]

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

[typicalatypical]

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

[karthikeyabuddhiraju]

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

[pavanreddynalla]

Subscript out of range error sir pls solve

[srinusk]

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.

[ojkwowo]

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

[senaiasacademy]

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

[ramkkopalle]

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

[imransharif]

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