How to Send Bulk WhatsApp Messages & Pictures From Excel [Coded From Scratch + Free Template]

Рет қаралды 50,753

Күн бұрын

😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
This highly requested training is here where I walk you step by step how to create your own WhatsApp Bulk Messaging System from Excel. Send one or multiple messages to WhatsApp In Just 1 Click.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE: bit.ly/WtsAppAuto_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
0:28 - Overview
6:41 - Send One WhatsApp Message
19:21 - Refresh Bulk Message
19:43 - Send Selected Contacts To WhatsApp
31:27 - WhatsApp Template Message
35:36 - Selection Change Event
36:14 - Load Messages
37:11 - Load List Messages
37:49 - Browse for Picture
38:07 - Save and Update Message
40:02 - Delete Message
41:50 - Schedule Send WhatsApp Message
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#ExcelToWhatsapp #WhatsApp #BulkWhatsAppMessages #ExcelMessagesToWhatsApp

Пікірлер: 235

@ExcelForFreelancers 2 ай бұрын

🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom

@mukhtarabebefe7596 5 ай бұрын

People dont know the value of this training. THANK YOU SO MUCH. You are literally helping every startup save advertisement and feedback cost

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome and I am happy to help and share

@keitamoussa2229 9 ай бұрын

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 !

@ExcelForFreelancers 9 ай бұрын

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.

@slminc 9 ай бұрын

I like this🎉

@heljodedor5913 9 ай бұрын

Thanks Randy for your work and effort. Great!

@ExcelForFreelancers 9 ай бұрын

For sure, you are very welcome and thanks so much for your continued support

@SyedMuzammilMahasanShahi 9 ай бұрын

Thanks Randy for this amazing video.

@ExcelForFreelancers 9 ай бұрын

For sure, you are very welcome Syed. I am so glad you enjoyed it

@VS-rh8rq 10 ай бұрын

Waiting for this! Thanks

@ExcelForFreelancers 10 ай бұрын

Great, thanks so much. I am sure you will love it.

@tarekhasan8093 9 ай бұрын

You are such an amazing person I have learned many things from you... Love from Bangladesh❤❤❤

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that and happy to help and share

@sajanjohn7545 2 ай бұрын

Waiting for it ! Great Effort

@ExcelForFreelancers 2 ай бұрын

Thank you so very much, I really appreciate that

@muhammadmahmood6986 9 ай бұрын

You are the real beast..... Sorry but this how your work is... I mean, this next level... Keep it up!

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that Muhuammad, very kind of you and I really appreciate that

@VikramBhatilovekodial 9 ай бұрын

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

@ExcelForFreelancers 9 ай бұрын

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.

@AmazedExcel 9 ай бұрын

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

@ExcelForFreelancers 9 ай бұрын

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.

@user-mn9wc1pr1t 9 ай бұрын

Wow, I can't wait to code for this!

@ExcelForFreelancers 9 ай бұрын

Great, thanks so much. I will be writing a good amount of this code during the video, so you won't miss a step. Thanks again

@AyushmanThakur-mo3ee 9 ай бұрын

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 😊

@ExcelForFreelancers 9 ай бұрын

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.

@tedljong2280 5 ай бұрын

Thank you for a great video.

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

@abdullahquhtani4247 9 ай бұрын

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

@ExcelForFreelancers 9 ай бұрын

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

@bojanlekic9830 9 ай бұрын

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

@ExcelForFreelancers 9 ай бұрын

Hi @bojanlekic9830, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

@user-sw2pn9gq7q 8 ай бұрын

@@ExcelForFreelancers please share ive sent you email

@coolsadi4597 7 ай бұрын

Hi abdullah can you please share that part of code where you can send pdf or any pictures as you said thanks

@agrawalchirag 9 ай бұрын

Eagerly waiting 😊

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that. Join us for Live Chat if you can when the video launches

@rase1993 9 ай бұрын

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? 😊😊

@ExcelForFreelancers 9 ай бұрын

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: kzfaq.info/sun/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb I hope this helps and thanks so much.

@user-qt8zf2kk2r 5 ай бұрын

thx sir, it was useful

@ExcelForFreelancers 5 ай бұрын

You are welcome and thank you for your Likes, Shares & Comments. It really helps.

@MuhammadNaeem-wy9zt 9 ай бұрын

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.

@ExcelForFreelancers 9 ай бұрын

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.

@DanishAbbas07 9 ай бұрын

Amazing & wholesome content 🔥 Learning from paksitan 🇵🇰

@ExcelForFreelancers 9 ай бұрын

Great, thanks so much. I am happy to help and share

@PhilMaund-vx4lm 9 ай бұрын

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.

@ExcelForFreelancers 9 ай бұрын

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.

@coolsadi4597 8 ай бұрын

Hi dear, Can you guide me how you do by name instead of number

@ExcelForFreelancers 8 ай бұрын

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.

@alikhan-zz5jc 9 ай бұрын

Excellent

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that

@excelprofessional8505 9 ай бұрын

❤Thank You Sir

@ExcelForFreelancers 9 ай бұрын

For sure, you are very welcome. I am happy to help and share

@user-hu5kp5yy9e 9 ай бұрын

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.

@ExcelForFreelancers 9 ай бұрын

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.

@prettyme3550 2 ай бұрын

Hi this is amazing tool thank you very much Does this work only for saved contacts or it will work even if it is a fresh contact that is not saved.

@ExcelForFreelancers 2 ай бұрын

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.

@haroldluciano5203 9 ай бұрын

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.

@ExcelForFreelancers 9 ай бұрын

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.

@augustosenna 9 ай бұрын

Awesome!!! I can do that with google sheets, my friend?

@ExcelForFreelancers 9 ай бұрын

HI and thanks, it may be possible however my Excel solution is extremely streamlined so you may want to use Excel for this. I am sure you will love the training. Make sure to set your reminder and Like the video. Thank you for your Likes, Shares & Comments. It really helps.

@osamasaid8476 9 ай бұрын

thanks

@ExcelForFreelancers 9 ай бұрын

For sure, you are very welcome. I am happy to help and share

@SolutionsByPVV 10 ай бұрын

Andy, I'll be waiting for that! Also interested in Excel & ( Viber || Telegram ) bundle.

@slminc 10 ай бұрын

Telegram is easy

@ExcelForFreelancers 9 ай бұрын

Great thanks so much. I am sure you will like this training

@user-qt8zf2kk2r 5 ай бұрын

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

@ExcelForFreelancers 5 ай бұрын

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.

@daviderojas Ай бұрын

Hi there... it is possible to add another custom variables on the message as [ContName] , may you help me how to add it? thanks a lot

@ExcelForFreelancers Ай бұрын

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.

@christopherroxas23 9 ай бұрын

Thanks Randy. Is it possible to apply this to unsaved phone numbers? Thank you in advance

@ExcelForFreelancers 9 ай бұрын

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

@learnbahrainiarabic 9 ай бұрын

Hello Randy, Great Job Is it possible to send multiple pics ?as per excel file we can send only one file?

@ExcelForFreelancers 9 ай бұрын

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

@JoseHerrera-ph1ns 26 күн бұрын

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?

@ExcelForFreelancers 26 күн бұрын

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.

@cornieloots2367 7 ай бұрын

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?

@ExcelForFreelancers 7 ай бұрын

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.

@pauladeniyi5876 9 ай бұрын

Hello Randy, thanks for this great piece. Is it possible to attach an excel or pdf file rather than picture?

@ExcelForFreelancers 9 ай бұрын

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.

@praisemasangano6908 3 ай бұрын

@@ExcelForFreelancers what about sending a sheet as PDF attachment??

@nishantchaudhary3417 6 ай бұрын

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

@ExcelForFreelancers 6 ай бұрын

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.

@philrss440 7 ай бұрын

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?

@ExcelForFreelancers 7 ай бұрын

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.

@jigneshshah9881 9 ай бұрын

THANS SIR ITS GOOD

@ExcelForFreelancers 9 ай бұрын

For sure, you are very welcome and happy to help and share

@VictoriaVerastegui Ай бұрын

Hi, i was wondering how to change the phones number format since I'm not going to use american ones

@ExcelForFreelancers Ай бұрын

Hi and thanks very much. You can use the Cell Number formatting in the Home menu. I hope this helps and thanks so much.

@Azaz-ed7yk 2 ай бұрын

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.

@ExcelForFreelancers 2 ай бұрын

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.

@mikereisen1449 7 ай бұрын

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?

@ExcelForFreelancers 7 ай бұрын

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.

@igorzapparoli2493 5 ай бұрын

I'm having issues set this automation for myself, would you be able to me help me out?

@ExcelForFreelancers 5 ай бұрын

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.

@solofjh 8 ай бұрын

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.

@ExcelForFreelancers 8 ай бұрын

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.

@user-wd7uc2jz4h 9 ай бұрын

HI RANDY AUSTIN PLEASE MAKE ZETTELKASTEN NOTES SYSTEM IN EXCEL IT WOULD BE OF GREAT HELP TO OTHERS THANKS

@ExcelForFreelancers 9 ай бұрын

HI and thanks very much. This is the first time I have heard of this system so I will research and note it. Thanks so much for your valuable feedback and comments.

@rakeshvirupaksha9827 5 ай бұрын

Thanks Randy for your work and effort. But I am facing an error 5 App activate WhatsApp, WhatsApp is not open. Pls sort this problem.

@ExcelForFreelancers 5 ай бұрын

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

@g7jerusalem 2 ай бұрын

I never go the excel sheet - tried several times !!

@ExcelForFreelancers 2 ай бұрын

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.

@theurbanchild 4 ай бұрын

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?

@ExcelForFreelancers 4 ай бұрын

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.

@czechyorker 9 ай бұрын

Makes me wonder if it’s limited to WhatsApp or if you can use Telegram or other messaging apps?

@ExcelForFreelancers 9 ай бұрын

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.

@laminulams8723 9 ай бұрын

Please we need a maco code to run excel faster, thank you ❤

@ExcelForFreelancers 9 ай бұрын

Hi and thanks very much. I do have an entire training on that here: kzfaq.info/get/bejne/g51hns-dxs2vqqs.html I hope this helps and thanks so much.

@growup8687 9 ай бұрын

Please learn us vba fro basics 😮😮

@ExcelForFreelancers 9 ай бұрын

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

@anish4793 8 ай бұрын

Hey, this setup are work in new update of windows 10 &11?

@ExcelForFreelancers 8 ай бұрын

Hi and thanks, yes this will work in any versions of Windows. I hope this helps and thanks so much.

@nairobi203 9 ай бұрын

I missed the live session.😢

@ExcelForFreelancers 9 ай бұрын

No worries at all. I will catch you next week. Thank you for your Likes, Shares & Comments. It really helps.

@fernandotorreblanca5394 4 ай бұрын

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?

@ExcelForFreelancers 4 ай бұрын

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: kzfaq.info/get/bejne/oq6EY9hj36ymn4U.html I hope this helps and thanks so much.

@GATIF786 3 ай бұрын

if we don't have contacts saved in our phone then ?

@ExcelForFreelancers 3 ай бұрын

Please make sure to save the contents first, otherwise Whatsapp can ban your account. I hope this helps and thanks so much.

@jacquihurst1451 9 ай бұрын

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?

@ExcelForFreelancers 9 ай бұрын

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.

@PhilMaund-vx4lm 9 ай бұрын

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

@ExcelForFreelancers 9 ай бұрын

Great Phil, thanks so much for the updated. Name is great way to go. Thanks again.

@zukhov84 8 ай бұрын

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?

@ExcelForFreelancers 8 ай бұрын

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.

@akshayrao4197 8 ай бұрын

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?

@ExcelForFreelancers 8 ай бұрын

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.

@anupamrai235 2 ай бұрын

I am getting a Runtime error: '1004' : Unable to get the Insert property of the Picture Class. Please Help

@ExcelForFreelancers 2 ай бұрын

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

@user-gh2ml3cf5o 9 ай бұрын

Sending messages using scripts, do you think WhatsApp will consider it spam? 😁 I really liked your video👍👍👍

@ExcelForFreelancers 9 ай бұрын

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.

@user-gh2ml3cf5o 9 ай бұрын

@@ExcelForFreelancers thanks👍

@user-uf7wr9mo9n 9 ай бұрын

Like this, how can I send a message through Viber group or number?

@ExcelForFreelancers 9 ай бұрын

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.

@hammeedabdo.82 9 ай бұрын

Is it possible for Excel to send WhatsApp messages to a group of people at once and asynchronously?

@ExcelForFreelancers 9 ай бұрын

Hi and thanks, this would violate the WhatsApp TOS and your account would be closed, so I would not do that. I hope this helps and thanks so much.

@user-qe6iu7fx4c 7 ай бұрын

Can only open with Gsheet? Can't download into PC tho..

@ExcelForFreelancers 7 ай бұрын

Hi and thanks for your comment. This can only be opened with Microsoft Excel on your desktop computer. I hope this helps and thanks so much.

@lettherebelight6910 4 ай бұрын

⭐what happens if the other individual does not have what's app... Do they still receive your text ?

@ExcelForFreelancers 4 ай бұрын

Hi and thanks for your comment. It would be important to use only contacts who have a WhatsApp account. I hope this helps and thanks so much.

@tedljong2280 5 ай бұрын

How to do the same thing with PDF instead of pictures?

@ExcelForFreelancers 5 ай бұрын

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: kzfaq.info/get/bejne/p8uBoNVyqdqqmqs.html I hope this helps and thanks so much.

@kasun2023 7 ай бұрын

Hello sir.... I have purchse youer +300 package..... But this product not include......

@ExcelForFreelancers 7 ай бұрын

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.

@saiflahham211 9 ай бұрын

"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

@ExcelForFreelancers 9 ай бұрын

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.

@osamaghabban2824 2 ай бұрын

Hi sir Is this file support Arabic language in text box ? Pls need your help

@ExcelForFreelancers 2 ай бұрын

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.

@kirti40kirti40garg 5 ай бұрын

i am not abl to snd bulk msgs pls hlp

@ExcelForFreelancers 5 ай бұрын

@NabilTarabichi Ай бұрын

what happens if a number is not in our contact list in whatsapp?

@ExcelForFreelancers Ай бұрын

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.

@FaveolateKitkat-ck5uz 18 күн бұрын

Can i send message whatsapp with different message from each number?

@ExcelForFreelancers 17 күн бұрын

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.

@asifosman 8 ай бұрын

Great video until I realized I have windows 8 and what's app for windows won't work. Any ideas on how do make it work with whatsapp web?

@ExcelForFreelancers 8 ай бұрын

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.

@asifosman 8 ай бұрын

@@ExcelForFreelancers you're right. I do need to upgrade. Laziness needs to be overcome 😉

@angelenewiese3787 6 ай бұрын

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

@ExcelForFreelancers 6 ай бұрын

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

@angelenewiese3787 6 ай бұрын

Thank you so much will try again

@gaganrastogi9624 10 ай бұрын

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?

@ExcelForFreelancers 9 ай бұрын

Hi and thanks, yes I will be going over this in the video so please watch. Thank you for your Likes, Shares & Comments. It really helps.

@ExcelForFreelancers 9 ай бұрын

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: kzfaq.info/get/bejne/icmFdbaXqtfHoo0.html

@ahmedabdaldaim 9 ай бұрын

Is sending a message to group? Or for friends only

@ExcelForFreelancers 9 ай бұрын

Hi and thanks, this could be modified for groups as well. I hope this helps and thanks so much.

@user-lf2sk8hj1v 7 ай бұрын

Hello Sir, is Free the whatsapp tool?

@ExcelForFreelancers 7 ай бұрын

Yes, it is, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

@Cocomelon_Animation 9 ай бұрын

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

@Cocomelon_Animation 9 ай бұрын

Hi randy please reply

@ExcelForFreelancers 9 ай бұрын

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.

@Cocomelon_Animation 9 ай бұрын

Sir please please 🙏 can you free provide

@Cocomelon_Animation 9 ай бұрын

please

@ExcelForFreelancers 9 ай бұрын

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.

@uzorjoseph2041 22 күн бұрын

Please the template

@ExcelForFreelancers 21 күн бұрын

Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

@anish4793 8 ай бұрын

Hi Randy t their are lost of problems im facing in this excel like what happen when Person are not using watsup, can you solve it

@ExcelForFreelancers 8 ай бұрын

HI and thanks in that case you can use SMS Messages. I have a training on that here: kzfaq.info/get/bejne/jJdhqKejur-5gKs.html I hope this helps and thanks so much.

@anish4793 8 ай бұрын

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

@ExcelForFreelancers 8 ай бұрын

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.

@bharatrasve3566 4 ай бұрын

How can i eliminate those which are not on whatapp

@ExcelForFreelancers 4 ай бұрын

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.

@topmanslick 9 ай бұрын

Salute

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that and I am sure you will love this training

@daviderojas Ай бұрын

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.

@ExcelForFreelancers Ай бұрын

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.

@daviderojas Ай бұрын

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

@ExcelForFreelancers Ай бұрын

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.

@daviderojas Ай бұрын

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

@ExcelForFreelancers Ай бұрын

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

@iLoveAPCR 7 ай бұрын

excell blocked the file cause of automation. Is it virus free?

@ExcelForFreelancers 7 ай бұрын

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.

@iLoveAPCR 7 ай бұрын

@@ExcelForFreelancers thank you

@uzorjoseph2041 22 күн бұрын

Mine is showing "Microsoft has blocked macros from running because the source of this file is untrusted"

@ExcelForFreelancers 21 күн бұрын

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.

@asifosman 7 ай бұрын

Is there a risk of whatsapp blocking my number for sending too many messages? How many is too many?

@ExcelForFreelancers 7 ай бұрын

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.

@asifosman 7 ай бұрын

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

@ExcelForFreelancers 7 ай бұрын

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.

@asifosman 7 ай бұрын

@@ExcelForFreelancers thanks and best wishes.

@vechiseiyaporen880 9 ай бұрын

Sir I need VBA Code to change details in existing data using update button separate. (your Data mapping Video)

@ExcelForFreelancers 9 ай бұрын

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.

@saurabhbhatia2658 8 ай бұрын

I am unable to use this

@ExcelForFreelancers 8 ай бұрын

Hi and thanks for your comment. What is the issue you are facing with the template?

@hammeedabdo.82 10 ай бұрын

Is sending a message to a group of people synchronous or asynchronous?

@ExcelForFreelancers 10 ай бұрын

HI please make sure to watch the training in which I will explain it all. Thanks so much

@hammeedabdo.82 10 ай бұрын

@@ExcelForFreelancers I was hoping for an answer, so that I could decide if watching this video was suitable for me or not.

@ExcelForFreelancers 10 ай бұрын

This training demonstrates Synchronous Communication so that we do not violate the WhatsApp TOS

@hammeedabdo.82 9 ай бұрын

Is it possible for Excel to send WhatsApp messages to a group of people at once and asynchronously?@@ExcelForFreelancers

@ExcelForFreelancers 9 ай бұрын

@user-sw2pn9gq7q 8 ай бұрын

Sir please send us

@ExcelForFreelancers 8 ай бұрын

Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

@eliastafese3790 9 ай бұрын

Today in our country New year so today holly day

@ExcelForFreelancers 9 ай бұрын

That is great to hear. Happy Holliday for you and everyone. Thank you for your Likes, Shares & Comments. It really helps.

@eliastafese3790 9 ай бұрын

I have great respect for you, how can we purchase your knowledge in our country pls make something to possible in our currency

@ExcelForFreelancers 9 ай бұрын

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.

@user-gh2ml3cf5o 9 ай бұрын

👍👍👍

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that

@saqlainshaikh9936 9 ай бұрын

❤❤❤❤❤❤

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that

@DadysUpdate 2 ай бұрын

❤❤❤❤

@ExcelForFreelancers 2 ай бұрын

Thank you so very much, I really appreciate that

@GATIF786 3 ай бұрын

We want to send messages to those people whose numbers are not saved in our cell phone.

@ExcelForFreelancers 3 ай бұрын

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.