*Download the template here:* pythonandvba.com/whatsapp-bot *Check out the Docs/FAQ here:* pythonandvba.com/whatsapp-faq
@allantechnology3 жыл бұрын
how i can do that for groups ?
@CodingIsFun3 жыл бұрын
@@allantechnology It also works for Groups. Instead of the number, just provide the name of the group chat in column A.
@allantechnology3 жыл бұрын
@@CodingIsFun bot.Start "chrome", "web.whatsapp.com/" i have error in this code
@CodingIsFun3 жыл бұрын
@@allantechnology Could please let me know the error message or even better, upload the error message here: prnt.sc/ ? Thank you.
@gabrielfds34613 жыл бұрын
Amazing video! Straight up, accurateness and very understandable. Thank you for that!
@CodingIsFun3 жыл бұрын
Hi Gabriel. Thank you very much. Glad you enjoyed the video! 😀
@navanyasharma7376 Жыл бұрын
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 Жыл бұрын
Glad you liked it. Thanks for watching and taking the time to leave a comment!
@melvinodero Жыл бұрын
Hi Nava is it still works?
@pksswad48362 жыл бұрын
Implemented it for VB6. Straight in one single shot, no bugs.... working like magic. Many many thanks
@CodingIsFun2 жыл бұрын
Fantastic! Thanks for watching the video and taking the time to leave a comment.
@nimrod66612 жыл бұрын
hey ! can u send me the code and the excel file please ? something dont work for me
@RobinsonMakwana-wi3ul6 ай бұрын
plz help me i want this code for vb6
@lawrencelim8324 Жыл бұрын
I am impressed with your simple KISS explanation!!! The downloaded Excel works well as of Feb'2023. Thank You.
@CodingIsFun Жыл бұрын
Glad to hear you liked it! Thank you for commenting and watching. 👍
@VijayInani3 жыл бұрын
You rocked !!! Too good !!! Super easy and very well explained. And MAINLY IT WORKS :D ...!!! Kudos..
@CodingIsFun3 жыл бұрын
Thank you! 🎉🎉
@VijayInani3 жыл бұрын
How can I export all WhatsApp contacts from my android device? All the apps are paid or buggy. Any script or quick help?
@CodingIsFun3 жыл бұрын
@@VijayInani sorry, I do not have a solution for that
@VijayInani11 ай бұрын
@@CodingIsFun I used a paid app for it.
@sanketkatariya43222 жыл бұрын
Thankyou so much for the simplified tutorial. It saved so much of time and manual work. Thanks buddy! 🙌🏻
@CodingIsFun2 жыл бұрын
A pleasure! Glad to hear that the solution is helpful!
@sanketkatariya43222 жыл бұрын
@@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 !!!
@CodingIsFun2 жыл бұрын
@@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!
@healurselfcuzin2 жыл бұрын
@@CodingIsFun thanks for all your efforts. Really bringing lot of value to the community. Have a nice day sir
@CodingIsFun2 жыл бұрын
@@healurselfcuzin Thanks for your kind words! 😃
@ermalgashimramori3 жыл бұрын
Your tutorials are very professional and very useful. Keep up the good work.
@CodingIsFun3 жыл бұрын
Thank you so much for your support! 🙏
@misterrozz46553 жыл бұрын
@@CodingIsFun sir my account bngd.. help me pls
@Yaroslafff2 жыл бұрын
I have no idea yet if it works, but grand thanks for the easy style of tutorial, love it really
@CodingIsFun2 жыл бұрын
Thanks! Ensure to download and use the latest template: pythonandvba.com/whatsappsender Happy Sending!
@Yaroslafff2 жыл бұрын
@@CodingIsFun Having drinks as a Russian style assumes weekends :) Will definetely check it out.
@CodingIsFun2 жыл бұрын
@@Yaroslafff Happy Drinking!
@Yaroslafff2 жыл бұрын
@@CodingIsFun Yeahh!!
@Yaroslafff2 жыл бұрын
@@CodingIsFun The very different content, will you accept the link to music?
@englishtree27172 жыл бұрын
thanks a lot , it works pretty well.... I am Arun from Kerala, and Iam a teacher.
@CodingIsFun2 жыл бұрын
Hi Arun. Thanks for your feedback. Glad it is working fine. Greetings to Kerala! :)
@pareezcc37793 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
Thank you, it means a lot!
@pamkmollinedo82523 жыл бұрын
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
@radikutoyo3 жыл бұрын
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
@computal3 жыл бұрын
i know but its don't let me to write the messageb.
@almol79812 жыл бұрын
This was a very helpful video. I'm a beginner programmer and i can say i had a lot of fun doing this.
@CodingIsFun2 жыл бұрын
Glad you liked the video. Thanks for watching and taking the time to leave a comment :)
@Yaroslafff2 жыл бұрын
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.
@CodingIsFun2 жыл бұрын
Fantastic! Happy to hear that everything is working! 👍
@euchariaokoli61523 жыл бұрын
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
@CodingIsFun3 жыл бұрын
*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
@vineetsharma82613 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
*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 ✌
@vineetsharma82613 жыл бұрын
@@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!
@vineetsharma82613 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
@@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.
@CodingIsFun3 жыл бұрын
@@vineetsharma8261 Sorry for letting you wait. Yesterday I have uploaded the video on how to use the advanced version: kzbin.info/www/bejne/oqWVqZutrMSqmac Hope you like it 🙏
@zatak36892 жыл бұрын
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
@CodingIsFun2 жыл бұрын
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
@luxon24442 жыл бұрын
instead of using line breaks use the proper line break format for whatsapp. that is using '|' character instead of or .
@lunag19622 жыл бұрын
@@CodingIsFun does the pipe symbol still work? It just gets printed out on mine
@rajkumarvishwakarma77442 жыл бұрын
@@CodingIsFun I entered in text but paragraph no getting change plz help
@CodingIsFun2 жыл бұрын
@@rajkumarvishwakarma7744 did you use | ?
@rajasthanguide1668 Жыл бұрын
this video is amazing only this channel is almost single to this type of automaton knowlege servied free of cost your knowledge is amazing
@CodingIsFun Жыл бұрын
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! :)
@timothynjau1758 Жыл бұрын
I love the tutorial. I was wondering how I can open an already existing profile that has the web WhatsApp scanned?
@CodingIsFun Жыл бұрын
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! :)
@GarfieldRoss3 жыл бұрын
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?
@CodingIsFun3 жыл бұрын
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!
@GarfieldRoss3 жыл бұрын
@@CodingIsFun That's what it was!!!! thank you so much
@tracyngu66982 жыл бұрын
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!
@CodingIsFun2 жыл бұрын
Yes, that is possible. In the template, you can find an example of how to send images. Download the template here: pythonandvba.com/whatsappsender
@tracyngu66982 жыл бұрын
@@CodingIsFun thanks a lot! Will try it out :D
@Benson1668 Жыл бұрын
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']
@namichand6445 Жыл бұрын
@@Benson1668 those elements are changed by the updated interface of WhatsApp please update them also in Excel file
@ashwaqahmed56463 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
Thanks for watching the video & your comment :)
@biacarniel2 ай бұрын
Just did it and it still works! Great video, thank you
@CodingIsFun2 ай бұрын
Nice! Glad you like the solution! -Sven ✌️
@risenacademy18923 күн бұрын
How do you prevent your number from being flagged for spamming?
@CodingIsFun22 күн бұрын
@@risenacademy189 Please have a look here: docs.pythonandvba.com/whatsappblaster/guides/how-to-minimize-the-risk-of-getting-banned-on-whatsapp Cheers, Sven ✌
@AvinashKumar-xj8dp2 жыл бұрын
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
@CodingIsFun2 жыл бұрын
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!
@AvinashKumar-xj8dp2 жыл бұрын
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
@CodingIsFun2 жыл бұрын
@@AvinashKumar-xj8dpI have never came across this kind of issue. Hence, I don't have a solution to this
@bainwave92788 ай бұрын
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
@CodingIsFun8 ай бұрын
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 ✌️
@stevethorne442 жыл бұрын
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.
@CodingIsFun2 жыл бұрын
That sounds possible, but obviously requires some lines of code ;)
@stevethorne442 жыл бұрын
@@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.
@CodingIsFun2 жыл бұрын
@@stevethorne44 Probably not because of my current workload.
@stevethorne442 жыл бұрын
@@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.
@CodingIsFun2 жыл бұрын
@@stevethorne44 Happy Coding!
@sawan783 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
*Hi sawan78. I am glad you liked the video; thanks for watching and for your kind words!* Welcome aboard! 😃
@yashwanthj58473 жыл бұрын
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
@CodingIsFun3 жыл бұрын
*I am glad to hear you are enjoying them, thanks for watching and for the comment!*
@huffadzgemmaindonesia95122 жыл бұрын
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!
@CodingIsFun2 жыл бұрын
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.
@huffadzgemmaindonesia95122 жыл бұрын
@@CodingIsFun Thanks for the reply!
@francinelandim35412 жыл бұрын
This video is amazing! Congrats! You rock!
@CodingIsFun2 жыл бұрын
Thanks for the kind words! I am glad you enjoyed it.
@christianagulueokoye78473 жыл бұрын
Wow! Fantastic video, well explained. You got a new subscriber. .
@CodingIsFun3 жыл бұрын
Welcome aboard! Thank you for watching the video & taking the time to leave a comment :)
@francescopasanisi6304 Жыл бұрын
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
@CodingIsFun Жыл бұрын
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! :)
@nayeemkader38842 жыл бұрын
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?
@nayeemkader38842 жыл бұрын
By reply i mean auto reply. Thanks again
@CodingIsFun2 жыл бұрын
@@nayeemkader3884 Thank you. No, that is not possible
@davidho10193 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
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
@KilkaWorld Жыл бұрын
You should write these codes in the video description, so we can copy them from here. Thank You
@CodingIsFun Жыл бұрын
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.
@MuhamadFirdausBinMohdRazali Жыл бұрын
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!
@CodingIsFun Жыл бұрын
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! :)
@adityapalwankar13862 жыл бұрын
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?
@CodingIsFun2 жыл бұрын
Thank you. No, that is not possible
@adityapalwankar13862 жыл бұрын
@@CodingIsFun Thanks for that, another quick question can I make my message dynamic using the excel column formula? Like Msg with custom names?
@CodingIsFun2 жыл бұрын
@@adityapalwankar1386 Yes, that is possible. I suggest downloading the template from the description and just testing it out :)
@zatak36892 жыл бұрын
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?
@CodingIsFun2 жыл бұрын
www.screencast.com/t/Jhjhw3NfbXt
@zatak36892 жыл бұрын
@@CodingIsFun sorry i didn't get it. 😥
@zatak36892 жыл бұрын
Its just a picture. No codes are there . Am i missing something?
@CodingIsFun2 жыл бұрын
@@zatak3689 Download the Excel file from the description!! This feature is already implemented!
@vinaysyt2 жыл бұрын
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?
@CodingIsFun2 жыл бұрын
As described on the website (pythonandvba.com/whatsappsender), you can try to use the pipe symbol: www.screencast.com/t/oRnKSVXXw4
@vinaysyt2 жыл бұрын
@@CodingIsFun Thank you so much
@felipecortes95253 жыл бұрын
Thanks a lot. Very good video, thanks for explain the programming. Greetings from Chile.
@CodingIsFun3 жыл бұрын
*Gracias por ver mi video* 😀
@TheGamarraFamily2 жыл бұрын
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
@CodingIsFun2 жыл бұрын
Thanks for the positive feedback. Have a look here at how to insert paragraphs: pythonandvba.com/whatsappsender
@priyanthagamini38602 жыл бұрын
This video is excellent & very understandable. Can you Please explain how to send (Free) bulk messages (Payslip, PDF Attachment) with Excel VBA
@CodingIsFun2 жыл бұрын
Thanks for watching. It is all explained in the free template. You can download it for free here: pythonandvba.com/whatsappsender
@marmikupadhyay4922 жыл бұрын
Your explanation skills are extra ordinary ... I am very grateful!!! I can not access your website though.
@CodingIsFun2 жыл бұрын
Thanks for your kind words! The website had a short downtime. You should be able to access it now.
@mohamedhnfy3 жыл бұрын
Okay That's straight and really cool .. but any ideas for sending messages to contacts not included in your contact list??
@CodingIsFun3 жыл бұрын
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.
@mohamedhnfy3 жыл бұрын
@@CodingIsFun Okay again .. I'm going to google for it .. by the way you and your videos are astounding .. keep going bro 👌🏻👍🏻
@CodingIsFun3 жыл бұрын
@@mohamedhnfy Thank you :)
@barbaraisadora71852 жыл бұрын
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?
@CodingIsFun2 жыл бұрын
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!
@lancerichard71204 ай бұрын
Thank you for this excellent tutorial. Is it possible rather than text to send an image?
@CodingIsFun4 ай бұрын
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! :)
@rogerfederer96393 жыл бұрын
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!
@CodingIsFun3 жыл бұрын
To avoid scanning the QR Code every time you are using the BOT, you can use the following solution: kzbin.info/www/bejne/forPXpqcqcxsiNk
@sertugbaysin3 жыл бұрын
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!
@sertugbaysin3 жыл бұрын
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
@CodingIsFun3 жыл бұрын
@@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 🙏
@sertugbaysin3 жыл бұрын
Thank you mate. Appreciated 🤝🙂
@elvinlee53462 жыл бұрын
Thanks for this wonderful video. Really helpful. How about if I want to send a picture instead of text? Cheers
@CodingIsFun2 жыл бұрын
Thanks for watching. Yes, it is possible. Please download the template from the description.
@bennyfrancis87672 жыл бұрын
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?
@CodingIsFun2 жыл бұрын
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!
@bennyfrancis87672 жыл бұрын
@@CodingIsFun Thank you again, will dig into it. Please keep the tutorials coming!
@johnpaularellano10032 жыл бұрын
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
@pietermalan26302 жыл бұрын
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"
@t-t2611 Жыл бұрын
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
@CodingIsFun Жыл бұрын
Welcome aboard! Thanks for the sub! 👍😍
@andreadalfarra64542 жыл бұрын
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.
@CodingIsFun2 жыл бұрын
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!
@maurod618011 ай бұрын
THANKS!!!! I tried and it worked!! only for fun purposes!
@CodingIsFun11 ай бұрын
Cheers for the feedback! It's always welcome! 👍
@alhadithigroup672710 ай бұрын
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?
@CodingIsFun10 ай бұрын
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! :)
@umarabid53782 жыл бұрын
Pro level detail video 💯💯 Very very good video
@CodingIsFun2 жыл бұрын
Thanks 😍
@umarabid53782 жыл бұрын
@@CodingIsFun love from Pakistan 👍
@ramnik.bansal Жыл бұрын
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.
@CodingIsFun Жыл бұрын
Glad you like the solution. If I find the time, I will check if I also cannot send images/documents and update the template.
@djallaltouati5589 Жыл бұрын
Amazing video!! i always find your videos clear, simple and efficient. and this solution really helped for my project. Keep up the amazing work. I have a question tho. is there a way to keep the browser window Open to use it direclty later for other messages? i need to send several messages to different (saved) contacts but at different moments, and loading the whatsapp page each time is kinda ennoying for the user (because he needs to stop working untill the message is sent). thanks again.
@CodingIsFun Жыл бұрын
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!
@djallaltouati5589 Жыл бұрын
@@CodingIsFun of course ! even tho your video helped alot. thanks Again.
@TL-ky5on Жыл бұрын
Hi, thank you so much for this solution. Does it still work and run in the background after the screen is auto locked?
@CodingIsFun Жыл бұрын
Thanks for watching. It still works, yet it is recommended to not switch screens while the bot/macro is running
@SaulEduardoo23 жыл бұрын
Very interesting tutorial Sven! 👌
@CodingIsFun3 жыл бұрын
Thank you! :)
@abdulsslamalshehri58183 жыл бұрын
@@CodingIsFun Is it still working these days?
@CodingIsFun3 жыл бұрын
@@abdulsslamalshehri5818 Yes, it is still working :)
@tcharlesstudio42193 жыл бұрын
Thank you very much for the information full of Valuable Content.
@CodingIsFun3 жыл бұрын
My pleasure, thank you for watching!
@sudeepsadan9 ай бұрын
Hello Sir, Thanks a lot for this support, is there a way to send to specific groups instead of numbers in this
@CodingIsFun9 ай бұрын
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! :)
@jpvale47212 жыл бұрын
Wonderful video! Congrats!
@CodingIsFun2 жыл бұрын
Thank you!
@johnandemmahall9062 жыл бұрын
Great video - unfortunately I get an Automation error when VB tries to execute the bot.start command. Any suggestions?
@CodingIsFun2 жыл бұрын
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender
@marcelmartinez51183 жыл бұрын
Excellent video, you are a great teacher. Any way to send qn image from the excel?
@CodingIsFun3 жыл бұрын
Thanks for watching the video and your kind words. While it is technically possible, this feature is not available in the current version. Sorry! 😕
@vasapratik4 ай бұрын
Smooth as butter, amaizing work! thanks for sharing. one question can i send Text and attachment together. ?
@CodingIsFun4 ай бұрын
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! :)
@vasapratik4 ай бұрын
@@CodingIsFun sorry but there is no FAQ for sending TEXT AND ATTACHMENT TOGETHER. - PLEASE HELP - THANKS
@kenechukwuobu82293 жыл бұрын
Your video is very informative and helpful. Thanks
@CodingIsFun3 жыл бұрын
*Thank you.* I am glad you enjoyed the video 😃
@violetsarehappy2 Жыл бұрын
Hi thank you for the video, does this work with google sheets instead of Excel?
@CodingIsFun Жыл бұрын
Thanks for watching. Nope, only Excel
@varunsritejakatikireddy96163 жыл бұрын
Excellent work bro !! Keep it up🔥🔥
@CodingIsFun3 жыл бұрын
Thank you. Glad you like it :)
@GenNextAnalyst2 жыл бұрын
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!
@CodingIsFun2 жыл бұрын
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.
@nnamdimusic13 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
*Hello Nnamdi Ogbonna, thanks for watching the video and your kind words.* In regards to your issue, do you get any error message?
@nnamdimusic13 жыл бұрын
@@CodingIsFun I don't get any error messages
@CodingIsFun3 жыл бұрын
@@nnamdimusic1 Could you try to increase the delay time in cell "H7", e.g. 7 seconds?
@nnamdimusic13 жыл бұрын
@@CodingIsFun ok, I'll try that, thanks so much for your response
@muhammadkashan6127 Жыл бұрын
can you please share me advanced version ?
@joeelite14743 жыл бұрын
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
@CodingIsFun3 жыл бұрын
*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.
@Luffy_04903 жыл бұрын
@@CodingIsFun kindly check this link & if possible please share this video link here
@mohammadjavadderakhshan66553 жыл бұрын
Thank You very much for sharing these tools. You saved my life
@CodingIsFun3 жыл бұрын
Thank you. I am happy to hear that :)
@srinivasaai2 жыл бұрын
Hi its an great content video, i got to learn something new, can we avoid messge box popping up everytime to scan the code?
@CodingIsFun2 жыл бұрын
Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender In that version, you have an option to save the login credentials. Feel also free to delete the message box. The source code is freely accessible
@kashanmuhammad3278 Жыл бұрын
.
@PG-zv3yy3 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
*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.
@PG-zv3yy3 жыл бұрын
@@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.
@CodingIsFun3 жыл бұрын
@@PG-zv3yy Thank you for the suggestions. If time permits, I will add those features.
@surewinsarena2 жыл бұрын
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
@CodingIsFun2 жыл бұрын
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
@limhanyang83033 жыл бұрын
Thanks for your video! Do you have a python version of this solution? :)
@CodingIsFun3 жыл бұрын
Thanks for watching. Sorry, I do not have a Python version of this solution.
@limhanyang83033 жыл бұрын
@@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!
@CodingIsFun3 жыл бұрын
@@limhanyang8303 Welcome aboard! I am happy to hear that you have been finding the videos enjoyable 😃
@maheshgudibande1080 Жыл бұрын
Very good information. Well explained. Keep going.
@CodingIsFun Жыл бұрын
Thank you!
@emyaqin3 жыл бұрын
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?
@CodingIsFun3 жыл бұрын
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?
@shubham1able2 жыл бұрын
@@CodingIsFun may because the second number was not registered on WhatsApp
@muhammadkashan6127 Жыл бұрын
can you please share me advanced version ?
@aba3li3 жыл бұрын
Amazing!, I am still using your advanced version, thanks alot
@CodingIsFun3 жыл бұрын
Thank you! I am glad you like the solution :)
@abdallahawawdeh17053 жыл бұрын
can you share the advanced version as it has been removed
@CodingIsFun3 жыл бұрын
@@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!
@aba3li3 жыл бұрын
@@abdallahawawdeh1705 Sorry, I can't
@muhammadkashan6127 Жыл бұрын
can you please share me advanced version ?
@canvardar24122 жыл бұрын
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
@CodingIsFun2 жыл бұрын
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
@canvardar24122 жыл бұрын
@@CodingIsFun The file name is abc but unfortunately it cannot be found. :(
@CodingIsFun2 жыл бұрын
@@canvardar2412 Then I do not have a solution
@kashanmuhammad32782 жыл бұрын
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.....
@CodingIsFun2 жыл бұрын
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!
@martindejager33852 жыл бұрын
Good day thanks for a great tutorial. Will this work for Edge? My company website only runs on Edge and not on Chrome
@CodingIsFun2 жыл бұрын
No, this only works with Chrome
@provreal13 жыл бұрын
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)
@CodingIsFun3 жыл бұрын
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
@gavrielsmith85323 жыл бұрын
@@CodingIsFun Thanks. I have tried adding it into your Advanced Version and fully tmrw but it does seem to be working.
@haileyshiyeu45343 жыл бұрын
amazing video! Saved a lot time, thank you so much
@CodingIsFun3 жыл бұрын
A pleasure, thanks for watching! 😃
@sameershraim2962 жыл бұрын
Great, amazing, and simple Thank you so much I have a question. Can I attach an image with the same message?
@CodingIsFun2 жыл бұрын
Yes, absolutely. Check our the template in the description!
@sameershraim2962 жыл бұрын
@@CodingIsFun Thanks a lot Good luck
@shironeko18492 жыл бұрын
Hello, thank you for the amazing video! It works perfect with me. I have a questions: my chrome currently running with 3 profile but the command pop out is from anonymous profile. How do I make the command to be specific for one of my profile only? Thank you!
@CodingIsFun2 жыл бұрын
Thanks for watching! This feature is currently not available.
@shironeko18492 жыл бұрын
@@CodingIsFun I have another question, can we add images with text too?
@CodingIsFun2 жыл бұрын
@@shironeko1849 That is possible. More details here: Excel WhatsApp BOT: pythonandvba.com/whatsappsender
@generalinformationbynasir2406 Жыл бұрын
Very good project well explained fully working Thanks
@CodingIsFun Жыл бұрын
Glad you like it! Thanks for watching and leaving a comment! :)
@caporalx2 жыл бұрын
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.
@CodingIsFun2 жыл бұрын
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.
@donnyjames2304 Жыл бұрын
Good stuff man!!!!...question....is there any limit to the number of contacts in list? What about 10,000?
@CodingIsFun Жыл бұрын
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! :)
@Deepesh1913 жыл бұрын
Wowsome video...!! Informative and helpful.
@CodingIsFun3 жыл бұрын
*I am glad you liked the video, thanks for watching and for the comment!*
@ashkar0073 жыл бұрын
Perfectly working. Simply cool. We are having a membership 1000+ in our association. Planning to send greeting,wishes, events details to membership. Will whatsapp ban the senders number?
@CodingIsFun3 жыл бұрын
*Hi Ashkar Ali Mubarak. I am glad you like the solution, thanks for watching and for the comment!* There is definitely a chance that your number will be blocked. I am not aware of a certain threshold (number of messages). In your case, you might want to have a look at the official WhatsApp API designed for business: www.whatsapp.com/business/api/?lang=en Have a great day 🤗 Cheers, Sven
@ashkar0073 жыл бұрын
Thanks mate
@pratikkarmakar3212 жыл бұрын
Wow... Thank u for sharing ur knowledge.... I want to use this for my school.. where I want to send whatsapp message for the new enquiry with a pdf and payments reminder (but the numbers are not saved)
@CodingIsFun2 жыл бұрын
Thanks, but this solution only works with saved numbers.
@vipinchavan2 жыл бұрын
Thanks a lot for the video, really amazing and very easy.. i am a non programmer still i was able to do it.. Thanks a ton once again. i have one question, why your BOT is not sending to unknown numbers, any solution please.
@CodingIsFun2 жыл бұрын
Glad you liked it. Thanks for watching.
@zhangzhengjian2 жыл бұрын
Maybe u can save the unknown number first by using google contact bulk import.
@kokkhienchia36663 жыл бұрын
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.
@CodingIsFun3 жыл бұрын
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.
@allaboutclickfunnels60543 жыл бұрын
It's excellent! And how can it be done so that when I finish a contact list it automatically follows with another WhatsApp account?
@CodingIsFun3 жыл бұрын
Thank you. I am glad you enjoyed the video. Technically it is possible. Once the first list is finished, you would need to open another Chrome instance (with the second Chrome Profile/WhatsApp Account) to continue with the rest of the list. Yet, this exact feature is not available in my solution (bit.ly/2Ojz9lX). However, as a semi-automated workaround, you could have two Excel Workbooks. In each workbook, you could set the Chrome Profile (as shown in the video below): 👉 kzbin.info/www/bejne/forPXpqcqcxsiNk In that case, you could, for instance, run the first workbook. Once done, you could trigger the macro from the second Workbook.
@NTainteD3 жыл бұрын
hi, great tutorial! is there a way to modify the excel file via php without losing the macros?
@CodingIsFun3 жыл бұрын
I have never manipulated an excel file using PHP. Hence, I am not sure if it will be the affecting the containing macro - sorry 😕
@MarketsWithForExim3 жыл бұрын
Hi, Can we send multiple keypress commands using selenium in VBA excel? For example: Ctrl + " V "
@CodingIsFun3 жыл бұрын
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
@MarketsWithForExim3 жыл бұрын
@@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!
@CodingIsFun3 жыл бұрын
@@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.
@mmacsimiliann10 ай бұрын
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.
@CodingIsFun10 ай бұрын
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! :)
@milankumar44183 жыл бұрын
Thanks so much Sir for this wonderful video. One question please: This code works only when the phone number in the contacts list - how can this code be modified to send messages to numbers on in my contacts list?
@CodingIsFun3 жыл бұрын
Thanks for watching the video. I have created a new version of the BOT & included additional features like sending messages to unsaved contacts. Feel free to check out the updated version: 👉 kzbin.info/www/bejne/oqWVqZutrMSqmac
@mohamedelsadek82093 жыл бұрын
@@CodingIsFun the video has been removed, could you please send another link
@allaboutclickfunnels60543 жыл бұрын
How good this! Is it possible to make it so that when the file is opened, the data is updated and then it runs automatically?
@CodingIsFun3 жыл бұрын
Thanks for your question. So, whenever the users input a new row/message, that the BOT starts automatically? This would be possible with the worksheet change event trigger: Worksheet_Change(ByVal Target As Range) Hope it gives you a starting point to customise the Workbook further :)