📢 *UPDATE:* There is now a new, better, and more robust template available that lets you send attachments, emojis, format your text, and much more. Check out my new video here: ruclips.net/video/MhpcgvLbgf8/видео.html
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
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
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
@@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!
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.
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
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 🙏
@@risenacademy189 Please have a look here: docs.pythonandvba.com/whatsappblaster/guides/how-to-minimize-the-risk-of-getting-banned-on-whatsapp 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
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']
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
Thank you very much. Usually I'm not subscribing to the channel but I like and subscribed to your channel which is very useful and helping purpose. you got 5 star out of 5. keep it up.
Thanks a lot for this video.... I love your heart, you teach like you really want your viewers to know what's being taught. I'm having issues with the advanced bot, the messages don't seem to get delivered, pls could you shed some light to that? Would be truly appreciated.
*Thanks for watching the video & your comment.* Could you please try the following instead: Dim wsBOT As Worksheet Set wsBOT = Worksheets("WORKSHEETNAME") 'Replace Worksheetname lastrow = wsBOT.Cells(Rows.Count, 1).End(xlUp).Row Hope it helps! 🙏 Cheers, Sven
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 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 ✌️
error showing from tommorow "Error: 7_NoSuchElementError Element not found for XPath=//*[@id='main']/footer/div[1]/div/div/div[2]/div[1]/div/div[2], 11-11-2021 11:50:39" changed driver but not help pls resolve
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?
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.
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.
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?
Hi Mate how do I keep the original cell text wrap formatting of the first 3 cells for the remaining cells? The cells get larger when I try to copy my message in there. I had a problem sending image as it side it could not find 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/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
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
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!
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.
Hello sir, Thank a lot for the tutorial. this is very well explained. I have a question if thats possible to add attachment to these messages i.e. JPG, PDF etc. Your answer will help a lot to automate my marketing process. Thanks again
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! :)
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 video below are some of the findings which i have observed - 1. Sometimes my whats app web is taking more time to load till it loads I get an error in excel. --> How can I increase the wait time 2. While sending the Images Caption which is mentioned in the excel is not getting added in Whats app also while checking in VBA there is not XPATH mentioned for where Caption data has to be mentioned
Hi, please see my answer below: 1. please increase the delay time in the template 2. the xpath of the caption has been changed in the past. To avoid updating the XPath every time, I came up with a workaround. I have noticed that the cursor is already in the caption field after selecting an image. Hence, I am inserting the caption without using the xpath. If you look at my code, you will notice my comments... www.screencast.com/t/bhrrOoPwpWN I hope this helps!
Hi Sven, Had one more doubts 1. I have automated this Excel and suppose if my system is locked at that time only captions are being sent images are ignored Any idea it is ignoring the images when system is locked
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.
Hi, thank you for the Great Program / Macro etc. I have a question or two namely is there a way that the sending of the Whatsapp Messages could continue where it left off eg 175 Messages are loaded into Excel but only 55 are sent (usually chrome seems to hang from a time out error) . . . and then you have to delete all the send ones and take the unsent ones to the top again. . . . {Error Message as follows: Run-time error '26': UnexpectedAlertOpenError (Session info: chrome=91.0)
Hi there, Thanks for watching the video & using the solution. I have created the following version for you: drive.google.com/file/d/1YF2V_RugE-EwbtZ946ngWYXBKtkysvxq/view?usp=sharing Only messages without a 'Status' will be sent. Kindly give it a try. Hope you like this solution. Cheers, Sven
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?
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! :)
@@CodingIsFun Is this possible when the number is not available in whatsapp that prompt can be tackled by the automation and the error can be mentioned on the Status field(Input Excel)
@@learningad7174 Please note that this solution works only for your 'saved' contacts. Sending bulk messages to unsaved contacts is against the WA Terms of Service. That said, if the number/name is not available in your contact list, the BOT will already continue with the following number (go to the next row). If you have not already, please use the following version: pythonandvba.com/whatsappsender Thank you! :)
Bumped into a problem, once I'm done filling everything in BOT in the status column there is an error: Error: No contact found | 02.04.2022 13:09:32. What is the solution?
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.
When i run the vba, after second row, it always appear error message of: Run-time error '10' StaleElementReferenceError stale element reference: element is not attached to the page document (Session info: chrome=109.0.5414.120) (Driver info: chromedriver=109.0.5414.74 (e7c5703604daa9cc128ccf5a5d3e993513758913-refs/branch-heads/5 NT 6.1.7601SP1 x86 64) ----- When i hit the debug button, and re-run the script, it will run for the next 1 row before error again. I tried to edit the element for search bar many times, but still not fix the problem. Could you guide me through? Thanks anyway. Much appreciated.
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, 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
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.
@@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!
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, first of all, thank you very much for automation. It's very nice, well done. Error: 7_NoSuchElementErrorElement not found for XPath=//div[@aria-label='Attach'], 06.07.2023 09:21:28 error. I looked at your FAQ solutions. I am using the updated file and using whatsapp web in english but the error still persists. Can you help me?
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?
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!
@@MarketsWithForExim 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.
Hi! As i try to send an image, the status shows me this ""Error: 7_NoSuchElementError Element not found for XPath=//div[@aria-label='Attach'], 07/18/2022 19:14:51" I copy the exact route but keep getting this error.
Hi, i have fresh installed Win10 and Office2019 but i can not send any images or Document // error for sending images - Error: 7_NoSuchElementError Element not found for XPath=//div[@aria-label='Attach'], 08.01.2022 11:34:56
@@trafikarizalari You might want to increase the delay time. I just tested it on my end and sending documents/media files still works. As I cannot replicate the error, I do not know what the error could be.
This vba script uses english language from whatsapp if used another lang. mGlobals muss changed to used whatsapp language Line is Public Const AttachmentButton As String = "//div[@aria-label='Ekle']" of my case i changed aria-label to turkish --- sorry for my bad english
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!
Hey Sven Bo, that's awesome and worked pretty well for me. However I am looking for something where I can send small video's as well and scheduling of message at later day. Can you please help me with that. Also how many Messages can i send though this. And what about the number blocked by whatsapp.
*Thank you.* I am glad you enjoyed the video 😃 To send video, you could use the 'advanced' version, which you can find here: 👉 bit.ly/2Ojz9lX Simply choose 'media' and insert the file path to the video. However, that version also has no scheduling feature 😕 I do not know what the maximum number of messages is. I could not find any official number by WhatsApp.
@@CodingIsFun thanks for taking out time and reverting. Keep up the good work. If u can add schedule feature along with different media attachment on each message. Then it would be very great.
Excellent tutorial! You got a new fan here. Btw, when I used the advanced version for bulk sending messages, after the first invalid number, the script working fine and skip to the next number, but after the second "Invalid phone number", the script do nothing. I wonder if it's just me or something with the script or else?
Thank you for watching the video. Glad you like it. Do you get an error message? I am not quite sure why the BOT got stuck. Could you kindly try to increase the delay time in cell H7, e.g. to 8 seconds?
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! :)
Hi Sven, this has helped me in the past. Thank you. i want to use it again but cannot find chrome driver for the version i`m on (to new) do you have an update on this? Thank you.
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! :)
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 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.
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.
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! :)
First I'd like to thank you for your wonderful tool. I used the advanced version, but I couldn't send media, asking me to add a path, but I couldn't figure out where to add the path; in which cell or in which line in the vba code... could you help me please?
*Thank you.* I am glad you like the tool 😃 Kindly check out the following video on how to insert the image path to the workbook: ruclips.net/video/qjYiMR3KqgU/видео.html&ab_channel=CodingIsFun Hope it helps. Cheers, Sven✌
@@AvinashKumar-xj8dp Sorry, the advanced version was not in line with the WhatsApp - Terms of Service. Hence, I will not further distribute or maintain the advanced version. Thanks for your understanding.
@@CodingIsFun thanks alot for your reply. Where i can find the vba code that u have created to just and copy and paste since to be honest i dont know vba and dont understand coding
📢 *UPDATE:* There is now a new, better, and more robust template available that lets you send attachments, emojis, format your text, and much more. Check out my new video here: ruclips.net/video/MhpcgvLbgf8/видео.html
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.
Wants to send long text message.
Could you please help me.
Amazing video! Straight up, accurateness and very understandable. Thank you for that!
Hi Gabriel. Thank you very much. Glad you enjoyed the video! 😀
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.
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! :)
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.
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! 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?
I have no idea yet if it works, but grand thanks for the easy style of tutorial, love it really
Thanks! Ensure to download and use the latest template: pythonandvba.com/whatsappsender
Happy Sending!
@@CodingIsFun Having drinks as a Russian style assumes weekends :) Will definetely check it out.
@@Yaroslafff Happy Drinking!
@@CodingIsFun Yeahh!!
@@CodingIsFun The very different content, will you accept the link to music?
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
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! 😃
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
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 :)
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. 👍
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
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 🙏
Just did it and it still works! Great video, thank you
Nice! Glad you like the solution! -Sven ✌️
How do you prevent your number from being flagged for spamming?
@@risenacademy189 Please have a look here: docs.pythonandvba.com/whatsappblaster/guides/how-to-minimize-the-risk-of-getting-banned-on-whatsapp
Cheers, Sven ✌
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 :)
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 | ?
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
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!*
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! :)
Pro level detail video 💯💯
Very very good video
Thanks 😍
@@CodingIsFun love from Pakistan 👍
This video is amazing! Congrats! You rock!
Thanks for the kind words! I am glad you enjoyed it.
Thank you very much. Usually I'm not subscribing to the channel but I like and subscribed to your channel which is very useful and helping purpose. you got 5 star out of 5. keep it up.
*Hi sawan78. I am glad you liked the video; thanks for watching and for your kind words!* Welcome aboard! 😃
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 :)
Thanks a lot for this video.... I love your heart, you teach like you really want your viewers to know what's being taught. I'm having issues with the advanced bot, the messages don't seem to get delivered, pls could you shed some light to that? Would be truly appreciated.
*Hello Nnamdi Ogbonna, thanks for watching the video and your kind words.*
In regards to your issue, do you get any error message?
@@CodingIsFun I don't get any error messages
@@nnamdimusic1 Could you try to increase the delay time in cell "H7", e.g. 7 seconds?
@@CodingIsFun ok, I'll try that, thanks so much for your response
can you please share me advanced version ?
@3:58 is the line where it shows error. My last rows says empty
*Thanks for watching the video & your comment.*
Could you please try the following instead:
Dim wsBOT As Worksheet
Set wsBOT = Worksheets("WORKSHEETNAME") 'Replace Worksheetname
lastrow = wsBOT.Cells(Rows.Count, 1).End(xlUp).Row
Hope it helps! 🙏
Cheers,
Sven
make sure its xlUp not x1Up
I love the tutorial. I was wondering how I can open an already existing profile that has the web WhatsApp scanned?
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 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 ✌️
error showing from tommorow
"Error: 7_NoSuchElementError
Element not found for XPath=//*[@id='main']/footer/div[1]/div/div/div[2]/div[1]/div/div[2], 11-11-2021 11:50:39"
changed driver but not help
pls resolve
I just released a new version. Please click on 'Check for updates' and use version 1.4. Let me know if it works. Thanks!
sir now working,i had changed xpath after watching video.
thanks a lot
Wonderful video! Congrats!
Thank you!
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
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! 👍
Very interesting tutorial Sven! 👌
Thank you! :)
@@CodingIsFun Is it still working these days?
@@abdulsslamalshehri5818 Yes, it is still working :)
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 :)
Thanks a lot. Very good video, thanks for explain the programming. Greetings from Chile.
*Gracias por ver mi video* 😀
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!
Hi Mate how do I keep the original cell text wrap formatting of the first 3 cells for the remaining cells? The cells get larger when I try to copy my message in there. I had a problem sending image as it side it could not find 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/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/ I hope it helps! :)
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 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
Excellent work bro !!
Keep it up🔥🔥
Thank you. Glad you like it :)
Very good information. Well explained. Keep going.
Thank you!
Thank you very much for the information full of Valuable Content.
My pleasure, thank you for watching!
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!
Hello sir, Thank a lot for the tutorial. this is very well explained. I have a question if thats possible to add attachment to these messages i.e. JPG, PDF etc. Your answer will help a lot to automate my marketing process. Thanks again
Yes, that's possible. I already have a solution for that. Please check the link from the description box.
Yes, that's possible. I already have a solution for that. Please check the link from the description box.
Thank you much for this wonderful information
Glad you liked it. Thanks for watching!
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! :)
THANKS!!!! I tried and it worked!! only for fun purposes!
Cheers for the feedback! It's always welcome! 👍
Your video is very informative and helpful. Thanks
*Thank you.* I am glad you enjoyed the video 😃
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
Thanks for the video below are some of the findings which i have observed -
1. Sometimes my whats app web is taking more time to load till it loads I get an error in excel. --> How can I increase the wait time
2. While sending the Images Caption which is mentioned in the excel is not getting added in Whats app also while checking in VBA there is not XPATH mentioned for where Caption data has to be mentioned
Hi,
please see my answer below:
1. please increase the delay time in the template
2. the xpath of the caption has been changed in the past. To avoid updating the XPath every time, I came up with a workaround. I have noticed that the cursor is already in the caption field after selecting an image. Hence, I am inserting the caption without using the xpath.
If you look at my code, you will notice my comments...
www.screencast.com/t/bhrrOoPwpWN
I hope this helps!
Hi Sven,
Had one more doubts
1. I have automated this Excel and suppose if my system is locked at that time only captions are being sent images are ignored
Any idea it is ignoring the images when system is locked
@@AvinashKumar-xj8dpI have never came across this kind of issue. Hence, I don't have a solution to this
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!
Hi, thank you for the Great Program / Macro etc. I have a question or two namely is there a way that the sending of the Whatsapp Messages could continue where it left off eg 175 Messages are loaded into Excel but only 55 are sent (usually chrome seems to hang from a time out error) . . . and then you have to delete all the send ones and take the unsent ones to the top again. . . . {Error Message as follows: Run-time error '26': UnexpectedAlertOpenError (Session info: chrome=91.0)
Hi there,
Thanks for watching the video & using the solution. I have created the following version for you:
drive.google.com/file/d/1YF2V_RugE-EwbtZ946ngWYXBKtkysvxq/view?usp=sharing
Only messages without a 'Status' will be sent. Kindly give it a try.
Hope you like this solution.
Cheers,
Sven
@@CodingIsFun Thanks. I have tried adding it into your Advanced Version and fully tmrw but it does seem to be working.
hi, great tutorial! is there a way to modify the excel file via php without losing the macros?
I have never manipulated an excel file using PHP. Hence, I am not sure if it will be the affecting the containing macro - 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 :)
Smooth as butter, amaizing work! thanks for sharing. one question can i send Text and attachment together. ?
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! :)
@@CodingIsFun sorry but there is no FAQ for sending TEXT AND ATTACHMENT TOGETHER. - PLEASE HELP - THANKS
Wowsome video...!! Informative and helpful.
*I am glad you liked the video, thanks for watching and for the comment!*
Great Work Buddy! Really Appreciate that :)
A pleasure! Glad you like the solution! :)
@@CodingIsFun Is this possible when the number is not available in whatsapp that prompt can be tackled by the automation and the error can be mentioned on the Status field(Input Excel)
@@learningad7174 Please note that this solution works only for your 'saved' contacts. Sending bulk messages to unsaved contacts is against the WA Terms of Service. That said, if the number/name is not available in your contact list, the BOT will already continue with the following number (go to the next row). If you have not already, please use the following version:
pythonandvba.com/whatsappsender
Thank you! :)
Bumped into a problem, once I'm done filling everything in BOT in the status column there is an error: Error: No contact found | 02.04.2022 13:09:32. What is the solution?
As the error suggests, it seems that there is no chat history with the phone number you entered.
Thank you so much for this tutorial. İt is amazing
Thank you! Glad you liked it!
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.
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!
This is a very helpful video. Thanks a lot bro.
When i run the vba, after second row, it always appear error message of:
Run-time error '10'
StaleElementReferenceError
stale element reference: element is not attached to the page document
(Session info: chrome=109.0.5414.120)
(Driver info: chromedriver=109.0.5414.74
(e7c5703604daa9cc128ccf5a5d3e993513758913-refs/branch-heads/5
NT 6.1.7601SP1 x86 64)
-----
When i hit the debug button, and re-run the script, it will run for the next 1 row before error again.
I tried to edit the element for search bar many times, but still not fix the problem.
Could you guide me through? Thanks anyway. Much appreciated.
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender
Thanks for your video! Do you have a python version of this solution? :)
Thanks for watching. Sorry, I do not have a Python version of this solution.
@@CodingIsFun Hey thanks for the prompt reply. No worries. I am a new subscriber and I enjoy watching your video solutions. Keep it up man!
@@limhanyang8303 Welcome aboard! I am happy to hear that you have been finding the videos enjoyable 😃
Thank you, clear and to the point
Glad it was helpful! 👍
amazing video! Saved a lot time, thank you so much
A pleasure, thanks for watching! 😃
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"
awesome automation tutorial
Glad you liked it and thanks for watching the video! :)
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.
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
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! 😕
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!
😀😁😁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 :)
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 ?
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, first of all, thank you very much for automation. It's very nice, well done. Error: 7_NoSuchElementErrorElement not found for XPath=//div[@aria-label='Attach'], 06.07.2023 09:21:28 error. I looked at your FAQ solutions. I am using the updated file and using whatsapp web in english but the error still persists. Can you help me?
If you are using the latest version and you are sure, that you have set your WhatsApp settings to English, then I cannot help you, sorry!
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
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!
@@MarketsWithForExim 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.
Hi! As i try to send an image, the status shows me this ""Error: 7_NoSuchElementError
Element not found for XPath=//div[@aria-label='Attach'], 07/18/2022 19:14:51" I copy the exact route but keep getting this error.
Thanks for watching. Please download and use the template from the description and try again. Thanks!
Hi, i have fresh installed Win10 and Office2019 but i can not send any images or Document // error for sending images - Error: 7_NoSuchElementError
Element not found for XPath=//div[@aria-label='Attach'], 08.01.2022 11:34:56
Hi, please use this version: pythonandvba.com/whatsappsender
Thanks!
@@CodingIsFun i have used latest version but no luck!
@@trafikarizalari You might want to increase the delay time. I just tested it on my end and sending documents/media files still works. As I cannot replicate the error, I do not know what the error could be.
This vba script uses english language from whatsapp if used another lang. mGlobals muss changed to used whatsapp language Line is Public Const AttachmentButton As String = "//div[@aria-label='Ekle']" of my case i changed aria-label to turkish --- sorry for my bad english
@@trafikarizalari Great that you found a solution. Thanks for sharing!
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!
Hey Sven Bo, that's awesome and worked pretty well for me. However I am looking for something where I can send small video's as well and scheduling of message at later day. Can you please help me with that. Also how many Messages can i send though this. And what about the number blocked by whatsapp.
*Thank you.* I am glad you enjoyed the video 😃
To send video, you could use the 'advanced' version, which you can find here:
👉 bit.ly/2Ojz9lX
Simply choose 'media' and insert the file path to the video.
However, that version also has no scheduling feature 😕
I do not know what the maximum number of messages is. I could not find any official number by WhatsApp.
@@CodingIsFun thanks for taking out time and reverting. Keep up the good work. If u can add schedule feature along with different media attachment on each message. Then it would be very great.
@@PG-zv3yy Thank you for the suggestions. If time permits, I will add those features.
Thank You Very much My Friend >> I benefited a lot from your lessons ..
Thank you for watching the video. Glad it was helpful! 😃
Thank You very much for sharing these tools. You saved my life
Thank you. I am happy to hear that :)
Thanks a lot bro, is there a way to do the selenium on mac?
Thank you for watching the video. Unfortunately, VBA Selenium is not available for mac 😌😕
Excellent tutorial! You got a new fan here. Btw, when I used the advanced version for bulk sending messages, after the first invalid number, the script working fine and skip to the next number, but after the second "Invalid phone number", the script do nothing. I wonder if it's just me or something with the script or else?
Thank you for watching the video. Glad you like it.
Do you get an error message?
I am not quite sure why the BOT got stuck. Could you kindly try to increase the delay time in cell H7, e.g. to 8 seconds?
@@CodingIsFun may because the second number was not registered on WhatsApp
can you please share me advanced version ?
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! :)
Hi Sven,
this has helped me in the past. Thank you. i want to use it again but cannot find chrome driver for the version i`m on (to new) do you have an update on this? Thank you.
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 that was amazing can do the same to google sheet?
Thank you for watching the video. The entire code is written in VBA, which cannot be easily transformed to Google Sheets - sorry! 😕
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
Very good project well explained fully working
Thanks
Glad you like it! Thanks for watching and leaving a comment! :)
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.
Great ! keep it up buddy.
*Hello Reema Hafez, thanks for watching the video and your comment.* 😃
Excellent 👍
Thank you! 😃
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
Hello Sir, Thanks a lot for this support, is there a way to send to specific groups instead of numbers in this
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! :)
First I'd like to thank you for your wonderful tool.
I used the advanced version, but I couldn't send media, asking me to add a path, but I couldn't figure out where to add the path; in which cell or in which line in the vba code... could you help me please?
*Thank you.* I am glad you like the tool 😃
Kindly check out the following video on how to insert the image path to the workbook:
ruclips.net/video/qjYiMR3KqgU/видео.html&ab_channel=CodingIsFun
Hope it helps.
Cheers,
Sven✌
Hi can you please share the link to download the advanced version
@@AvinashKumar-xj8dp Sorry, the advanced version was not in line with the WhatsApp - Terms of Service. Hence, I will not further distribute or maintain the advanced version. Thanks for your understanding.
can you please share me advanced version ?
You are the man!
U got a sub
*Thank you.* I am glad you enjoyed the video 😃
Thanks alot i have edge and i do not use chrome. What i shall do in this case?
The solution only works for Chrome
@@CodingIsFun thanks alot for your reply. Where i can find the vba code that u have created to just and copy and paste since to be honest i dont know vba and dont understand coding