Great tutorial as usual with a comment and a suggestion. 1- (Comments), There’s a registry key that should be added to avoid annoying permission message with each send request. 2- (Suggestion), It’ll be better if the application can send customized picture or PDF. I did that and working as a charm. Thank you
Hi and thanks very much. PDF's is a great idea and also the registry key to disable the pop-up message, I checked out, and wanted to do it, however, i stayed with the more simple method for this training. I will explore more options within the Patreon update next week. Thanks so much for your continued support
Is there any chance for sharing how did u do it or post template because after i subscribe to channel to get excel and try it, there is error because my excel can not open macros.. so its pretty much useless...
Thanks Randy, you're among the greatest people i look up to each and everyday. I don't where your inspiration come from because everytime i watch your videos whether short or long, i learn something new. I'm like a "dry sponge" waiting for Tuesday in order to absorb life-changing tips and Tricks. Thanks so much, you're my mentor !
Thank you so very much, I really appreciate that Keita, you have been with me since the beginning and I really do appreciate it. So glad to help and share each and every week.
Hi and thanks so much. This is designed to work only with saved contacts so that you do not get in trouble with Facebook/Whatsapp with spamming non-contacts. I hope this helps and thanks so much.
Hii, sir Ayush this side you are really fantastic man because of you I get to know the power of excel and I am also learning excel please tell form your experiance what should I do for become like you I am waiting for you reply. Love from India ❤ Thank you 😊
Hi and thanks so much. I have several great courses available including a basic VBA from Dan Strong in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy Also my Mentorship course will teach you how to define, design, develop and deploy Excel-based application for passive income here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ Feel free to join us on Patreon for extra weekly workbooks and training here www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hello Randy, I am impressed with the content. I do not know how to thank you, but I am confused. There are many videos. Can you suggest a video or two or three that contain almost all the information that you provide? 😊😊
Hi and thanks so much. I am really glad you enjoy the content. I have a lot of videos, however it all depends on your goals, and what you want to learn or your eventual outcome. A great place to start is probably my 'From Scratch' playlist in which inside the videos I design the applications from scratch and often program them from scratch, during the video here: ru-vid.com/group/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb I hope this helps and thanks so much.
Hi Randy! Amazing info as always. If I enter the phone number, it finds the first thread with the phone number contained in it and sends to that user. For example, if I have sent the contact's phone number to Fred Fredders in a previous Whatsapp message, it will find that thread and send to Fred Fredders instead of to the number. if I use the contact's name as in the Contacts list, it works.
HI and thanks Phil. Thats a nice idea to use the name. I considered that but thought that the names had to be an exact match. It's a great update and thanks so much for sharing.
Hi and thanks give it a try and if you run into any issues, please post your issue details and code screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
hello sir, first of all accept my new year wishes, secondly you teach so well that it seems easy to do programming, lastly sir can i get the codes so that i may able to use the same
Thank you so very much, I really appreciate that You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi and thanks very much. You could actually send unlimited pictures. You could modify the code to loop through all of the pictures you want to send. Simply open each picture up, copy and paste it using the SendKeys method described during the video. You will also want to use AppActivate to activate either the Excel Workbook or the WhatsApp application to switch between the two windows when copying and pasting. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Randy, I just stumbled against your channel and this content is top notch. I was wondering if there was a way to send a *specific* photo a whastapp contact using this template?
Hi Jose, thanks so much. It may be possible using Copy and Paste, with sendkeys. Meaning if you have a picture in Excel and you copy that picture using the Senkeys Command in VBA then once you are in the Whatsapp, you may be able to use the Sendkeys to Paste it, with shortcut keys. I have not tested it out but it's worth a try. I hope this helps and thanks so much.
Hi and thanks very much. I have not tried that so I am not sure. You may want to request that in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hello and thank you so much for sharing the complete code template. I would like to ask if let supposed number is not registered on WhatsApp in that case the vba code in Module - SendWAMsg_Macros will not work properly. then how to handle that situation. so that the code works properly and sends messages to other numbers if I put that code inside a loop. Thank You
Hi and thanks so much. You would want to make sure every number is registered on WhatsApp first. if not, it could be considered spamming and WhatsApp may close your account. I hope this helps and thanks so much.
Hi Paul, thanks so much. It may be possible to copy and paste the link or the file itself. You may want to open the windows explorer and experiment with copying and pasting the file itself via Sendkeys. I hope this helps and thanks so much.
Hi Andy, This is super awesome. I have a challenge whereby sendkeys put the text in the VBA code, in the next line and not in WhatsApp. I can see that WhatsApp is activated. Must mention I am using WhatsApp Business. Does this work on WA Business?
Hi and thanks so much. This should work with any Desktop version of whatsapp. Make sure the Whatsapp application is visible on your desktop computer and not minimized and you can close the VBA window as well. I hope this helps and thanks so much.
Randy I had requested you for such a software sometime back. Happy that you complied 😊 May be a mere coincidence too😊Eagerly waiting for the première 👍🏻
Hi and thanks so much. I am happy to help and share Vikram. For sure not a coincidence, since i take notes of every request. I just wanted to make sure that I could bring a simple and straightforward training that is also powerful at the same time. I am sure you will enjoy it. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers hey sir you software are great I just want to add a little things that how I can attachment multiple files and sending to a single number is that possible. Please guide me. ❤
Thank you so very much, I really appreciate that AmazedExcel, I will do my best to address this on our Patreon update next week (www.patreon.com/ExcelForFreelancers ) I hope this helps and thanks so much.
Hi Christopher, it may be however I specifically used this with saved phone #'s since trying to send to multiple unsaved phone #'s could get your account suspended or closed by Whatsapp/Facebook as per terms of their TOS. I hope this helps and thanks so much
Randy, many thanks for making this. I got the template too. I tried it on my ancient windows 8 and it did not work because I cant download whatsapp for desktop. Then I tried it unsuccessfully on my wife's laptop but she uses microsoft excel online. Any suggestions? Also what do I need to do to get the fully automated schedule enabled version from you?
Hi and thanks so much Mike. You will want to make sure to use this on a computer running WIndows 10 or later, with the full version of Excel (not online version which does not allow macros) I hope this helps and thanks so much.
Thanks a lot Randy. That's very impressive training. However, I have a question on the the number to which the messages are sent. It's just one number if I am not mistaken. Is there a way to loop through then so that each message goes to specific person as specified in the message...? Once again I really salute your talents.
Hi and thanks so much. Yes certainly, if you use the Bulk Message option, and loop through all of the selected contacts, a customized message will be sent to each individual person, using their own number and their own name. I hope this helps and thanks so much.
Thanks Randy, this is a greatest video i ever seen, dear randy may you make a tutorial on "SENDING WHATSAP MESSAGES FROM GOOGLE SHEET", waiting for response from your side.
HI and thanks so much. It may be possible from Google Sheets however I exclusively work with Excel only. You can check some Google Sheet addins. I hope this helps and thanks so much.
Hi David, Thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
HI Randy. I absolutely love this, and other ideas you create for us vba novices. I have used this for my son's business which requires this type of regular reminder sending to his customers. He is having an issue however. He runs Windows 10, full version of excel, there are other macros I have built into his database to create customers and send invoices and they all run correctly. However when he attempts to send the WhatsApp message the macro runs but WhatsApp closes immediately and therefore doesn't send the message. The message then appears in whichever cell is selected on teh worksheet. WhatsApp is up to date, windows is up to date. Any ideas?
HI Phil, thanks very much for your comment and glad you like the training. Windows 10 with full version of Excel is also what i have, so that should not be a problem. Make sure the desktop version of Whatsapp is up to date, then try to put in some more delays in the code so you can watch and follow along. Perhaps you have an incorrect shortcut key or tab. Also, manually, go through the steps using your keyboard only. Also make sure that the WhatsApp window is in back (and not minimized) I hope this helps and thanks so much.
HI and thanks very much. You will want to make sure that Whatsapp is installed, opened and active on your desktop (make sure its not minimized) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Randy you are doing excellent work. Can you please develop an application in which Fertilizers product sales to Dealers then track their purchased Fertilizer different brands consumption in field to end user farmers by assigned company representatives to dealers.
Hi and thanks so much. This would be a niche, custom application. To get help with this please post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks so much. You will want to make sure all contacts and phone numbers are confirmed before running the macro. If you send messages to non-contacts, Whatsapp could shut down your account if its too much I hope this helps and thanks so much.
Hi and thanks so much. The technique you will learn in this video would work for any desktop messaging system. I am sure you are going to like it. Thank you for your Likes, Shares & Comments. It really helps.
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time, since I get literally hundreds of request for help per day. However, I have created a Facebook group with 60,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
thanks its amazing way to send messages. but I have a problem which is if I add phone number but this number doesn't have WhatsApp app in this case the sending massages system will stop .I want to add some codes to force the messages system to skip phone number doesn't have WhatsApp and go to the next one.
Hi and thanks very much. You will want to make sure that all numbers you add are already in your Whatsapp contact list. This will avoid having your whatsapp closed down due to spam. I hope this helps and thanks so much.
Amazing Work, but i'm just struggling to add a pdf instead of a picture. I've tried to work with the code, but can't find the path that nees to be switched. Can someone help me with my issue?
Hi and thanks its best to copy & paste a download link instead of the actual PDF. I show you how to generate a download link in this training: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lHT0u2zFBoQ.html I hope this helps and thanks so much.
Looks super. I’m just working through this but when I put my number is cell a1 it doesn’t send it to me. It picked my first group, oops 😅 good job it wasn’t too important a group 😂 what format do I need the number in?
HI and thanks very much. You would probably want to enter the phone # without any format, and it should find you directly without the group if you are saved in contacts and should be the first one found. I hope this helps and thanks so much.
If I enter the phone number, it finds the first thread with the phone number contained in it and sends to that user. For example, if I have sent the contact's phone number to Fred Fredders in a previous Whatsapp message, it will find that thread and send to Fred Fredders instead of to the number. if I use the contact's name as in the Contacts list, it works.@@ExcelForFreelancers
Hey thanks for this tutorial! But i have a basic query! I need to send my WhatsApp campaigns to more than 20000 members everyday with all the emojis and media links and photos intact. Is it possible for me to carry out through this?
You would have to get a Business Account Pre-approved from Whatsapp/Facebook and use the API. So please apply for a business account. I hope this helps and thanks so much.
thanks for your content, I received "Invalid procedure call or argument" I am wondering whether is has to do with the enter button , because I manage to get the text in the draft section on whatssap to the right phone number, but I didn't get it send(press enter). that stage didn't execute.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
May I check - i'm running a test on a brand new whatsapp business account - since there are no existing chats, it's not registering the numbers to send to... is there a way to fix this?
HI and thanks so much for your comment. I will want to make sure that all contacts have already been added to the account before attempting to send messages to them. I hope this helps and thanks so much.
Hi randy.. please solve my problem I have download employee payroll excel sheet it's very amazing work 💗 but it's one problem print button can't working and not micro available this sheet please please 🙏 solve the problem I'm very thankful for you 💗 Iam waiting for your positive response
Hi and thanks for your comment. I have added the Print Pay Periods feature on our Patreon Platform post here: www.patreon.com/posts/employee-payroll-88009764 I hope this helps and thanks so much.
I am sorry as that would be very unfair to everyone who is actively paying for a subscription. This is how I keep these trainings free. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks so much. Using my system, they won't consider this spam because of a few reasons 1) it mimics human behavior 2) You can only send to existing contacts, and 3) It's not fast enough to alert WhatApp of any issues. I hope this helps and thanks so much.
Hi and thanks so much. I did not have a solution for that however its possible to use Sendkeys with the webapp although I have not tried, if it is the open tab in your browser, using shortcut keys. It may be time to update to windows 10 since you will always be struggling to find a solution. I hope this helps and thanks so much.
Yes for sure there is a risk. You should make sure to send to only people who have approved your messages and not to abuse the automation. I hope this helps and thanks so much.
@@ExcelForFreelancers agreed thanks. I guess the problem arises if someone reports you. But in terms numbers, what's your best guess? Don't send more than a 1000?
I really don't know however you can check the Facebook/WhatsApp Terms Of Service and they may outline the limits there. I think its more about time. So my best guess would be around 30 per hour to be safe but i am completely guessing with no real data.
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Does it still work ? Whatsapp changed alot, im getting random faults, its sending smileys , multiple times to same contacts and randomly selecting contacts. Tried with another version office. im using microsoft 365 and whatsapp bussiness.
Hi and thanks so much. I have not returned to this template since creating the video. Please make sure to step through the code using F8 and make any necessary modifications. If you need help, or have questions, please post then in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks so much for your purchase. You can download this template from the following link if you were not able to get it: www.dropbox.com/scl/fi/vnexey7o0hadh8pgjbku1/WhatsApp_Automated_Messaging.xlsm?rlkey=uj80fqywsctp1xfvh54arzkyr&dl=1 I hope this helps and thanks so much.
Yes sure, i show you how to do an advanced filter in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yQhQ4yjv8Yk.html I hope this helps and thanks so much.
Hi and thanks very much. I do have an entire training on that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-M71kllagKzw.html I hope this helps and thanks so much.
Hi and thanks very much for your comment. I would download the Viber for desktop application and look for the keyboard shortcuts, just as I do for the Whatsapp and give it a try through the Sendkeys method as I explain in this training. I hope this helps and thanks so much.
Good Day Randy I am doing something wrong. The message start in whatapp then streight went to google and did not complete the whatapp. i had 2 sucessfull attempts but messed up some where i downloaded again your file and tried a couple of times with no sucess..please assist
Hi Angel, thanks for your email. You want to make sure you have WhatsApp application installed on your machine (and make sure it is not minimized. If it is minimized on your desktop it could create issuess) Next up you would want to slow down the code by adding more time to the Wait Now statements, so you can see what the issue is. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
What if the Phone Number is not valid for WhatsApp? My users provide a phone number, but not necessarily have WA associated to the number. Is there a way to validate it?
HI and thanks very much. You would want to make sure that all phone #'s used with this application have verified phone #'s and WhatsApp accounts, otherwise it could be considered spamming and it goes against their terms of service. I hope this helps and thanks so much.
Hi and thanks. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet automatically. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hello, thanks for the video, I just downloaded the file, I have a question: how can I send several messages at the same time but not all of them be sent at the same time? That is, wait a few seconds and send the next one. I have tried some options that I didn't like at all, but I remember that I can make a "delay" of seconds for each message to be sent. This is very important so that WhatsApp does not block the account for detecting spam. It is possible that your file has this option but since I am a newbie I don't know where the option is, thank you very much for everything. ps: I am a freelancer who is just starting out (due to my age 50+) I am no longer hired by companies but I have a lot of experience and knowledge, so I am trying to be a freelancer.
HI David, thanks for your comment and message. You can add a wait time within the code, before the 'Next' line, in order to wait before moving to the next record. Something like Application.Wait Now + TimeValue("00:00:03") this would add 3 seconds of wait time before moving to the next line of code. I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks for your response, sorry I am not a expert on Visual Basic, just a little, but I understanding that you suggest to edit "SendWAMsg_macros" module, and add a line before "NEXT" LINE , and I can't see any "next" code on this module, may you help me please? thanks in advance
HI and thanks if you are looping through multiple contacts, you would want to have the wait line before it goes to the next contact. I hope this helps and thanks so much.
@@ExcelForFreelancers Hi there again, my apologies but I'm newbie on this and I can´t find where exactly i need to insert this new command ~ Application.Wait Now + TimeValue("00:00:03") ~ in order to wait extra time before to send a message to the next one contact. May you help me please where exactly I need to do that?, which module and after which line please... 🙏 Thanks
Hi and thanks you can put this anywhere in the macro that sends the message. Please make sure to watch the entire training. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi and thanks for your comment. It would be best to send a download with a PDF, and you can create a Download link from this video training: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qeQmrADtFjw.html I hope this helps and thanks so much.
Hi and thanks very much> I have not used Arabic inside a text box so please check with your language pack version in Excel. I hope this helps and thanks so much.
Hi and thanks for your message. Yes sure, nearly anything is possible with customizations. Please feel free to download the template and customize it however you like. I hope this helps and thanks so much.
You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
"cannot run the macro, the macro might not be available in this workbook or all macros may be disabled" this message keeps popping what shall i do. please help
Hi and thanks. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
HI and thanks in that case you can use SMS Messages. I have a training on that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V11uDrUYUPw.html I hope this helps and thanks so much.
And how to handle wrong whatsapp number , if by chance we put wrong number they perform anomaly .if there is checking system that can check person are available or not , then skip their contact number function as not found
Hi and thanks very much. You will want to make sure all phone #'s are verified whatsapp users, before entering the system. I hope this helps and thanks so much.
Hi and thanks so much. You will want to make sure the picture file path is correct. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi and thanks for your comment. You will want to first make sure all numbers are in your contact list, otherwise it might be considered as spam and your Whatsapp account could be banned. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks so much. You can download this file using the links in the description under the word DOWNLOAD. This will allow you to change any VBA code. I hope this helps and thanks.
Hi and thanks for your comment. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hello! I am very happy to share the news that I have created this training for you and it will be premiered this Tuesday September 12th. Please make sure to Like & Share it here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ScUBSfEqcrY.html
HI and thanks for your email. You can reverse the statements within the code so that the picture is pasted first. Please make sure to watch the entire training video where I explain the code in detail. I hope this helps and thanks so much.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks for your comment. You would probably need to use the WhatsApp API for this, as I don't think you could do it with the Sendkeys method. I hope this helps and thanks so much.
Hi and thanks you can check out my 300 workbook template zip file here bit.ly/300WkBks_Randy Or my mentorship here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
Hi and thanks that would be considered spam and Whatsapp will probably close your account so its important to add the names first. I hope this helps and thanks so much.
I have 1 Doubt, What if I have a list of numbers to send messages, and someone is not on WhatsApp or they had deleted the account is error handling is there?
Hello! I am very happy to share the news that I have created this training for you and it will be premiered this Tuesday September 12th. Please make sure to Like & Share it here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ScUBSfEqcrY.html