Скачать с ютуб How to Send WhatsApp Messages with Image from Excel | Microsoft Excel Malayalam Tutorial в хорошем качестве

How to Send WhatsApp Messages with Image from Excel | Microsoft Excel Malayalam Tutorial

How to Send WhatsApp Messages with Image from Excel |Microsoft Excel Malayalam Tutorial This Video will show you how you can send WhatsApp Messages from Excel using VBA . Using This method you can whatsapp anyone including unsaved contacts. VBA code 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("mess").Cells(i, 2).Value strmessage = Sheets("mess").Cells(i, 3).Value ActiveSheet.Shapes(1).Copy strPostData = "whatsapp://send?phone=" & strPhoneNumber & "&text=" & strmessage Set IE = CreateObject("InternetExplorer.Application") IE.navigate strPostData Call SendKeys("%A") Application.Wait (Now + TimeValue("00:00:03")) Call SendKeys("^v") Application.Wait (Now + TimeValue("00:00:03")) Call SendKeys("{Enter}", True) Call SendKeys("%A") Next i End Sub https://drive.google.com/file/d/1t6-N... 00:00 Introduction 00:10 Intro 00:54 Creating Message 02:40 Inserting Image 03:29 Inserting Developer Tab 06:27 Saving 07:03 InsertingButton 08:13 Installing whatsapp 08:46 Sending message #ExcelTutor #AVTechandTravel #ExcelToWhatsapp Splitting Data From Mainsheet into Multiple sheets in Excel    • Splitting Data From Mainsheet into Mu...   Automated Attendance Sheet in Excel for 2023    • Automated Attendance Sheet in Excel f...   6Amazing Copy Paste Tricks in Excel | Paste Special in Excel    • 6Amazing Copy Paste Tricks in Excel |...   RandBetween Function | Excel Function to create Worksheet in seconds    • RandBetween Function | Excel Function...   10 Amazing Excel Tricks /Top 10 Excel Tricks    • 10 Amazing Excel Tricks /Top 10 Excel...   How to Type Malayalam in Windows/Manglish    • How to Type Malayalam in Windows/Mang...   Top 8 Pivot Table Tricks    • Top 8 Pivot Table Tricks /Microsoft E...   Top 5 Excel Secrets    • Top 5 Excel Secrets /Microsoft Excel ...   Top Excel Printing Tips & Tricks    • Top Excel Printing Tips & Tricks -Mic...   Excel Tutorials playlist Link    • Microsoft Excel 2019 Basic to Advance...   Microsoft Word 2019 Basic to Advanced in Malayalam    • Microsoft Word 2019 Basic to Advanced...   Microsoft Power Point Basic to Advanced.    • Microsoft Power Point Basic to Advanced.   Outlook 2019 Basic to Advanced    • Outlook 2019 Basic to Advanced   google forms    • google forms   Macros in Excel    • google forms   00:00 Introduction 00:10 Intro 00:54 Creating Message 02:40 Inserting Image 03:29 Inserting Developer Tab 06:27 Saving 07:03 Inserting Button 08:13 Installing whatsapp 08:46 Sending message