Рет қаралды 5,912
If you want to send messages from ms excel to whatsapp then this video is for you. In this video, i will teach you how you can send messages using automation from excel to whatsapp on unsaved numbers. In our last videos, you have seen how to send messages on saved contacts but now we will learn how to Send message on UNSAVED NUMBERS from Excel to Whatsapp using VBA code.
Notepad file of code : drive.google.com/file/d/1wzS_...
Excel demo file : drive.google.com/file/d/1xkf2...
#techalert #technical #howto
================Direct Code==============================
Option Explicit
Sub wamsg()
Dim PhoneNumb As String, MsgText As String
Dim LastRow As Long
Dim i As Integer
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
AppActivate "WhatsApp"
Application.Wait (Now + TimeValue("00:00:03"))
SendKeys "^n", True
Application.Wait (Now + TimeValue("00:00:03"))
SendKeys PhoneNumb, True
Application.Wait (Now + TimeValue("00:00:03"))
SendKeys "{Tab}", True
Application.Wait (Now + TimeValue("00:00:03"))
SendKeys "{Enter}", True
Application.Wait (Now + TimeValue("00:00:03"))
SendKeys MsgText, True
Application.Wait (Now + TimeValue("00:00:03"))
SendKeys "{Enter}", True
End With
Next i
End Sub
=======================================================
Time Stamp:
0:00 Introduction
1:03 Creating Template
1:40 Writing and Understanding the Coding
7:20 Saving the Code
7:53 Creating the button
8:13 Executing the Code
Our social media accounts :
Facebook : / techalertr
Instagram : / techalertr
Twitter : / techalertr
Pinterest : / techalertr
Reddit : / techalertr
Tumblr : techalertr.tumblr.com
Our Other channels :
1. kzfaq.info...
2. kzfaq.info...
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:
Send message on UNSAVED NUMBERS from Excel to Whatsapp, VBA