How To Send WhatsApp Messages From Excel Using VBA (Free & Easy) 📲

[@CodingIsFun]

*Download the template here:* pythonandvba.com/whatsapp-bot *Check out the Docs/FAQ here:* pythonandvba.com/whatsapp-faq

[@allantechnology]

how i can do that for groups ?

[@CodingIsFun]

@@allantechnology It also works for Groups. Instead of the number, just provide the name of the group chat in column A.

[@allantechnology]

@@CodingIsFun bot.Start "chrome", "web.whatsapp.com/" i have error in this code

[@CodingIsFun]

@@allantechnology Could please let me know the error message or even better, upload the error message here: prnt.sc/ ? Thank you.

[@gabrielfds3461]

Amazing video! Straight up, accurateness and very understandable. Thank you for that!

[@CodingIsFun]

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?

[@pksswad4836]

Implemented it for VB6. Straight in one single shot, no bugs.... working like magic. Many many thanks

[@CodingIsFun]

Fantastic! Thanks for watching the video and taking the time to leave a comment.

[@nimrod6661]

hey ! can u send me the code and the excel file please ? something dont work for me

[@RobinsonMakwana-wi3ul]

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. 👍

[@VijayInani]

You rocked !!! Too good !!! Super easy and very well explained. And MAINLY IT WORKS :D ...!!! Kudos..

[@CodingIsFun]

Thank you! 🎉🎉

[@VijayInani]

How can I export all WhatsApp contacts from my android device? All the apps are paid or buggy. Any script or quick help?

[@CodingIsFun]

@@VijayInani sorry, I do not have a solution for that

[@VijayInani]

@@CodingIsFun I used a paid app for it.

[@sanketkatariya4322]

Thankyou so much for the simplified tutorial. It saved so much of time and manual work. Thanks buddy! 🙌🏻

[@CodingIsFun]

A pleasure! Glad to hear that the solution is helpful!

[@sanketkatariya4322]

@@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 !!!

[@CodingIsFun]

@@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!

[@healurselfcuzin]

@@CodingIsFun thanks for all your efforts. Really bringing lot of value to the community. Have a nice day sir

[@CodingIsFun]

@@healurselfcuzin Thanks for your kind words! 😃

[@ermalgashimramori]

Your tutorials are very professional and very useful. Keep up the good work.

[@CodingIsFun]

Thank you so much for your support! 🙏

[@misterrozz4655]

@@CodingIsFun sir my account bngd.. help me pls

[@Yaroslafff]

I have no idea yet if it works, but grand thanks for the easy style of tutorial, love it really

[@CodingIsFun]

Thanks! Ensure to download and use the latest template: pythonandvba.com/whatsappsender Happy Sending!

[@Yaroslafff]

@@CodingIsFun Having drinks as a Russian style assumes weekends :) Will definetely check it out.

[@CodingIsFun]

@@Yaroslafff Happy Drinking!

[@Yaroslafff]

@@CodingIsFun Yeahh!!

[@Yaroslafff]

@@CodingIsFun The very different content, will you accept the link to music?

[@englishtree2717]

thanks a lot , it works pretty well.... I am Arun from Kerala, and Iam a teacher.

[@CodingIsFun]

Hi Arun. Thanks for your feedback. Glad it is working fine. Greetings to Kerala! :)

[@pareezcc3779]

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.

[@CodingIsFun]

Thank you, it means a lot!

[@pamkmollinedo8252]

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

[@radikutoyo]

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

[@computal]

i know but its don't let me to write the messageb.

[@almol7981]

This was a very helpful video. I'm a beginner programmer and i can say i had a lot of fun doing this.

[@CodingIsFun]

Glad you liked the video. Thanks for watching and taking the time to leave a comment :)

[@Yaroslafff]

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.

[@CodingIsFun]

Fantastic! Happy to hear that everything is working! 👍

[@euchariaokoli6152]

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

[@CodingIsFun]

*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

[@vineetsharma8261]

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.

[@CodingIsFun]

*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 ✌

[@vineetsharma8261]

@@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!

[@vineetsharma8261]

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.

[@CodingIsFun]

@@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.

[@CodingIsFun]

@@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 🙏

[@zatak3689]

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

[@CodingIsFun]

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

[@luxon2444]

instead of using line breaks use the proper line break format for whatsapp. that is using '|' character instead of or .

[@lunag1962]

@@CodingIsFun does the pipe symbol still work? It just gets printed out on mine

[@rajkumarvishwakarma7744]

@@CodingIsFun I entered in text but paragraph no getting change plz help

[@CodingIsFun]

@@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! :)

[@GarfieldRoss]

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?

[@CodingIsFun]

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!

[@GarfieldRoss]

@@CodingIsFun That's what it was!!!! thank you so much

[@tracyngu6698]

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!

[@CodingIsFun]

Yes, that is possible. In the template, you can find an example of how to send images. Download the template here: pythonandvba.com/whatsappsender

[@tracyngu6698]

@@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

[@ashwaqahmed5646]

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.

[@CodingIsFun]

Thanks for watching the video & your comment :)

[@biacarniel]

Just did it and it still works! Great video, thank you

[@CodingIsFun]

Nice! Glad you like the solution! -Sven ✌️

[@risenacademy189]

How do you prevent your number from being flagged for spamming?

[@CodingIsFun]

@@risenacademy189 Please have a look here: docs.pythonandvba.com/whatsappblaster/guides/how-to-minimize-the-risk-of-getting-banned-on-whatsapp Cheers, Sven ✌

[@AvinashKumar-xj8dp]

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

[@CodingIsFun]

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-xj8dp]

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

[@CodingIsFun]

@@AvinashKumar-xj8dpI have never came across this kind of issue. Hence, I don't have a solution to this

[@bainwave9278]

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

[@CodingIsFun]

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 ✌️

[@stevethorne44]

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]

That sounds possible, but obviously requires some lines of code ;)

[@stevethorne44]

@@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]

@@stevethorne44 Probably not because of my current workload.

[@stevethorne44]

@@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.

[@CodingIsFun]

@@stevethorne44 Happy Coding!

[@sawan78]

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.

[@CodingIsFun]

*Hi sawan78. I am glad you liked the video; thanks for watching and for your kind words!* Welcome aboard! 😃

[@yashwanthj5847]

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

[@CodingIsFun]

*I am glad to hear you are enjoying them, thanks for watching and for the comment!*

[@huffadzgemmaindonesia9512]

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!

[@CodingIsFun]

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.

[@huffadzgemmaindonesia9512]

@@CodingIsFun Thanks for the reply!

[@francinelandim3541]

This video is amazing! Congrats! You rock!

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it.

[@christianagulueokoye7847]

Wow! Fantastic video, well explained. You got a new subscriber. .

[@CodingIsFun]

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! :)

[@nayeemkader3884]

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?

[@nayeemkader3884]

By reply i mean auto reply. Thanks again

[@CodingIsFun]

@@nayeemkader3884 Thank you. No, that is not possible

[@davidho1019]

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.

[@CodingIsFun]

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: [e-mail]

[@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! :)

[@adityapalwankar1386]

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?

[@CodingIsFun]

Thank you. No, that is not possible

[@adityapalwankar1386]

@@CodingIsFun Thanks for that, another quick question can I make my message dynamic using the excel column formula? Like Msg with custom names?

[@CodingIsFun]

@@adityapalwankar1386 Yes, that is possible. I suggest downloading the template from the description and just testing it out :)

[@zatak3689]

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?

[@CodingIsFun]

www.screencast.com/t/Jhjhw3NfbXt

[@zatak3689]

@@CodingIsFun sorry i didn't get it. 😥

[@zatak3689]

Its just a picture. No codes are there . Am i missing something?

[@CodingIsFun]

@@zatak3689 Download the Excel file from the description!! This feature is already implemented!

[@vinaysyt]

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?

[@CodingIsFun]

As described on the website (pythonandvba.com/whatsappsender), you can try to use the pipe symbol: www.screencast.com/t/oRnKSVXXw4

[@vinaysyt]

@@CodingIsFun Thank you so much

[@felipecortes9525]

Thanks a lot. Very good video, thanks for explain the programming. Greetings from Chile.

[@CodingIsFun]

*Gracias por ver mi video* 😀

[@TheGamarraFamily]

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

[@CodingIsFun]

Thanks for the positive feedback. Have a look here at how to insert paragraphs: pythonandvba.com/whatsappsender

[@priyanthagamini3860]

This video is excellent & very understandable. Can you Please explain how to send (Free) bulk messages (Payslip, PDF Attachment) with Excel VBA

[@CodingIsFun]

Thanks for watching. It is all explained in the free template. You can download it for free here: pythonandvba.com/whatsappsender

[@marmikupadhyay492]

Your explanation skills are extra ordinary ... I am very grateful!!! I can not access your website though.

[@CodingIsFun]

Thanks for your kind words! The website had a short downtime. You should be able to access it now.

[@mohamedhnfy]

Okay That's straight and really cool .. but any ideas for sending messages to contacts not included in your contact list??

[@CodingIsFun]

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.

[@mohamedhnfy]

@@CodingIsFun Okay again .. I'm going to google for it .. by the way you and your videos are astounding .. keep going bro 👌🏻👍🏻

[@CodingIsFun]

@@mohamedhnfy Thank you :)

[@barbaraisadora7185]

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?

[@CodingIsFun]

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!

[@lancerichard7120]

Thank you for this excellent tutorial. Is it possible rather than text to send an image?

[@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/whatsapp-bot/#FAQ I hope it helps! :)

[@rogerfederer9639]

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!

[@CodingIsFun]

To avoid scanning the QR Code every time you are using the BOT, you can use the following solution: kzbin.info/www/bejne/forPXpqcqcxsiNk

[@sertugbaysin]

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!

[@sertugbaysin]

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

[@CodingIsFun]

@@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 🙏

[@sertugbaysin]

Thank you mate. Appreciated 🤝🙂

[@elvinlee5346]

Thanks for this wonderful video. Really helpful. How about if I want to send a picture instead of text? Cheers

[@CodingIsFun]

Thanks for watching. Yes, it is possible. Please download the template from the description.

[@bennyfrancis8767]

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?

[@CodingIsFun]

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!

[@bennyfrancis8767]

@@CodingIsFun Thank you again, will dig into it. Please keep the tutorials coming!

[@johnpaularellano1003]

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

[@pietermalan2630]

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! 👍😍

[@andreadalfarra6454]

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.

[@CodingIsFun]

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!

[@maurod6180]

THANKS!!!! I tried and it worked!! only for fun purposes!

[@CodingIsFun]

Cheers for the feedback! It's always welcome! 👍

[@alhadithigroup6727]

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?

[@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! :)

[@umarabid5378]

Pro level detail video 💯💯 Very very good video

[@CodingIsFun]

Thanks 😍

[@umarabid5378]

@@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

[@SaulEduardoo2]

Very interesting tutorial Sven! 👌

[@CodingIsFun]

Thank you! :)

[@abdulsslamalshehri5818]

@@CodingIsFun Is it still working these days?

[@CodingIsFun]

@@abdulsslamalshehri5818 Yes, it is still working :)

[@tcharlesstudio4219]

Thank you very much for the information full of Valuable Content.

[@CodingIsFun]

My pleasure, thank you for watching!

[@sudeepsadan]

Hello Sir, Thanks a lot for this support, is there a way to send to specific groups instead of numbers in this

[@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! :)

[@jpvale4721]

Wonderful video! Congrats!

[@CodingIsFun]

Thank you!

[@johnandemmahall906]

Great video - unfortunately I get an Automation error when VB tries to execute the bot.start command. Any suggestions?

[@CodingIsFun]

Thanks for watching. Are you using the latest version? You can download it for free here: pythonandvba.com/whatsappsender

[@marcelmartinez5118]

Excellent video, you are a great teacher. Any way to send qn image from the excel?

[@CodingIsFun]

Thanks for watching the video and your kind words. While it is technically possible, this feature is not available in the current version. Sorry! 😕

[@vasapratik]

Smooth as butter, amaizing work! thanks for sharing. one question can i send Text and attachment together. ?

[@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/whatsapp-bot/#FAQ I hope it helps! :)

[@vasapratik]

@@CodingIsFun sorry but there is no FAQ for sending TEXT AND ATTACHMENT TOGETHER. - PLEASE HELP - THANKS

[@kenechukwuobu8229]

Your video is very informative and helpful. Thanks

[@CodingIsFun]

*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

[@varunsritejakatikireddy9616]

Excellent work bro !! Keep it up🔥🔥

[@CodingIsFun]

Thank you. Glad you like it :)

[@GenNextAnalyst]

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!

[@CodingIsFun]

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.

[@nnamdimusic1]

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.

[@CodingIsFun]

*Hello Nnamdi Ogbonna, thanks for watching the video and your kind words.* In regards to your issue, do you get any error message?

[@nnamdimusic1]

@@CodingIsFun I don't get any error messages

[@CodingIsFun]

@@nnamdimusic1 Could you try to increase the delay time in cell "H7", e.g. 7 seconds?

[@nnamdimusic1]

@@CodingIsFun ok, I'll try that, thanks so much for your response

[@muhammadkashan6127]

can you please share me advanced version ?

[@joeelite1474]

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

[@CodingIsFun]

*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_0490]

@@CodingIsFun kindly check this link & if possible please share this video link here

[@mohammadjavadderakhshan6655]

Thank You very much for sharing these tools. You saved my life

[@CodingIsFun]

Thank you. I am happy to hear that :)

[@srinivasaai]

Hi its an great content video, i got to learn something new, can we avoid messge box popping up everytime to scan the code?

[@CodingIsFun]

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-zv3yy]

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.

[@CodingIsFun]

*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-zv3yy]

@@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.

[@CodingIsFun]

@@PG-zv3yy Thank you for the suggestions. If time permits, I will add those features.

[@surewinsarena]

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

[@CodingIsFun]

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

[@limhanyang8303]

Thanks for your video! Do you have a python version of this solution? :)

[@CodingIsFun]

Thanks for watching. Sorry, I do not have a Python version of this solution.

[@limhanyang8303]

@@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!

[@CodingIsFun]

@@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!

[@emyaqin]

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?

[@CodingIsFun]

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?

[@shubham1able]

@@CodingIsFun may because the second number was not registered on WhatsApp

[@muhammadkashan6127]

can you please share me advanced version ?

[@aba3li]

Amazing!, I am still using your advanced version, thanks alot

[@CodingIsFun]

Thank you! I am glad you like the solution :)

[@abdallahawawdeh1705]

can you share the advanced version as it has been removed

[@CodingIsFun]

@@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!

[@aba3li]

@@abdallahawawdeh1705 Sorry, I can't

[@muhammadkashan6127]

can you please share me advanced version ?

[@canvardar2412]

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

[@CodingIsFun]

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

[@canvardar2412]

@@CodingIsFun The file name is abc but unfortunately it cannot be found. :(

[@CodingIsFun]

@@canvardar2412 Then I do not have a solution

[@kashanmuhammad3278]

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.....

[@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!

[@martindejager3385]

Good day thanks for a great tutorial. Will this work for Edge? My company website only runs on Edge and not on Chrome

[@CodingIsFun]

No, this only works with Chrome

[@provreal1]

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)

[@CodingIsFun]

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

[@gavrielsmith8532]

@@CodingIsFun Thanks. I have tried adding it into your Advanced Version and fully tmrw but it does seem to be working.

[@haileyshiyeu4534]

amazing video! Saved a lot time, thank you so much

[@CodingIsFun]

A pleasure, thanks for watching! 😃

[@sameershraim296]

Great, amazing, and simple Thank you so much I have a question. Can I attach an image with the same message?

[@CodingIsFun]

Yes, absolutely. Check our the template in the description!

[@sameershraim296]

@@CodingIsFun Thanks a lot Good luck

[@shironeko1849]

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!

[@CodingIsFun]

Thanks for watching! This feature is currently not available.

[@shironeko1849]

@@CodingIsFun I have another question, can we add images with text too?

[@CodingIsFun]

@@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! :)

[@caporalx]

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.

[@CodingIsFun]

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! :)

[@Deepesh191]

Wowsome video...!! Informative and helpful.

[@CodingIsFun]

*I am glad you liked the video, thanks for watching and for the comment!*

[@ashkar007]

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?

[@CodingIsFun]

*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

[@ashkar007]

Thanks mate

[@pratikkarmakar321]

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)

[@CodingIsFun]

Thanks, but this solution only works with saved numbers.

[@vipinchavan]

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.

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@zhangzhengjian]

Maybe u can save the unknown number first by using google contact bulk import.

[@kokkhienchia3666]

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.

[@CodingIsFun]

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.

[@allaboutclickfunnels6054]

It's excellent! And how can it be done so that when I finish a contact list it automatically follows with another WhatsApp account?

[@CodingIsFun]

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.

[@NTainteD]

hi, great tutorial! is there a way to modify the excel file via php without losing the macros?

[@CodingIsFun]

I have never manipulated an excel file using PHP. Hence, I am not sure if it will be the affecting the containing macro - sorry 😕

[@MarketsWithForExim]

Hi, Can we send multiple keypress commands using selenium in VBA excel? For example: Ctrl + " V "

[@CodingIsFun]

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

[@MarketsWithForExim]

@@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!

[@CodingIsFun]

@@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.

[@mmacsimiliann]

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.

[@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! :)

[@milankumar4418]

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?

[@CodingIsFun]

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

[@mohamedelsadek8209]

@@CodingIsFun the video has been removed, could you please send another link

[@allaboutclickfunnels6054]

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?

[@CodingIsFun]

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 :)