Excel to Whatsapp Group | How to send messages from excel to whatsapp groups | VBA code
HTML-код
- Опубликовано: 11 сен 2024
- 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
very informative and useful for every business/social worker. thank you for your such contribution.
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.
❤❤
Bahuti achha laga
Thank you 😊
Please share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
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
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.
@@techalertr ofcourse sir. Already subscribed and shared 🙏
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
Thank you so much sir
Most welcome
Please share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
Fantastic 😮
Thanks 🤗
very nice
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.
गुरुर्ब्रह्मा गुरुर्विष्णु र्गुरुर्देवो महेश्वरः
गुरु साक्षात परब्रह्मा तस्मै श्रीगुरवे नमः🙏🙏
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.
fabulous
Thanks
awesome
Thanks
thnkuuuuuuuuuuuuuu
Thanks 🤗
awesomeeeeee
Thanks
fabulousssss
Thanks 🤗
Good
Thanks
Please share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
nice
Thanks
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?
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
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
Hello, can you tell me how to use this on mac.
For mac, you can use this video ruclips.net/video/COg2MFQjUbA/видео.html
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.
cool
Thanks
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
Please go through this video once : ruclips.net/video/COg2MFQjUbA/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
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?
Please go through this video once : ruclips.net/video/dN7_9AmHbdI/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
Hi sir please help me i have some doubts how to give text range
Please go through this video once : ruclips.net/video/COg2MFQjUbA/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
besttttttttt
Thanks 🤗
bonjour
merci de m enovyer fichier macro stp comme exemplaire
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.
please send me download link please description we find another file😢
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.
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
Please go through this video once : ruclips.net/video/YmahFrCu5-Q/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
this is working for the numbers which is already in the chat history....How to send messages on fresh numbers?
Yes
Please go through this video once : ruclips.net/video/YmahFrCu5-Q/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
Please go through this video once : ruclips.net/video/YmahFrCu5-Q/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
sir number search no result ke bad stop hona cahiye
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.
All whatsapp connect kaise export kare, all chats all groups contacts etc
Ek sath 1k logo ko kaise send kre
Isi coding se ho jayega bs time gap atleast 5 to 10seconds ka rkhiye.
Please go through this video once : ruclips.net/video/dN7_9AmHbdI/видео.html
Plz share the video on your social media & with your friends to help us.
Hope you subscribed our channel to support us.
There is no developer option in my excel
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.
Hope you liked the video and subscribed our channel to support us.
@@techalertr Got it, Thanks :)
dans description on trouve exemplaire de facutre
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.
awesome
Thanks
cool
Thanks 🤗
awesome
Thanks