Thank you so much for sharing this insightful video. Thanks a lot. Very good video, thanks for explaining the programming. Greetings from India. Your tutorials are very professional and very useful. Keep up the good work.
Thank you so much! It was really helpful and easy to do. Among all the videos that show how to do this with a paid integration, this was the only easy and free one
@@CodingIsFun How can we send message to unsaved numbers ? This solution is best for saved numbers. Request you to make a video about sending a message to unsaved numbers through vba as well !!!
@@sanketkatariya4322 I have done it in the past, but the video got deleted. Hence, I will not publish any more videos regarding WhatsApp automation. Thanks!
Hi! Thank you so much for the tutorial, please make one when the contacts are not saved, I tried it with the spreadsheet but not sure how to code VBA for it , help please
Hello Sir. Thank you for this amazing class. My question is, why is Selenium Basic Setup Wizard not Installing on my P.C. I see a pop up on Firefox which says "This add-on could not be installed because it appears to be corrupt " Pls guide me, I have tried severally but haven't gotten past this stage of installation. Thank you
*Thank you.* I am glad you enjoyed the video 😃 Could you kindly try to do a 'custom installation' as shown in the screenshot below: 👉prnt.sc/10j6i85 Hope it works for you. Cheers, Sven
Hello Sir, thanks for the tutorial, the code works. One thing I needed to know. The message which I try sending has line breaks, as a result it doesn't copy the whole format from the cell rather it copies some parts and then some parts and then again the remaining. Though the messages are sent to the desired number but I wanted them to go together. It doesn't look nice that way. For example this is the message: Hello Sir, This is a Test. Have a nice day. Thank you. Best Regards, Yasser So the above message will be sent to a desired number, that's not an issue but it won't go as one whole chunk but it will go as 5 pieces as it has got 5 line breaks. I don't want to lose the format of my writing and also it doesn't look good this way. Hope you will take out your valuable time and help me to fix this. Thank you
Hi Yasser, thanks for watching the tutorial. Kindly check out the following site (I have described it there): pythonandvba.com/whatsappsender. You can try to use the pipe symbol: www.screencast.com/t/oRnKSVXXw4
Just an update to below "comment". Starting new thread as it seems right. I have downloaded the latest template, updated the chromedriver following the instructions. Everything works like a charm right away. I have Windows 64, but 32-bit version of chromedriver works ok as mentioned. So easy style of tutorial proves to be based on well coded and functional VBA template.
This is really fun and helpful. Could you also share a similar detailed video with error and bug fixes , if we want to bulk share media files or documents on whatsapp via excel on various numbers, emojis, etc. Please.
*Hi Vineet Sharma. I am glad you liked the video; thanks for watching and for the comment!* In fact, to send media/documents, including error handling, you could use the 'advanced' version of this BOT: [ADVANCED VERSION] Send Images/Document to saved & unsaved contacts, including Error Handling: 👉 bit.ly/2Ojz9lX I plan to create a video that explains how to use the advanced version, including a code walk-through. Cheers, Sven ✌
@@CodingIsFun Hello Sven, Namaskaar!! Thank you for your prompt response. I had gone through your advanced version excel as well. Since, I am not from coding background I was confused, as it apparently looked complex. Thank you for assuring to release a similar detailed video in near future just like basic version. Desperately Look forward!! Many thanks in again buddy!! Keep Shining!
Hi Sven, I m in need of that detailed video for bulk sharing media files excel to whatsapp. Cud u pls do it as early as possible. Thanks a ton in advance.
@@vineetsharma8261 Hi Vineet Sharma. It is still on my to-do list. Recently I was working on other tutorial topics - Sorry 😕 Do you need any urgent support? Is something not working? Please let me know.
@@vineetsharma8261 Sorry for letting you wait. Yesterday I have uploaded the video on how to use the advanced version: ruclips.net/video/lt2xhww_wcE/видео.html Hope you like it 🙏
Hey @Coding Is Fun, I have a question. For Excel WhatsApp BOT you shared, I wanted to add a formula to autopopulate the number and the message to be sent. I realize that every formula I add it adds a ' before the formula. Sorta like '=vlookup(..... Is there anyway to address that?
Thanks for watching the video. You might want to check the format of the column. Perhaps it is set to 'text' at your end?! www.screencast.com/t/bNnxVmIsr9 I hope this helps!
Hi Sven, this is Ash from India. Bangalore Appliances is my friend and Recently he told to watched your videos. its fantastic bro nice videos and explaining. am very happy with your all videos. from now i will never miss your videos. thanks a lot.
Is it possible to include an image to send automatically with the text? I’m not a coder, so if you could show the step-by-step to add image, that would be great!
All are great on my desktop Windows 10 with Excel 2013. However, when I run it on another laptop Windows 11 and Excel 365, the image cannot be sent. Error: 7_NoSuchElementError Element not found for XPath=//div[@aria-label='Attach']
One thing I missed. Lets say I have a 6 line message. And lets say I have a 100 clients list. The way it is now, I have to replicate each number 6 times and create a 600 lines sheet. A lot of manual work. The idea is. One sheet for message and one for clients. Or something more automatic. Anyway, amazing job. Congrats.
Thanks for the suggestions. That is a fantastic idea! But it is sometimes not easy for me to create a one-size-fits-all solution. Currently, I am not planning to add more features.
hello bro am Yash, am watching your videos, all are excellent and fantastic.. I am very happy if you create a bulk Whatsapp sending to unknown numbers. Amazing video! Straight up, accurateness and very understandable. Thank you for that
Hi, first of all big thanks for sharing your knowledge. I tried your file and it works only for text. When I paste the path of the selected image or document, the file send me Error:7 No Such Element Error. What I`m doing wrong? The get the file`s path I click the button "Copy Path" with the file selected and it give me the correct URL to the file. I add also the " at the beginning and at the end of the path but it doesn't work. Any help will be much apreciated. Best.
I assume your (Web)WhatsApp language is not set to English? In that case, you first want to set your WhatsApp environment to English. Follow the steps below: faq.whatsapp.com/general/account-and-profile/how-to-change-whatsapps-language/?lang=en Once done, kindly try it again. Thanks!
Hi, the video is super awesome and the sheet works like a dream. Is there a way that i can use your sheet to send and after sending messages whatsapp to remain open and reply to messages received based on key words?
Hi there, nice tutorial. Have couple of doubts. 1. How to find out the correct chrome driver version (My version is Version 122.0.6261.70 (Official Build) (64-bit))? 2. My requirement is first to filter whether the number is using whatsapp or not and send a message? Let me know the steps Thanks in advance
Thank you for watching! In response to your questions: 1. You can find your Chrome driver here: googlechromelabs.github.io/chrome-for-testing/. 2. It is not possible to check beforehand if a number is a saved or unsaved contact. If you're using the basic version and attempt to send a message to an unsaved contact, an error will be indicated in the status column. However, if you upgrade to the PRO version, you can send messages to unsaved contacts as well. Learn more about it here: pythonandvba.com/whatsapp-bot/. I hope this helps! Happy Sending! Cheers, Sven ✌️
Hi, another thing I found is that, the excel system only can be text to the person we have contacted before, like say we have a conversation with the people before only then it will only able to send the message, otherwise the it when to search and couldn't find the people (due to never talk before) then it will lead to error.
Yes, that is correct. You can only send messages to saved contact of yours. In fact, sending bulk messages to unsaved numbers is again the WhatsApp Terms Of Service.
Hi, I've been using your code for months, this morning when I tried to log in it suddenly didn't work for me. I get a notification that the macros don't work, I went into the settings and of course I gave permission but it still doesn't work. Do you have a solution?
Thanks for watching the video & your question. As also mentioned in the description, I am sharing this knowledge for educational purposes. With VBA Selenium & Excel, you could also automate other tasks/actions like filling out online forms, scrapping websites, etc. Regarding the use cases of the Excel WhatsApp Sender, this obviously depends on the user. You could, for instance, send New Year greetings to friends, inform colleagues that a report has been published, etc.
@@CodingIsFun ok can I use my 'whatsapp business account' to send message? I am a social worker. I want to send message in bulk... I have 500+ contacts
@@didacticslearningassistanc6256 If I interpret the WhatsApp Terms of Service correctly, this is not allowed: faq.whatsapp.com/general/security-and-privacy/unauthorized-use-of-automated-or-bulk-messaging-on-whatsapp/?lang=en "Over time we've seen how people value messaging with businesses and so we've built two tools-the WhatsApp Business app and the WhatsApp Business API-to help companies manage customer interactions. Our products are not intended for bulk or automated messaging, both of which have always been a violation of our Terms of Service."
I used your whatsapp bulk message sender. That was mind blowing........ Now I have to extract contacts from whatsapp groups manually...... Can you give a code to extract contacts from whatsapp groups automatically..... I shall be very grateful to you.....
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
This is a great video, thank you. I wondered if there is another video that could be added to this. In the video you mentioned the following: Selenium can extract data? Would it be possible to programme the following: The spreadsheet containing a list of numbers: The code to complete the following task: Read the number from the spreadsheet > Look the number up in Whatsapp Web Extract the conversation for the corresponding number and paste the contents back into the spreadsheet against the corresponding number. Loop the code, until every line has been processed.
@@CodingIsFun I will have a look to see if I can modify the code. If I cannot do it, is this something you would consider looking at? It would be such a useful to manage large amounts of data.
@@CodingIsFun ok no problem, I'll give it my best shot on my own. I'll keep an eye out on your videos, just in case.😃. Thanks again for taking the time to reply anyway.
Hi sir! Can i send different message to each number? do i have to save contact of the receiver first? btw, great video! easy to understood. This can help my business. Thx!
Thanks for watching the video. You can only send messages to saved contacts, as mentioned in the description box and the pinned comment. You just input one message per row.
I have decided not to include the code in this description, as the template I created has a considerable amount of code, including error handling that is separated into multiple modules. However, you are welcome to download the template and copy the VBA code from there, as it is not password protected.
Hi, thanks for the video. I follow it through step by step and manage to get it work. Thank You very much. One more, how can I include picture to be send out ? Thanks in advance.
Thanks for watching the video. You would need to tweak the code further. E.g. by clicking the 'attachment' buttons using Selenium: www.screencast.com/t/r0WhQv7J7vie If you are stuck, feel free to shoot me an email: contact@pythonandvba.com
Thanks for the video and the program. It's perfect, but I had a problem with the picture. I tried it from the desktop, it didn't work. I tried from C root, still didn't work. But normal text messages are gone. I don't have any trouble. Thanks so much for your sharing.
Again thank you. It works perfectly. And thanks for the additional help. One last thing i needed to know. Is there any way of signing in without scanning the qr code everytime?
I used this and it works! Thanks for the video, Sir. Could I ask for one more video on How To Send WhatsApp Images From Excel Using VBA? I need to send images too. Thanks in advance!
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Hi Bárbara, Thanks for watching the video. I assume that your (Web)WhatsApp language is not set to English? In that case, you first want to set your WhatsApp environment to English. Follow the steps below: faq.whatsapp.com/general/account-and-profile/how-to-change-whatsapps-language/?lang=en Once done, kindly try it again. Thanks!
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Yes, that is possible. In the past, I have created a solution for this. Yet, the video got removed from YT as it was against the WA Terms of Service. Hence, I would not recommend sending multiple messages to unsaved contacts.
Hello, thank you very much for the video. Although I am showing the file path correctly, I am getting the error as below. What should I do? Error: File does not exist
Great solution, great video. Thanks a bunch. On the message I am sending a multi paragraph message but I would like to keep it in the same message instance. How can I enter the text in the excel file to avoid creating a new message instance many times? Thanks
I hope you can make videos on how to utilize JS in Excel Online. It's a new feature and I think it will be the future since VBA will phased out. Thanks a lot!
Thanks for your suggestion. I am not really an expert on JS in Excel. Hence, most likely, I will not publish any videos regarding this topic in the near future.
@@abdallahawawdeh1705 The advanced version was not in line with the WA Terms of Service. Therefore I will not further distribute it. Thank you for your understanding!
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Great Tutorial, I have 1 Problem i have met. What happens when i have a mixture of numbers in my contact book. I mean Some of my contacts are on whatsapp, where as others arent. Thank you
Thanks. If you use this version: pythonandvba.com/whatsappsender , the BOT will continue to the next number/row, if the number does not exist in your contact book
Very good video. Thank you for making this. One question: My whatsapp message has 2 paragraphs, and while sending normal Whatsapp message, I do ALT+Enter to create a new paragraph in the same message. While doing this using excel, I am not able to create this kind of message. When I enter, it will go as a different Whatsapp message instead of one long message. Any suggestions on how I can compose one message which is long and has multiple paragraph?
Thank you so much for sharing this insightful video. I implemented the bulk messaging and it works perfectly. However, i have been getting runtime error '11' when i try to run a new campaign of about 200 recipients
*Thank you.* I am glad you enjoyed the video 😃 Do you use the 'Advanced' version (which I recommend)? 👉 bit.ly/2Ojz9lX If so, could you share what exactly the error message says? Thank you.
Hi. I get an error which was basically not opening the crome browser. I use windows on parallels. My default drive was //mac/... . The solution was to move the file to a folder in c: drive of the virtual machine. Did a code walkthrough and I must say this has been a very thoroughly and neatly written piece of code. Very useful. I was not able to send images and documents. I did check for the updates but there were none. Hope this update is done as well. My app language is English so that was not the issue.
I tried to modify it to suit my needs of sending our milk data to customers. I have hardcoded the monthly dates coz I couldn't figure out how to use arrays. Right now the problem i am facing is that after each date, a new message due to use of **& Chr(10) &** is being created and sent to the customers for the next date. I want all dates and respective milk qty to go in just one whatsapp msg
@@engicofarmer4713 *Thank you for watching the video" Have you already tried the 'advanced' version, which you can find here: 👉 bit.ly/2Ojz9lX To send multiline messages you could use the pipe symbol " | ", e.g.: Line 1 | Dates | More Dates | Line 4 Hope it helps 🙏 Cheers, Sven
First of all i would like to thank you about this educational video and thanks for sharing ready to go excel file. I am not familiar about VBA coding. My question or asking from you is how can i personalize bulk messages? Such as "Hello [name of customer] happy new year :)" i tried with formulas but i think VBA checks is there any text or not. When i put formula in cell it promts "please fill out all required fields in Column A,B,C" If you are able to assist me about this, i would be greatful to you :) Thanks al lot!
Which common sickness of people. After commented to you, i found rookie solution :) Maybe someone like me can use it. Rokie Solution: I create new sheet and type some "Hello & TEXT($K2,"general")& happy new year :)" to one column and from "K" column i am taking the names :) I know excel experts can create automation for it but i can't :) Maybe kindly this can be a tip for you to develop this Excel Sheet
@@sertugbaysin Thank you for watching the video. Cool to hear that you found already a workaround. I also went ahead and created the following version for you: 👉 drive.google.com/file/d/1tvzbE4JRFx2RvD3KX917v8035UUBtkc_/view?usp=sharing Hope you like it 🙏
Hi there, I have adjusted the code. If the number is not registered, the BOT will go to the next number & indicate the error including a timestamp in column "D". Please find the adjusted workbook here [Option A]: 👉 bit.ly/3k6YdYw Hope this solution works for you. Cheers, Sven
First I want to thank you for sharing your work, amazing BOT.....hopefully you continue updating this BOT. I already subscribed to your channel, also, I already visited your page. excellent tutorials, thank you so much
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/whatsapp-bot/#FAQ I hope it helps! :)
Yes, you can. Dim ks As New Keys BOT.Keyboard.KeyDown (ks.Control) BOT.SendKeys ("V") BOT.Keyboard.KeyUp (ks.Control) Or you could try: A workaround would be to copy the data and write it using sendkeys. [A1:B12].Copy txt = BOT.getClipBoard() BOT.SendKeys txt
@@CodingIsFun Tried the first one in various permutations and combinations...Its only printing V in the WhatsApp text box 😒😢 The second one doesn't conserve the text format, so does not work for my project. Plz help. Thanks!
@@ForEximTV There is no easy way, like CTRL+V, to copy the cell content *PLUS* formatting and pasting it into the WebWhatsApp Interface. For the formatting, please use: You could also send a **bold text** You could also send a ~ -strikethrough text- ~ You could also send an __italic text__ In general, Emojis are supported within the Chrome Webdriver. Hope it helps.
Thank you very much for this amazing innovation. I have a question, please When I send a message consisting of several lines, it reaches the recipient in the form of a separate message for each line. How can I solve this problem?
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Thanks for this wonderful tutorial. Thank you so much. But even if the contacts were saved in my phone contact list, the first contact received his message and also the remaining numbers with their specific message: The numbers were just as regular messages sent to the first contact in the excel list.
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender Also, in the template, please increase the delay time and try again
Thank you very much for this wonderful piece of program. I am using the one which I downloaded from the description box. In that can you please help me to set chrome user profile such that I don't need to scan the QR code everytime? Thank a ton!
Great video, simple instructions thank you. I have a two part question. I use Microsoft Edge, how will I use this instead of Chrome and how do I maintain access, without having to repeatedly sign/log-in using QR code?
Thanks! Regarding your questions: 1) I had different troubles with the other web drivers. The chrome driver worked best for me. 2) If you download the fully coded out template (pythonandvba.com/whatsappsender), you will find an option to avoid scanning the QR every time you run the BOT. I hope this helps!
Hello, I'm not sure if this will answer your question. For you to not always sign/log in using QR Code. You can put this code bot.AddArgument(Then find the cookies of your Google Chrome) But recently, we are having a problem with the current chromedriver. Thank you
Hi. I can't use Chrome since our IT policy forces me to use Edge (yes, don't ask). I get a "cannot find Chrome binary" error, even when using the link you posted below. Any suggestion? (and I will not use it for bulk spam). I made the following change to the code but it didn't work. ''' Init New Chrome instance & navigate to WebWhatsApp 150 BOT.Start "edge" 'BOT.Start "chrome"
Hi Amazing solution absolutely loved it and the demo. Just a question is there a possibility to make it an interactive message, or like an button response?
Amazing way to broadcast on whatsapp, I would like to heard about the ways we can do this carefully (limit the number of contacts or increase the sending time), because our whatsapp account can be blocked by getting report from the users.
Hey could you plaese please help me how to add another row. For example if i want to send both pictures and a paragraph in the next row same message. Thanks !!
I have a catalogue in my whatsapp business. When someone creates an order from my catalogue shop, a bill will be created with the total price . Can I send this generated bill data on Whatsapp to another platform like excel for analytics
The WhatsApp sending in Excel VBA worked fine for a while and decided to stop working today. This time, I am able to send photos but not text messages. I got the following error message when I send text: Error: 0_SeleniumError element not interactable (Session info: chrome=91.0.4472.124) (Driver info: chromedriver=91.0.4472.19 (1bf021f248676a0b2ab3ee0561d83a59e424c23e-refs/branch-heads/4472@{#288}),platform=Windows NT 10.0.19041 x86_64), 07/09/2021 18:37:56 What could be the problem? Appreciate your help as always!
@@CodingIsFun I changed the XPath and it worked like MAGIC! However, there's one thing that I do not understand. My excel is standalone copy in my laptop and not connected to anywhere. And I did not change anything in the coding and you changed the text input field in your machine. How did the text input field change in your machine affect my copy in my laptop and make it not work anymore? I am very curious here......and yes, let's have coffee! Cheers!
@@UncleLeeAdventures, First of all, thanks for the coffee! I truly appreciate your support. I assume that you are using the 'advanced' version of the WhatsApp Bot? If I understand you correctly, you have changed the Xpath for the textinputfield in the worksheet 'settings', right? In the VBA code, I am retrieving the XPath from the Settings Worksheet. There is no additional adjustment in the VBA code required. I definitely do not have any access to your workbook :)
@@CodingIsFun I do not know which version I have....but it works...so that's most important. I changed the XPath in the Sub WhatsApp_BOT() as below. Replaced line 1 with line 2. Sub WhatsApp_BOT() 'X_PATH_SETTINGS txtinputfield = "//*[@id='main']/footer/div[1]/div[2]/div/div[1]/div/div[2]" -> Line 2 'txtinputfield = wsSettings.Range("txtinputfield").Value -> Line 1
hi, the video was great and helpful, but I'm stuck at the starting point of VBA code at activating selenium type library-the options reference is not showing. Can U help me with this?
Will Whatsapp Ban /block me if I use the VBA macro to send whatsapp to only 200 numbers daily ? I read that whatsapp has serious issues with automated sending of whatsapp. How can I bypass this blocking by Whatsapp ?
Yes, this could happen. To avoid this, you might want to buy access to the WhatsApp API. There are different providers out there. One of them is called 'Twilio'. You will find more information on their website.
Yes, it is possible, but it requires further modification. One easy would be to keep the Excel file open and insert a delay of 60 min between each message.
![Send WhatsApp Messages from Excel! [Tutorial]](http://i.ytimg.com/vi/rR-MQej9fdc/mqdefault.jpg)
*Download the template here:* pythonandvba.com/whatsapp-bot
*Check out the Docs/FAQ here:* pythonandvba.com/whatsapp-faq
how i can do that for groups ?
@@allantechnology It also works for Groups. Instead of the number, just provide the name of the group chat in column A.
@@CodingIsFun bot.Start "chrome", "web.whatsapp.com/"
i have error in this code
@@allantechnology Could please let me know the error message or even better, upload the error message here: prnt.sc/ ?
Thank you.
You rocked !!! Too good !!! Super easy and very well explained. And MAINLY IT WORKS :D ...!!! Kudos..
Thank you! 🎉🎉
How can I export all WhatsApp contacts from my android device? All the apps are paid or buggy. Any script or quick help?
@@VijayInani sorry, I do not have a solution for that
@@CodingIsFun I used a paid app for it.
Your tutorials are very professional and very useful. Keep up the good work.
Thank you so much for your support! 🙏
@@CodingIsFun sir my account bngd.. help me pls
Thank you so much for sharing this insightful video. Thanks a lot. Very good video, thanks for explaining the programming. Greetings from India. Your tutorials are very professional and very useful. Keep up the good work.
Thank you, it means a lot!
Implemented it for VB6. Straight in one single shot, no bugs.... working like magic. Many many thanks
Fantastic! Thanks for watching the video and taking the time to leave a comment.
hey ! can u send me the code and the excel file please ? something dont work for me
plz help me i want this code for vb6
thanks a lot , it works pretty well.... I am Arun from Kerala, and Iam a teacher.
Hi Arun. Thanks for your feedback. Glad it is working fine. Greetings to Kerala! :)
Thank you so much! It was really helpful and easy to do. Among all the videos that show how to do this with a paid integration, this was the only easy and free one
Glad you liked it. Thanks for watching and taking the time to leave a comment!
Hi Nava is it still works?
Thankyou so much for the simplified tutorial. It saved so much of time and manual work. Thanks buddy! 🙌🏻
A pleasure! Glad to hear that the solution is helpful!
@@CodingIsFun How can we send message to unsaved numbers ? This solution is best for saved numbers. Request you to make a video about sending a message to unsaved numbers through vba as well !!!
@@sanketkatariya4322 I have done it in the past, but the video got deleted. Hence, I will not publish any more videos regarding WhatsApp automation. Thanks!
@@CodingIsFun thanks for all your efforts. Really bringing lot of value to the community. Have a nice day sir
@@healurselfcuzin Thanks for your kind words! 😃
Hi! Thank you so much for the tutorial, please make one when the contacts are not saved, I tried it with the spreadsheet but not sure how to code VBA for it , help please
Yes, what happen when the contact is not in the list, i usually use this syntax to send wa blast wa.me/6285960887882?Text=Hello My Friend
i know but its don't let me to write the messageb.
I am impressed with your simple KISS explanation!!! The downloaded Excel works well as of Feb'2023. Thank You.
Glad to hear you liked it! Thank you for commenting and watching. 👍
Just did it and it still works! Great video, thank you
Nice! Glad you like the solution! -Sven ✌️
Amazing video! Straight up, accurateness and very understandable. Thank you for that!
Thank you very much for watching the video & your kind words! 😃
@@CodingIsFun Can you please edit the WhatsApp Advance Version File and share the video.
Hello Sir. Thank you for this amazing class. My question is, why is Selenium Basic Setup Wizard not Installing on my P.C. I see a pop up on Firefox which says "This add-on could not be installed because it appears to be corrupt "
Pls guide me, I have tried severally but haven't gotten past this stage of installation. Thank you
*Thank you.* I am glad you enjoyed the video 😃
Could you kindly try to do a 'custom installation' as shown in the screenshot below:
👉prnt.sc/10j6i85
Hope it works for you.
Cheers,
Sven
Hello Sir, thanks for the tutorial, the code works. One thing I needed to know. The message which I try sending has line breaks, as a result it doesn't copy the whole format from the cell rather it copies some parts and then some parts and then again the remaining. Though the messages are sent to the desired number but I wanted them to go together. It doesn't look nice that way. For example this is the message:
Hello Sir,
This is a Test. Have a nice day.
Thank you.
Best Regards,
Yasser
So the above message will be sent to a desired number, that's not an issue but it won't go as one whole chunk but it will go as 5 pieces as it has got 5 line breaks. I don't want to lose the format of my writing and also it doesn't look good this way. Hope you will take out your valuable time and help me to fix this.
Thank you
Hi Yasser, thanks for watching the tutorial.
Kindly check out the following site (I have described it there): pythonandvba.com/whatsappsender. You can try to use the pipe symbol:
www.screencast.com/t/oRnKSVXXw4
instead of using line breaks use the proper line break format for whatsapp. that is using '|' character instead of or .
@@CodingIsFun does the pipe symbol still work? It just gets printed out on mine
@@CodingIsFun I entered in text but paragraph no getting change plz help
@@rajkumarvishwakarma7744 did you use | ?
Just an update to below "comment". Starting new thread as it seems right.
I have downloaded the latest template, updated the chromedriver following the instructions.
Everything works like a charm right away.
I have Windows 64, but 32-bit version of chromedriver works ok as mentioned.
So easy style of tutorial proves to be based on well coded and functional VBA template.
Fantastic! Happy to hear that everything is working! 👍
This was a very helpful video. I'm a beginner programmer and i can say i had a lot of fun doing this.
Glad you liked the video. Thanks for watching and taking the time to leave a comment :)
This is really fun and helpful. Could you also share a similar detailed video with error and bug fixes , if we want to bulk share media files or documents on whatsapp via excel on various numbers, emojis, etc. Please.
*Hi Vineet Sharma. I am glad you liked the video; thanks for watching and for the comment!*
In fact, to send media/documents, including error handling, you could use the 'advanced' version of this BOT:
[ADVANCED VERSION]
Send Images/Document to saved & unsaved contacts, including Error Handling:
👉 bit.ly/2Ojz9lX
I plan to create a video that explains how to use the advanced version, including a code walk-through.
Cheers,
Sven ✌
@@CodingIsFun Hello Sven, Namaskaar!! Thank you for your prompt response. I had gone through your advanced version excel as well. Since, I am not from coding background I was confused, as it apparently looked complex.
Thank you for assuring to release a similar detailed video in near future just like basic version. Desperately Look forward!! Many thanks in again buddy!! Keep Shining!
Hi Sven,
I m in need of that detailed video for bulk sharing media files excel to whatsapp. Cud u pls do it as early as possible. Thanks a ton in advance.
@@vineetsharma8261 Hi Vineet Sharma. It is still on my to-do list. Recently I was working on other tutorial topics - Sorry 😕 Do you need any urgent support? Is something not working? Please let me know.
@@vineetsharma8261 Sorry for letting you wait. Yesterday I have uploaded the video on how to use the advanced version:
ruclips.net/video/lt2xhww_wcE/видео.html
Hope you like it 🙏
Hey @Coding Is Fun, I have a question. For Excel WhatsApp BOT you shared, I wanted to add a formula to autopopulate the number and the message to be sent. I realize that every formula I add it adds a ' before the formula. Sorta like '=vlookup(..... Is there anyway to address that?
Thanks for watching the video. You might want to check the format of the column. Perhaps it is set to 'text' at your end?!
www.screencast.com/t/bNnxVmIsr9
I hope this helps!
@@CodingIsFun That's what it was!!!! thank you so much
Amazing video! Straight up, accurateness and very understandable. Thank you for that!
Hi Gabriel. Thank you very much. Glad you enjoyed the video! 😀
Hi Sven, this is Ash from India. Bangalore Appliances is my friend and Recently he told to watched your videos. its fantastic bro nice videos and explaining. am very happy with your all videos. from now i will never miss your videos. thanks a lot.
Thanks for watching the video & your comment :)
Is it possible to include an image to send automatically with the text? I’m not a coder, so if you could show the step-by-step to add image, that would be great!
Yes, that is possible. In the template, you can find an example of how to send images. Download the template here: pythonandvba.com/whatsappsender
@@CodingIsFun thanks a lot! Will try it out :D
All are great on my desktop Windows 10 with Excel 2013.
However, when I run it on another laptop Windows 11 and Excel 365, the image cannot be sent.
Error: 7_NoSuchElementError
Element not found for XPath=//div[@aria-label='Attach']
@@Benson1668 those elements are changed by the updated interface of WhatsApp please update them also in Excel file
One thing I missed.
Lets say I have a 6 line message.
And lets say I have a 100 clients list.
The way it is now, I have to replicate each number 6 times and create a 600 lines sheet. A lot of manual work.
The idea is.
One sheet for message and one for clients.
Or something more automatic.
Anyway, amazing job. Congrats.
Thanks for the suggestions. That is a fantastic idea! But it is sometimes not easy for me to create a one-size-fits-all solution. Currently, I am not planning to add more features.
hello bro am Yash, am watching your videos, all are excellent and fantastic.. I am very happy if you create a bulk Whatsapp sending to unknown numbers. Amazing video! Straight up, accurateness and very understandable. Thank you for that
*I am glad to hear you are enjoying them, thanks for watching and for the comment!*
Hi, first of all big thanks for sharing your knowledge.
I tried your file and it works only for text.
When I paste the path of the selected image or document, the file send me Error:7 No Such Element Error.
What I`m doing wrong?
The get the file`s path I click the button "Copy Path" with the file selected and it give me the correct URL to the file. I add also the " at the beginning and at the end of the path but it doesn't work.
Any help will be much apreciated.
Best.
I assume your (Web)WhatsApp language is not set to English? In that case, you first want to set your WhatsApp environment to English. Follow the steps below: faq.whatsapp.com/general/account-and-profile/how-to-change-whatsapps-language/?lang=en Once done, kindly try it again. Thanks!
this video is amazing only this channel is almost single to this type of automaton knowlege servied free of cost your knowledge is amazing
Happy to hear that you find the WhatsApp Excel solution helpful; thank you for taking the time to leave a comment and the kind words! :)
Hi, the video is super awesome and the sheet works like a dream. Is there a way that i can use your sheet to send and after sending messages whatsapp to remain open and reply to messages received based on key words?
By reply i mean auto reply. Thanks again
@@nayeemkader3884 Thank you. No, that is not possible
Hi there, nice tutorial.
Have couple of doubts.
1. How to find out the correct chrome driver version (My version is Version 122.0.6261.70 (Official Build) (64-bit))?
2. My requirement is first to filter whether the number is using whatsapp or not and send a message?
Let me know the steps
Thanks in advance
Thank you for watching! In response to your questions:
1. You can find your Chrome driver here: googlechromelabs.github.io/chrome-for-testing/.
2. It is not possible to check beforehand if a number is a saved or unsaved contact. If you're using the basic version and attempt to send a message to an unsaved contact, an error will be indicated in the status column. However, if you upgrade to the PRO version, you can send messages to unsaved contacts as well. Learn more about it here: pythonandvba.com/whatsapp-bot/.
I hope this helps! Happy Sending! Cheers, Sven ✌️
This video is amazing! Congrats! You rock!
Thanks for the kind words! I am glad you enjoyed it.
Great video - unfortunately I get an Automation error when VB tries to execute the bot.start command. Any suggestions?
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender
Hi, another thing I found is that, the excel system only can be text to the person we have contacted before, like say we have a conversation with the people before only then it will only able to send the message, otherwise the it when to search and couldn't find the people (due to never talk before) then it will lead to error.
Yes, that is correct. You can only send messages to saved contact of yours. In fact, sending bulk messages to unsaved numbers is again the WhatsApp Terms Of Service.
Hi, I've been using your code for months, this morning when I tried to log in it suddenly didn't work for me. I get a notification that the macros don't work, I went into the settings and of course I gave permission but it still doesn't work. Do you have a solution?
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
Thanks a lot. Very good video, thanks for explain the programming. Greetings from Chile.
*Gracias por ver mi video* 😀
Hii, you said 'do not use it for bulk messaging"... for what purpose can we use this then?
Thanks for watching the video & your question. As also mentioned in the description, I am sharing this knowledge for educational purposes. With VBA Selenium & Excel, you could also automate other tasks/actions like filling out online forms, scrapping websites, etc.
Regarding the use cases of the Excel WhatsApp Sender, this obviously depends on the user. You could, for instance, send New Year greetings to friends, inform colleagues that a report has been published, etc.
@@CodingIsFun ok can I use my 'whatsapp business account' to send message? I am a social worker. I want to send message in bulk... I have 500+ contacts
@@didacticslearningassistanc6256 If I interpret the WhatsApp Terms of Service correctly, this is not allowed:
faq.whatsapp.com/general/security-and-privacy/unauthorized-use-of-automated-or-bulk-messaging-on-whatsapp/?lang=en
"Over time we've seen how people value messaging with businesses and so we've built two tools-the WhatsApp Business app and the WhatsApp Business API-to help companies manage customer interactions. Our products are not intended for bulk or automated messaging, both of which have always been a violation of our Terms of Service."
I used your whatsapp bulk message sender. That was mind blowing........
Now I have to extract contacts from whatsapp groups manually......
Can you give a code to extract contacts from whatsapp groups automatically.....
I shall be very grateful to you.....
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Wow! Fantastic video, well explained. You got a new subscriber.
.
Welcome aboard! Thank you for watching the video & taking the time to leave a comment :)
Thank you very much for the information full of Valuable Content.
My pleasure, thank you for watching!
THANKS!!!! I tried and it worked!! only for fun purposes!
Cheers for the feedback! It's always welcome! 👍
This video is excellent & very understandable. Can you Please explain how to send (Free) bulk messages (Payslip, PDF Attachment) with Excel VBA
Thanks for watching. It is all explained in the free template. You can download it for free here: pythonandvba.com/whatsappsender
Pro level detail video 💯💯
Very very good video
Thanks 😍
@@CodingIsFun love from Pakistan 👍
This is a great video, thank you.
I wondered if there is another video that could be added to this.
In the video you mentioned the following: Selenium can extract data?
Would it be possible to programme the following:
The spreadsheet containing a list of numbers:
The code to complete the following task:
Read the number from the spreadsheet > Look the number up in Whatsapp Web
Extract the conversation for the corresponding number and paste the contents back into the spreadsheet against the corresponding number.
Loop the code, until every line has been processed.
That sounds possible, but obviously requires some lines of code ;)
@@CodingIsFun I will have a look to see if I can modify the code.
If I cannot do it, is this something you would consider looking at?
It would be such a useful to manage large amounts of data.
@@stevethorne44 Probably not because of my current workload.
@@CodingIsFun ok no problem, I'll give it my best shot on my own.
I'll keep an eye out on your videos, just in case.😃.
Thanks again for taking the time to reply anyway.
@@stevethorne44 Happy Coding!
Hi sir! Can i send different message to each number? do i have to save contact of the receiver first?
btw, great video! easy to understood. This can help my business. Thx!
Thanks for watching the video.
You can only send messages to saved contacts, as mentioned in the description box and the pinned comment.
You just input one message per row.
@@CodingIsFun Thanks for the reply!
Your explanation skills are extra ordinary ... I am very grateful!!! I can not access your website though.
Thanks for your kind words! The website had a short downtime. You should be able to access it now.
You should write these codes in the video description, so we can copy them from here. Thank You
I have decided not to include the code in this description, as the template I created has a considerable amount of code, including error handling that is separated into multiple modules. However, you are welcome to download the template and copy the VBA code from there, as it is not password protected.
Your video is very informative and helpful. Thanks
*Thank you.* I am glad you enjoyed the video 😃
Hi, thanks for the video. I follow it through step by step and manage to get it work. Thank You very much. One more, how can I include picture to be send out ? Thanks in advance.
Thanks for watching the video. You would need to tweak the code further. E.g. by clicking the 'attachment' buttons using Selenium:
www.screencast.com/t/r0WhQv7J7vie
If you are stuck, feel free to shoot me an email: contact@pythonandvba.com
Thanks for the video and the program. It's perfect, but I had a problem with the picture. I tried it from the desktop, it didn't work. I tried from C root, still didn't work. But normal text messages are gone. I don't have any trouble. Thanks so much for your sharing.
Do you get an error message?
Thank You Very much My Friend >> I benefited a lot from your lessons ..
Thank you for watching the video. Glad it was helpful! 😃
Wonderful video! Congrats!
Thank you!
Again thank you. It works perfectly. And thanks for the additional help. One last thing i needed to know. Is there any way of signing in without scanning the qr code everytime?
www.screencast.com/t/Jhjhw3NfbXt
@@CodingIsFun sorry i didn't get it. 😥
Its just a picture. No codes are there . Am i missing something?
@@zatak3689 Download the Excel file from the description!! This feature is already implemented!
I used this and it works! Thanks for the video, Sir. Could I ask for one more video on How To Send WhatsApp Images From Excel Using VBA? I need to send images too. Thanks in advance!
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
How can we stop the process In between after clicking that send message button?
*Hello Lokesh Gupta, thanks for watching the video and your question.*
Just press "ESC" on your Keyboard to stop executing the VBA code.
@@CodingIsFun thank you!❤️👍
Your video is very enlightening and helped me a lot! Thanks!
However, I have a problem attaching images, they do not send. How to proceed?
Hi Bárbara,
Thanks for watching the video.
I assume that your (Web)WhatsApp language is not set to English?
In that case, you first want to set your WhatsApp environment to English.
Follow the steps below:
faq.whatsapp.com/general/account-and-profile/how-to-change-whatsapps-language/?lang=en
Once done, kindly try it again.
Thanks!
Thank You very much for sharing these tools. You saved my life
Thank you. I am happy to hear that :)
Great Video ! Thank you very much. Just one question, if i want to add also a picture to the messages ?1 How can i do that ? Thanks
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Okay That's straight and really cool .. but any ideas for sending messages to contacts not included in your contact list??
Yes, that is possible. In the past, I have created a solution for this. Yet, the video got removed from YT as it was against the WA Terms of Service. Hence, I would not recommend sending multiple messages to unsaved contacts.
@@CodingIsFun Okay again .. I'm going to google for it .. by the way you and your videos are astounding .. keep going bro 👌🏻👍🏻
@@mohamedhnfy Thank you :)
amazing video! Saved a lot time, thank you so much
A pleasure, thanks for watching! 😃
Hello, thank you very much for the video. Although I am showing the file path correctly, I am getting the error as below. What should I do?
Error: File does not exist
Have you tried to use a different file path, e.g. your Desktop? It might be due some special characters in your file path/file name
@@CodingIsFun The file name is abc but unfortunately it cannot be found. :(
@@canvardar2412 Then I do not have a solution
Great solution, great video. Thanks a bunch.
On the message I am sending a multi paragraph message but I would like to keep it in the same message instance. How can I enter the text in the excel file to avoid creating a new message instance many times? Thanks
Thanks for the positive feedback.
Have a look here at how to insert paragraphs:
pythonandvba.com/whatsappsender
I hope you can make videos on how to utilize JS in Excel Online. It's a new feature and I think it will be the future since VBA will phased out. Thanks a lot!
Thanks for your suggestion. I am not really an expert on JS in Excel. Hence, most likely, I will not publish any videos regarding this topic in the near future.
Excellent work bro !!
Keep it up🔥🔥
Thank you. Glad you like it :)
Amazing!, I am still using your advanced version, thanks alot
Thank you! I am glad you like the solution :)
can you share the advanced version as it has been removed
@@abdallahawawdeh1705 The advanced version was not in line with the WA Terms of Service. Therefore I will not further distribute it. Thank you for your understanding!
@@abdallahawawdeh1705 Sorry, I can't
can you please share me advanced version ?
Dear Sir - in my system chrome version is 108 so which chrome driver I need to install
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Great Tutorial, I have 1 Problem i have met. What happens when i have a mixture of numbers in my contact book. I mean Some of my contacts are on whatsapp, where as others arent. Thank you
Thanks. If you use this version: pythonandvba.com/whatsappsender , the BOT will continue to the next number/row, if the number does not exist in your contact book
Very good video. Thank you for making this.
One question: My whatsapp message has 2 paragraphs, and while sending normal Whatsapp message, I do ALT+Enter to create a new paragraph in the same message. While doing this using excel, I am not able to create this kind of message. When I enter, it will go as a different Whatsapp message instead of one long message. Any suggestions on how I can compose one message which is long and has multiple paragraph?
As described on the website (pythonandvba.com/whatsappsender), you can try to use the pipe symbol:
www.screencast.com/t/oRnKSVXXw4
@@CodingIsFun Thank you so much
Thank you so much for sharing this insightful video. I implemented the bulk messaging and it works perfectly. However, i have been getting runtime error '11' when i try to run a new campaign of about 200 recipients
*Thank you.* I am glad you enjoyed the video 😃
Do you use the 'Advanced' version (which I recommend)?
👉 bit.ly/2Ojz9lX
If so, could you share what exactly the error message says? Thank you.
@@CodingIsFun kindly check this link & if possible please share this video link here
Hi. I get an error which was basically not opening the crome browser. I use windows on parallels. My default drive was //mac/... . The solution was to move the file to a folder in c: drive of the virtual machine. Did a code walkthrough and I must say this has been a very thoroughly and neatly written piece of code. Very useful. I was not able to send images and documents. I did check for the updates but there were none. Hope this update is done as well. My app language is English so that was not the issue.
Glad you like the solution. If I find the time, I will check if I also cannot send images/documents and update the template.
I tried to modify it to suit my needs of sending our milk data to customers. I have hardcoded the monthly dates coz I couldn't figure out how to use arrays.
Right now the problem i am facing is that after each date, a new message due to use of **& Chr(10) &** is being created and sent to the customers for the next date. I want all dates and respective milk qty to go in just one whatsapp msg
I wish i could share the code with u so that you can help me to modify it
@@engicofarmer4713 *Thank you for watching the video"
Have you already tried the 'advanced' version, which you can find here:
👉 bit.ly/2Ojz9lX
To send multiline messages you could use the pipe symbol " | ", e.g.:
Line 1 | Dates | More Dates | Line 4
Hope it helps 🙏
Cheers,
Sven
@@CodingIsFun Hi The link is not working.
First of all i would like to thank you about this educational video and thanks for sharing ready to go excel file. I am not familiar about VBA coding.
My question or asking from you is how can i personalize bulk messages?
Such as "Hello [name of customer] happy new year :)"
i tried with formulas but i think VBA checks is there any text or not. When i put formula in cell it promts "please fill out all required fields in Column A,B,C"
If you are able to assist me about this, i would be greatful to you :)
Thanks al lot!
Which common sickness of people. After commented to you, i found rookie solution :) Maybe someone like me can use it.
Rokie Solution: I create new sheet and type some "Hello & TEXT($K2,"general")& happy new year :)" to one column
and from "K" column i am taking the names :)
I know excel experts can create automation for it but i can't :)
Maybe kindly this can be a tip for you to develop this Excel Sheet
@@sertugbaysin Thank you for watching the video. Cool to hear that you found already a workaround. I also went ahead and created the following version for you:
👉 drive.google.com/file/d/1tvzbE4JRFx2RvD3KX917v8035UUBtkc_/view?usp=sharing
Hope you like it 🙏
Thank you mate. Appreciated 🤝🙂
dear
kindly, if i have many numbers , and maybe there's number not registered with WhatsApp , how i fix this point.
Hi there,
I have adjusted the code. If the number is not registered, the BOT will go to the next number & indicate the error including a timestamp in column "D".
Please find the adjusted workbook here [Option A]:
👉 bit.ly/3k6YdYw
Hope this solution works for you.
Cheers,
Sven
First I want to thank you for sharing your work, amazing BOT.....hopefully you continue updating this BOT. I already subscribed to your channel, also, I already visited your page. excellent tutorials, thank you so much
Welcome aboard! Thanks for the sub! 👍😍
Thank you for this excellent tutorial. Is it possible rather than text to send an image?
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/whatsapp-bot/#FAQ I hope it helps! :)
thank you for tutorial but the code no play already since bot.Start "chrome",....................... I also performed the selenium procedure. Why?
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender
Cheers, Sven
😀😁😁thks you so much , i have been looking for it for a long times, 👍👍👍this program very userful
Glad I could help! Thanks for watching the video & taking the time to leave a comment :)
Hi, Can we send multiple keypress commands using selenium in VBA excel? For example: Ctrl + " V "
Yes, you can.
Dim ks As New Keys
BOT.Keyboard.KeyDown (ks.Control)
BOT.SendKeys ("V")
BOT.Keyboard.KeyUp (ks.Control)
Or you could try:
A workaround would be to copy the data and write it using sendkeys.
[A1:B12].Copy
txt = BOT.getClipBoard()
BOT.SendKeys txt
@@CodingIsFun Tried the first one in various permutations and combinations...Its only printing V in the WhatsApp text box 😒😢
The second one doesn't conserve the text format, so does not work for my project.
Plz help. Thanks!
@@ForEximTV There is no easy way, like CTRL+V, to copy the cell content *PLUS* formatting and pasting it into the WebWhatsApp Interface.
For the formatting, please use:
You could also send a **bold text**
You could also send a ~ -strikethrough text- ~
You could also send an __italic text__
In general, Emojis are supported within the Chrome Webdriver. Hope it helps.
Thank you so much. You are a genius.
Thanks for the kind words! I am glad you enjoyed it.
Very good project well explained fully working
Thanks
Glad you like it! Thanks for watching and leaving a comment! :)
Thanks for this wonderful video. Really helpful. How about if I want to send a picture instead of text? Cheers
Thanks for watching. Yes, it is possible. Please download the template from the description.
Thank you very much for this amazing innovation. I have a question, please
When I send a message consisting of several lines, it reaches the recipient in the form of a separate message for each line. How can I solve this problem?
Thanks for watching the video and for your question. You can find the answer to your question in the FAQ section of the following page: pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
Thanks for this wonderful tutorial. Thank you so much.
But even if the contacts were saved in my phone contact list, the first contact received his message and also the remaining numbers with their specific message: The numbers were just as regular messages sent to the first contact in the excel list.
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender
Also, in the template, please increase the delay time and try again
Thank you very much for this wonderful piece of program. I am using the one which I downloaded from the description box. In that can you please help me to set chrome user profile such that I don't need to scan the QR code everytime?
Thank a ton!
To avoid scanning the QR Code every time you are using the BOT, you can use the following solution: ruclips.net/video/HYl-gftg9Rw/видео.html
Great video, simple instructions thank you. I have a two part question. I use Microsoft Edge, how will I use this instead of Chrome and how do I maintain access, without having to repeatedly sign/log-in using QR code?
Thanks! Regarding your questions:
1) I had different troubles with the other web drivers. The chrome driver worked best for me.
2) If you download the fully coded out template (pythonandvba.com/whatsappsender), you will find an option to avoid scanning the QR every time you run the BOT.
I hope this helps!
@@CodingIsFun Thank you again, will dig into it. Please keep the tutorials coming!
Hello, I'm not sure if this will answer your question.
For you to not always sign/log in using QR Code.
You can put this code
bot.AddArgument(Then find the cookies of your Google Chrome)
But recently, we are having a problem with the current chromedriver.
Thank you
Hi. I can't use Chrome since our IT policy forces me to use Edge (yes, don't ask). I get a "cannot find Chrome binary" error, even when using the link you posted below. Any suggestion? (and I will not use it for bulk spam). I made the following change to the code but it didn't work.
''' Init New Chrome instance & navigate to WebWhatsApp
150 BOT.Start "edge" 'BOT.Start "chrome"
Excellent video, you are a great teacher.
Any way to send qn image from the excel?
Thanks for watching the video and your kind words. While it is technically possible, this feature is not available in the current version. Sorry! 😕
Hi Amazing solution absolutely loved it and the demo. Just a question is there a possibility to make it an interactive message, or like an button response?
Thank you. No, that is not possible
@@CodingIsFun Thanks for that, another quick question can I make my message dynamic using the excel column formula? Like Msg with custom names?
@@adityapalwankar1386 Yes, that is possible. I suggest downloading the template from the description and just testing it out :)
Very good information. Well explained. Keep going.
Thank you!
Thank you sir, your wonderfull video, really it is useful for me,,, I never forget you in my life
Always welcome! Thank you for your kind words :)
awesome automation tutorial
Glad you liked it and thanks for watching the video! :)
Amazing way to broadcast on whatsapp, I would like to heard about the ways we can do this carefully (limit the number of contacts or increase the sending time), because our whatsapp account can be blocked by getting report from the users.
Thanks! In the template from the description you can set an delay time between messages.
Hey could you plaese please help me how to add another row. For example if i want to send both pictures and a paragraph in the next row same message. Thanks !!
Use the 'Caption' field in the template
I have a catalogue in my whatsapp business. When someone creates an order from my catalogue shop, a bill will be created with the total price . Can I send this generated bill data on Whatsapp to another platform like excel for analytics
Thanks for watching. I am not sure if that is possible. Sorry that I cannot help!
There are tags in the items in a catalogue, the tags could be used as identifiers to be selected and transferred to excel I guess?
Thank you very much sir for this video. It helps me a lot. Keep it up Sir
Glad you liked the video! Thanks for watching the video and your comment! :)
The WhatsApp sending in Excel VBA worked fine for a while and decided to stop working today. This time, I am able to send photos but not text messages. I got the following error message when I send text:
Error: 0_SeleniumError
element not interactable
(Session info: chrome=91.0.4472.124)
(Driver info: chromedriver=91.0.4472.19 (1bf021f248676a0b2ab3ee0561d83a59e424c23e-refs/branch-heads/4472@{#288}),platform=Windows NT 10.0.19041 x86_64), 07/09/2021 18:37:56
What could be the problem? Appreciate your help as always!
Yes same issue with me did you solved?
Sorry, the XPath for the text input field has been changed. I have updated the version. Please find the download link here:
bit.ly/2PZZQwn
@@CodingIsFun I changed the XPath and it worked like MAGIC! However, there's one thing that I do not understand. My excel is standalone copy in my laptop and not connected to anywhere. And I did not change anything in the coding and you changed the text input field in your machine. How did the text input field change in your machine affect my copy in my laptop and make it not work anymore? I am very curious here......and yes, let's have coffee! Cheers!
@@UncleLeeAdventures, First of all, thanks for the coffee! I truly appreciate your support.
I assume that you are using the 'advanced' version of the WhatsApp Bot? If I understand you correctly, you have changed the Xpath for the textinputfield in the worksheet 'settings', right? In the VBA code, I am retrieving the XPath from the Settings Worksheet. There is no additional adjustment in the VBA code required.
I definitely do not have any access to your workbook :)
@@CodingIsFun I do not know which version I have....but it works...so that's most important.
I changed the XPath in the Sub WhatsApp_BOT() as below. Replaced line 1 with line 2.
Sub WhatsApp_BOT()
'X_PATH_SETTINGS
txtinputfield = "//*[@id='main']/footer/div[1]/div[2]/div/div[1]/div/div[2]" -> Line 2
'txtinputfield = wsSettings.Range("txtinputfield").Value -> Line 1
Thank you, clear and to the point
Glad it was helpful! 👍
Wowsome video...!! Informative and helpful.
*I am glad you liked the video, thanks for watching and for the comment!*
Thank you very much for this tutorial, it worked with me simply
Thank you for watching the video & your comment. Glad it is working 😃
Thank you so much for this very helpful program.
A pleasure. Thanks for your comment!
It's Working 100% Runtime error cleared as per the comment
PLEASE send the link to add Images.
To send images, you could use the 'advanced' version.
👉 bit.ly/2Ojz9lX
Great solution, great video. Thanks
On the message I am sending a multi paragraph message but I would like to
It's possible, please check out pythonandvba.com/whatsappsender for more information
hi, the video was great and helpful, but I'm stuck at the starting point of VBA code at activating selenium type library-the options reference is not showing. Can U help me with this?
*Hello aditya viswanathan, thanks for watching the video and your comment.*
Did you install VBA Selenium as shown at 0:40min?
Will Whatsapp Ban /block me if I use the VBA macro to send whatsapp to only 200 numbers daily ? I read that whatsapp has serious issues with automated sending of whatsapp. How can I bypass this blocking by Whatsapp ?
Yes, this could happen.
To avoid this, you might want to buy access to the WhatsApp API. There are different providers out there. One of them is called 'Twilio'. You will find more information on their website.
Could this run on an automatic timer, like one message every hour?
Yes, it is possible, but it requires further modification. One easy would be to keep the Excel file open and insert a delay of 60 min between each message.
@@CodingIsFun Thank you!