How to send Whatsapp Bulk Message with image using Excel.

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..
Excel to Whatsapp bulk long message

Kindly do your little contribution to us .. it will motivate us to do more awesome videos for you.

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
Thankyou so much ! Happy learning !Easy Learning!

[Janavikasekendra]

i tried lots of video tutorial, this is the only one which i got working

[chandraprabhindustries]

I went till the button creation option and after the steps when I press "SEND" nothing is happening.

Please guide.

p.s. not a science student at all so please help in layman terms.

[srinivasakm]

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

[EugeneYeoMainAcc]

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.

[routhuaravind]

this is the most productive video i have ever seen
thank you so much

[rraveen]

Thanks so much. Is it possible to add PDF file, instead of Image. Please suggest. thanks

[ashum]

Followed the steps mentioned and it worked a like but message+image doesn't send

[realityds]

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

[rohitbchavda]

Thank you mam it's very usefull for business how can contact you

And how many send mgs in 1 time pls reply me

[nevadap]

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?

[YatinWrites]

no
its not working for me, its opening the whatsapp but not copying and sending the messages

[raviprasadnarauliya]

Code actually working. Great.. Many Many thanks.

[PiuPiuAffiliates]

This is gold ! Very good job guys ! Thank you !

[nihal]

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

[abdullahdastgeer]

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?

[nirasarif]

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?

[SashiKiran-jr]

So we can share pdf and image as well using the same formula right?

[kinnerasankarapu]

Thank you so much mam.! It helps me alot.

[shadykhouzam]

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.

[shuaibmohammedc]

Where is the description button to pasted the code