Excel to Whatsapp Group | How to send messages from excel to whatsapp groups | VBA code

If you want to send messages in whatsapp groups from MS Excel to automatically, especially for promotion, then you can go through this video. In this video, i will teach you how you can send multiple messages to multiple whatsapp groups from excel including messages, audio, video, images, documents, pdf etc. We will be using simple VBA code to automate the task performed in sequence.
I will be using shortcut commands to create a VBA code and then will explain the complete code in just 5min.so that you can change the code according to your needs.
#techalert #technical #howto
Notepad file of coding : drive.google.c...
Excel template : drive.google.c...
Download desktop whatsapp : www.whatsapp.c...
========================
Option Explicit
Sub wamsg()
Dim PhoneNumb As String, PicPath As String
Dim MsgText As String
Dim LastRow As Long
Dim i As Integer
Dim condition As String
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
With Sheet1
PhoneNumb = .Cells(i, 1).Value
MsgText = .Cells(i, 2).Value
condition = .Cells(i, 3).Value
PicPath = .Cells(i, 4).Value
AppActivate "WhatsApp"
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys "^f", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys PhoneNumb, True
Application.Wait (Now + TimeValue("00:00:02"))
SendKeys "{Tab}", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys MsgText, True
Application.Wait (Now + TimeValue("00:00:10"))
'===========================
'shift tab, enter, enter, path, enter
SendKeys "+{TAB}", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:01"))

' for images and videos
If condition = "image/video" Then
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys PicPath, True
'increase the time in the below line according to the size of file and speed of internet.
Application.Wait (Now + TimeValue("00:00:02"))
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:05"))
'for any type of documents (pdf,word,excel etc.)
ElseIf condition = "pdf" Then
SendKeys "{Down}", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys PicPath, True
Application.Wait (Now + TimeValue("00:00:02"))
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:05"))
End If
'===========================
SendKeys "{Enter}", True
End With
Next i
End Sub
========================
Our social media accounts :
Facebook : / techalertr
Instagram : / techalertr
Twitter : / techalertr
Pinterest : / techalertr
Reddit : / techalertr
Tumblr : techalertr.tumblr.com
Our Other channels :
1. www.youtube.co...
2. www.youtube.co...
Join this channel to get access to perks:
/ @techalertr
==================================================================
Disclaimer : This video is only for educational Purpose. The information provided in this video is for general informational purposes only and should not be considered as professional advice. We make no representations or warranties of any kind regarding the accuracy, completeness, reliability, suitability, or availability of the information presented. Any reliance you place on the information in this video is strictly at your own risk. We are not liable for any loss or damage incurred from the use of this video. Additionally, the inclusion of any links or references does not imply endorsement or responsibility for the content on external websites. Please consult with a qualified professional for personalized advice.
==================================================================
SEO:
Excel to Whatsapp messages, Image, Audio, Video , PDF, Documents all in one VBA Code 🔥🔥🔥,update,whatsapp bulk message sender,how to send bulk whatsapp messages,how to send bulk whatsapp message from excel,bulk whatsapp message from excel,excel to whatsapp message,excel to whatsapp bulk message

[@parikshitdambhare6647]

I m from Maharashtra Forest department. Excellent and very informative video. I use this technique of sending fire alerts message in group. Thank you sir

[@techalertr]

Happy to help you sir. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@parikshitdambhare6647]

@@techalertr ofcourse sir. Already subscribed and shared 🙏

[@rajeshavadhoot8906]

❤❤ Bahuti achha laga

[@techalertr]

Thank you 😊 Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@bidyutsarder8217]

very informative and useful for every business/social worker. thank you for your such contribution.

[@techalertr]

So nice of you! Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@prameshkudalkar520]

Video accha laga...its work's but ek macro aur banaye jismai start mai sirf Hi ya hello bejenge agar unka reply hi ya hello ata hai toh uspe auto reply jayega apana promotion msg unko ❤❤❤ please make macro on this i am waiting for this video

[@danishkalim8559]

Hello Sir, Sir Ap ke whatsaap bulk sms wali Video Dekh, Sir Very Nice, But Sir ek cheez pouchne thi ap se agar humare pass 100 number hai but us main se 10 number Whatsapp per nahi hai tu jo 10 number hai woh excel main masala kar daite hai, sir is ka koe haal hai?

[@tajulislam1502]

You have showed a process to send bulk message from excel using chrome driver, selenium basic and selenium wrapper. It was probably removed. In that process every time need to scan QR code. Is it possible to activate the Whatsapp web only one time. For every message scan QR code again again is very tiring

[@techalertr]

That video was removed but it has been regained. N sorry I didn't got any solution to that problem. But you can go through our new video. Using that you can send messages without any need to scan again and again

[@shailendraarora]

Fantastic 😮

[@techalertr]

Thanks 🤗

[@paragg7859]

गुरुर्ब्रह्मा गुरुर्विष्णु र्गुरुर्देवो महेश्वरः गुरु साक्षात परब्रह्मा तस्मै श्रीगुरवे नमः🙏🙏

[@techalertr]

Thankyou so much Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@deepakbhanushali1]

Sir agar jo excel mai khali particular group ko hi bhejna hey to kya kare

[@techalertr]

is video me yahi to btaya gaya hai ki ap particular 1 group me kaise msg kr skte hai. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@rapetiharish2843]

Hi sir please help me i have some doubts how to give text range

[@techalertr]

Please go through this video once : kzbin.info/www/bejne/eYDKY4B8hs-ImKM Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@sukhiramdehere3187]

awesome

[@techalertr]

Thanks

[@TheSketcher]

thnkuuuuuuuuuuuuuu

[@techalertr]

Thanks 🤗

[@abdulrazique4691]

Thank you so much sir

[@techalertr]

Most welcome Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@saurabhshirode2028]

Hello, can you tell me how to use this on mac.

[@techalertr]

For mac, you can use this video kzbin.info/www/bejne/eYDKY4B8hs-ImKM but make sure to change the code according to mac example: ctrl+n is used in windows, and cmd+n in mac. so you need to make these changes. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@privatetalk580]

very nice

[@techalertr]

Thankyou so much Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@aratipandey5679]

fabulous

[@techalertr]

Thanks

[@nanakramarora]

fabulousssss

[@techalertr]

Thanks 🤗

[@vocationaltrainercg2396]

nice

[@techalertr]

Thanks

[@pavankumarn8066]

sir i cant open picpath i have done the same still after opening files it goes to search and starts with the phone number pllssss help me out soon

[@techalertr]

Please go through this video once : kzbin.info/www/bejne/eYDKY4B8hs-ImKM Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@durggovtschools5171]

awesomeeeeee

[@techalertr]

Thanks

[@dhanjaysonipare5439]

Good

[@techalertr]

Thanks Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@InformationTechy]

besttttttttt

[@techalertr]

Thanks 🤗

[@ptjawaharlalnehrugovthssne6590]

cool

[@techalertr]

Thanks 🤗

[@HarishBhardwaj-q2z]

this is working for the numbers which is already in the chat history....How to send messages on fresh numbers?

[@gauravbhujbal8852]

Yes

[@techalertr]

Please go through this video once : kzbin.info/www/bejne/j57EmXmoeNpoY7M Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@techalertr]

Please go through this video once : kzbin.info/www/bejne/j57EmXmoeNpoY7M Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@abdallahbennani5045]

bonjour merci de m enovyer fichier macro stp comme exemplaire

[@techalertr]

please share your mail id on our instagram. i will share the excel file. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@farhanmunir5228]

ma nay aap ki 2 sal pahly wali video dekhi or wesa hi kiya likn 1 end masla ye hy k mujhy her message per allow krna perta hy check box nhi aa rha ta k ma osy uncheck kr skun . solution please?

[@techalertr]

Please go through this video once : kzbin.info/www/bejne/mn-akGx3oq2Vmqs Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@abdallahbennani5045]

please send me download link please description we find another file😢

[@techalertr]

please share your mail id on our instagram. i will share the excel file. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@DiwakkarJnawali]

Sir is me mahi ho raha he error 5 aata he debug me dekha to Activate WhatsApp me ja ke stop ho raha he, More thankful if you can help

[@techalertr]

Please go through this video once : kzbin.info/www/bejne/j57EmXmoeNpoY7M Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@hemantds]

All whatsapp connect kaise export kare, all chats all groups contacts etc

[@d.bighneswarpatro8460]

sir number search no result ke bad stop hona cahiye

[@techalertr]

Yes i am working on that code. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@_Vishhh_]

There is no developer option in my excel

[@techalertr]

The Developer tab isn't displayed by default, but you can add it to the ribbon. On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box.

[@techalertr]

Hope you liked the video and subscribed our channel to support us.

[@_Vishhh_]

@@techalertr Got it, Thanks :)

[@rohangandharv8939]

Ek sath 1k logo ko kaise send kre

[@techalertr]

Isi coding se ho jayega bs time gap atleast 5 to 10seconds ka rkhiye. Please go through this video once : kzbin.info/www/bejne/mn-akGx3oq2Vmqs Plz share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@abdallahbennani5045]

dans description on trouve exemplaire de facutre

[@techalertr]

please share your mail id on our instagram. i will share the excel file. Please share the video on your social media & with your friends to help us. Hope you subscribed our channel to support us.

[@jyotiarora-b4u]

awesome

[@techalertr]

Thanks

[@jankeechoudhary9276]

cool

[@techalertr]

Thanks

[@bhagwandasarora7932]

awesome

[@techalertr]

Thanks