Send Message from Excel to Whatsapp | Audio, Video, Images, PDF | Whatsapp bulk message | हिंदी में скачать в хорошем качестве

Send Message from Excel to Whatsapp | Audio, Video, Images, PDF | Whatsapp bulk message | हिंदी में

#techalert #technical #howto In this video, we will see how we can send messages from excel to whatsapp, but the twist is, we will not send only the messages but along with it, we will attach images, audio, video, pdf, etc. Also we will be using whatsapp web version instead of whatsapp desktop as used in the last video. we need to install some extensions to perform this task. Chrome driver : https://chromedriver.chromium.org/dow... Selenium basic : https://selenium-basic.software.infor... Selenium Wrapper : https://seleniumwrapper.software.info... Dot net framework 3.5 : https://www.microsoft.com/en-in/downl... Code Notepad file: https://drive.google.com/file/d/14g8p... Code : ============================================ 'Chrome Driver 'Selenium Basic 'Selenium Wrapper Option Explicit Dim driver As New WebDriver Dim keys As New SeleniumWrapper.keys Sub SendDataUsingExcel() Dim LastRow As Long Dim filepath As String, myMessage As String Dim i As Integer Dim strPhoneNumber As String driver.Start "chrome" LastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To LastRow strPhoneNumber = Sheets("Data").Cells(i, 1).Value myMessage = Sheets("Data").Cells(i, 2).Value filepath = Sheets("Data").Cells(i, 3).Value driver.Get "https://web.whatsapp.com/send?phone=" & strPhoneNumber & "&text=" & myMessage driver.Window.Maximize driver.Wait 60000 driver.FindElementByXPath("//div[@title='Attach']").Click driver.Wait 20000 driver.FindElementByXPath("//input[@accept='image/*,video/mp4,video/3gpp,video/quicktime']").SendKeys (filepath) driver.Wait 20000 ' this wait time depends on the size of your file max 64 mb driver.FindElementByXPath("//span[@data-icon = 'send']").Click driver.Wait 50000 driver.SendKeys (keys.Enter) 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. https://www.youtube.com/c/thesketcher... 2. https://www.youtube.com/c/information... Timestamp: 0:00 Introduction 1:04 Installing extensions 8:15 Installing dot net framework ( If required) 8:45 Coding in MS Excel 11:45 Understanding CODE 16:27 Saving the file 16:48 Design & Link the button 17:12 Send message from excel to whatsapp 20:59 Stop the code in between 21:38 Understanding whatsapp code SEO: Send Message from Excel to Whatsapp,Audio, Video, Images, PDF | Whatsapp bulk message,हिंदी में , Products : https://teespring.com/presentator https://my-store-ef3535.creator-sprin...