How to send WhatsApp Bulk Message with image using Excel IIWhatsApp Bulk Message with Image ExcelVBA
Hi Guys, In this video, you will learn how to send a bulk WhatsApp message with image using Excel. coding part: ------------------------------------------------------------------------------------------------------------------ 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("Data").Cells(i, 1).Value strmessage = Sheets("Data").Cells(i, 2).Value ActiveSheet.Shapes(1).Copy 'IE.navigate "whatsapp://send?phone=phone_number&text=your_message" strPostData = "whatsapp://send?phone=" & strPhoneNumber & "&text=" & strmessage Set IE = CreateObject("InternetExplorer.Application") IE.navigate strPostData Application.Wait (Now + TimeValue("00:00:05")) Call SendKeys("^v") Application.Wait (Now + TimeValue("00:00:05")) Call SendKeys("{Enter}", True) 'Application.Wait Now() + TimeSerial(0, 0, 5) 'SendKeys "~" Next i End Sub ===================================================== Click here for more Latest Videos ►Subscribe to our Youtube Channel: / jmrtechsolutions ►Like us on Facebook / jjaganmohan.ravuri ►Follow me on Instagram: / jmrtechsolutions Like & Subscribe & Comment Thank You all members for watching! హాయ్ .. వ్యూయర్స్ .. ఈ YouTube Channelలో Videos వలన మీకు Use వుంటే, Valuable Content అయితే, మీకు Time & Money Save అయితేనే ఈ ఛానెల్ ను Subscribe చేసుకోగలరు. ఈ Channel ని Support చేయండి. Subscribe Button Button ని Click చేయండి. Information చూసుకోండి. Click here Below Link:- ======================== / jaganmohanravuri =========================================================== మైక్రోసాప్ట్ ఎక్సల్ లో అంకెలును అక్షరాలుగా ఇలా మార్చవచ్చు II CONVERT NUMBERS TO TEXT IN EXCEL • Convert numbers to text in Excel 2020 / Nu... VBA LINK ================= https://rb.gy/0r5mlv ================= Each Topic-wise Play list Links :- ================================ CONVERT NUMBERS TO TEXT IN EXCEL 👉 • Convert numbers to text in Excel 2020 / Nu... ఈ ఐదు జాగ్రత్తలు మీ ల్యాప్ టాప్ భద్రత కోసం పాటించండి II Tips for laptop users 👉 • Your Laptop Safe Using these 5 TIPS II Tip... మీరు మాట్లాడే తెలుగును చక్కగా వాస్రే బెస్ట్ యాప్ II JMRSOLUTIONS II BEST TELUGU SPEAKING APP 👉 • Voice to text best App II Speech notes II ... ఈ అద్భుతమైన సాప్ట్వేర్ ఆప్లికేషన్ సహాయంతో చాలా చక్కగా మీరు కీబోర్డ్ టైపింగ్ నేర్చుకొనవచ్చు 👉 • Keyboard Typing Practice IIBEST SOFTWARE F... చక్కని కొటేషన్లు తయారుచేసుకునే అద్భుతమైన యాప్ II Quotes Creator App II Quotes Creator 👉 • Amazing best Quotes, Slogans Creator APP I... Check IP Address in Command Prompt Telugu II Window 10/8.1/8/7 👉 • Check IP Address in Command Prompt Telugu ... ============================================ Facebook fan page ------------------------------- / jaganmohan.ravuri Youtube Channel page ------------------------------------ / jaganmohanravuri --------------------------------------------------------------------------------------- Hi Friends. Welcome to JMR SOLUTIONS. Complete Telugu Video Tutorials. Ms-office, Tally ERP 9, Accounts, Photoshop, Basics of Computers, Html, Tips & Tricks, Weekly QUIZ. All Courses Shortcuts keys Abbreviations, What & Who is This?
