I am becoming more and more knowledgeable about excel and vba because of your free training Randy. You are truly genius and your works are amazingly brilliant.
Many of them having skills but few people only sharing knowledge to other without any cost and clear cut explanation to other, your are the best 🤠, thanks for sharing this video, this tutorial is most useful for excel VBA beginner and some of them struggle with ther work, I hope this is gonna be helpful no doubts, be safe and keep rocking
Opps, I am a day early. I now have to wait another 24 hours to get my Excel Fix. I have learnt so much from Randy. Thank you for sharing your expertise.
Nice explain sir..your each and every video is awesome and I learn lot of thing from it. Because of you I can Make variety of excel sheet for my business and save lot of time
Hello Randy, I don't see the lesson on how to create the SMS text message in your lesson group. I am really impressed with this application and would love to learn how to do this.
Hi Randy! I know you get a lot of request's all the time but at my work we put up event tents (not camping tents) and with those tents theirs a lot of parts and pipes, vinyl, straps, etc. our tent sizes range from the smallest being a 10X10 to a 50x120. I would like a system where for example you click 10x10 and shows you a picture and pops up the exact list of what you need to build that 10x10. I also want it to keep track of how many parts and pipes, vinyl, straps, etc. we have in the warehouse. this is all just a concept and I have more ideas but I think with your skill it can be done, it might also make a great video:) obviously its totally your choice whether you want to help me or not , love your videos and I know you have changed peoples lives for the better! thank you so much!
Hi Erik, thanks so much for your suggestion. I have a similar video, so perhaps check one called "Pictures in Tables" which will help you achieve your idea. Thank you for your Likes, Shares & Comments. It really helps.
Excel For Freelancers what about code modifications?! In that case how to iterate through numbers and separate the with a comma to be able to send a bulk SMS?
I am sure there is a way of course however I am mostly focused on Excel. Please search my channel for 'Google Sheets' to see how you can integrate Google Sheets with Excel. Thank you for your Likes, Shares & Comments. It really helps.
Hello sir i am very happy that your team is providing such a detail of excel that helps many business i recently join this channel and i am gald to say that i am very thankful to you and your team Sir i want to send sms from excel sheet but with our company mobile number it can be possible from excel sheet please give me some information about this because of this i can manage our company customer very properly
Another Great Video, Thanks for all the time and effort you put into them. This is something i will add in to my world when I get back to work. Stay safe and Thanks again for everything.
Seriously it's like you're God sent brother, you always do things I desperately need. But Always when I ask myself how am I gonna archive all of my plans, boom your video shows up as a solution. Thanks brother God bless you.
Hi and thanks so much. I do go into detail on how to use the API with Twilio in this training. Please make sure to watch the entire training. Thank you for your Likes, Shares & Comments. It really helps.
Hi J D, and thanks. Yes and No :). I do have plans to create an application in that creates a log in Excel of all phone Messages and calls, but I plan to do it without Twilio. I hope to get to that in just a few weeks. Thanks for the great suggestion
Hi and thanks, it may be possible however this would be a custom application. You can request this application from the developers in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. 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: ruclips.net/video/ScUBSfEqcrY/видео.html
HI and thanks that type of application could not be taught in an hour. That would be a custom solution taking many hours so is not something I can do in a RUclips video. Thanks for understanding.
Hi and thanks for your comment and sorry you did not get the workbook. Can you please send all of your details including the workbook requested and the email you used to angeli@ExcelForFreelancers.com , so that you can get the workbook needed. Thanks again
Hello, thank you so much for this content! I am wondering if there is a way I could set the customer type to work based off of a condition within another excel sheet. For example if I can make the customer types "Yes" and "No" and then base whether they are yes off of whether the value in the other sheet does not equal 0? I am trying to make a payment reminder for customers.
Hi and thanks for your comment. Yes it is certainly possible through VBA to open, check for values and close another workbook, however I strongly recommend all of your data is combined into a single workbook for speed and accuracy. I hope this helps and thanks so much.
@@ExcelForFreelancers Ok, thank you! Sorry I am new to VBA. When I try to run the campaign after putting in my twilio, it throws an error code 429: ActiveX component can’t create object and highlights the Set ObjHttp line. How should I go about debugging this?
Hi and thanks so much. ActiveX controls do not work on a Mac computer so you would want to use a Windows PC or use parallels so you can run windows inside of a Mac. I hope this helps and thanks so much.
@@ExcelForFreelancersThank you so much for all your help! I got it up and running! One other question I had was that when I go to send the message with [All Types] it isn’t updating the criteria on the customer page. When I load up the campaigns they don’t change the criteria, how could I fix this? Thanks!
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.
Hello Randy , thanks for this training. have you any plans to a video on automate WhatsApp for bulk sms with the help of Excel? Thanks Shubham from India.
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: ruclips.net/video/ScUBSfEqcrY/видео.html
Great tutorial and exactly the XL application I was looking for, also Twillo seem like a good partner to work with (thanks for the discount). One problem you might be able to solve is that I am working on a MAC and am getting a 429 run time error when the macro tries to create the URL for Twillo. Do you have any suggestion how to work around this problem?
HI Peter, thanks so much for the comment. For the Mac I believe there are some alternate options however I have not tried myself. You can find some solutions for Mac's here: www.rondebruin.nl/mac.htm
I am also in waiting list hope this works well because there are many videos regarding this but I thought they are not so easy so I thought that this will complete the inconvenience of father videos it will be great I hope so
Thanks so much. It will work perfectly as long as you follow the video training. I have tested it a lot to be sure. Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much for the training! I'm curious, what is the limit to the amount of messages you can send at the same time? Is there a good way to schedule a certain amount so it doesn't get flagged as spam?
HI and thanks those limits depend upon the API and the service you are using to send those messages from (such as your phone carrier service) Please check with them to understand what those limits are. I hope this helps and thanks so much.
Hi and thanks. I think this was just a temporary issue, while we uploaded new versions. Can you just try again and it should work fine. I hope this helps and thanks so much.
Hi :) thank you for this wonderful content! But my question is: Can we use this file and translate it in an application on the phone?? Maybe with power app??
HI and thanks. I am sure that is possible with the right apps however I have not tried this. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers thank you!! I hope that one I will finish my seasonal job I can start studying all your materials now we are two! But one of us doesn't speak English but he told me that he is enthusiastic about your channel!! Hope you will continue and thank you 👍👍👍👍
Hi, another great job there. You're gifted. Can this method be used to send, say, a millon sms automatically to unsaved numbers generated in excel plz? If yes, how should the phone numbers be formated in excel?
Hi and thanks so much for your comment. Yes it is certainly possible, and as long as your cell contains only #'s and no other characters the format would not matter as much. 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: ruclips.net/video/ScUBSfEqcrY/видео.html
This is a great tutorial. I'm curious if there is a way to specify on what date and time a message should be sent out. I have a list of guests whose phone numbers I've collected over the last year and would like to send them a "Happy Holidays" text; however, I'd prefer to throttle the frequency with which they're sent out. You have a "Send On" variable but I don't see in the code where that is taken into account as to when the text will be sent. Thoughts?
Hi and thanks very much. You can automate actions based on a specific date and time. I have another video that demonstrates this as well. ruclips.net/video/0vmtkTBb3j0/видео.html I hope this helps and thanks so much.
Hi Paul, thanks for your comment. I have posted a great and free beginners VBA course on my site taught by MVP Sumit Bansal here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ I hope this helps and thanks.
@@ExcelForFreelancers I have used Twilio with international number and it worked perfectly. The only drawback is that SMS to some countries are more expensive than internal US SMS.
HI and thanks. I use conditional formatting in many of my videos however I do not have a video that covers it specifically. Perhaps try searching other Excel channels for videos that train on Conditional Formatting. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Yes I know, but the part of video above where you talk about condition formatting in the Message Campaign, I just need one your video training special coded conditional formatting. Thanks
Hi thanks you can download the application to view all of the conditional formatting rules. I will try to add a video in the future that focuses on this.
Hi and yes you can. You can use the Worksheet Change Event to run any macro or perform an action when a specific cell changes. I hope this helps and thanks so much.
Randy, regarding the scheduling ahead of a message using Application.Ontime, will Excel need to be open for this to work? Can you explain just a little how this will work? Thanks!
Hi Scott, yes you will want to make sure Excel is open in order to run this. You can also use Windows Task Scheduler to open that specific Excel file on a regular schedule for a fully automated, hands-free, solution. Thanks again.
Hi Caleb, thanks for the info, you can search google for the free download but i will also be creating an entire training around how to make it for VBA. Thank so much.
HI Pat, thanks so much for your comment. I did something very similar in this video with a Live Chat here: ruclips.net/video/d5ZlcYR8dOk/видео.html Thank you for your Likes, Shares & Comments. It really helps.
Is there a simple way to have the advancedfilter be able to do a wildcard so if my Customer type is Commercial AND Wholesale it would pick up either one?
Hi Jimmy, yes certainly . You can have two Customer Type columns within the criteria. You can then add each of those types within the columns which will serve as the "OR" feature, which is what I think you want. Since a customer type would be Commercial Or Wholesale. 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: ruclips.net/video/ScUBSfEqcrY/видео.html
HI thanks the Whatsapp API is still in beta release so hopefully one day they will finish i so i can adapt it for Excel. Thank you for your Likes, Shares & Comments. It really helps.
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: ruclips.net/video/ScUBSfEqcrY/видео.html
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: bit.ly/SendSMS_Wb 💬 FACEBOOK MESSENGER: bit.ly/SendSMS_FbDl Please read the video description in future.
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
I am becoming more and more knowledgeable about excel and vba because of your free training Randy. You are truly genius and your works are amazingly brilliant.
Thank you so much Loydie, I am very happy I can help guide and inspire you. Much appreciated.
Best VBA Excel training on RUclips is this channel. Thanks, Randy.
Thank you so much and was great to chat live with you during the video. Much appreciated.
I agree with you.....
thanks
For sure, you are very welcome
Worked! What an absolute genius mad lad! Was so easy
Thank you for your Likes, Shares & Comments. It really helps Fill enjoy
Many of them having skills but few people only sharing knowledge to other without any cost and clear cut explanation to other, your are the best 🤠, thanks for sharing this video, this tutorial is most useful for excel VBA beginner and some of them struggle with ther work, I hope this is gonna be helpful no doubts, be safe and keep rocking
Thank you very much. I do appreciate that Muthu
I was literally waiting for this kind of video
That is great to hear and I am happy I can help and share it.
It will be very useful training.......i may watch online. Thank you again Mr. Randy
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Opps, I am a day early. I now have to wait another 24 hours to get my Excel Fix. I have learnt so much from Randy. Thank you for sharing your expertise.
Thanks so much Bruce. Just 12 hours away. I hope you enjoy the training. Thank you for your Likes, Shares & Comments. It really helps.
One simple word to recognize your work. WOW!!!!
Thank you very much. I do appreciate that Omar.
looking forward to learning from the rest of your videos. Subscribed!
Thank you for your Likes, Shares & Comments. It really helps Zyralou
Excellent Training Randy. Highly appreciated your wonderful work which is hugely helpful....
Glad it was helpful Ashokan. Thank you for your Likes, Shares & Comments. It really helps.
Dear Sir,,
You're really the best in the world..
Your videos helps me always.
Thank yo so much Abdul. I am happy that I can help.
For sure, I hope so as well.
Brilliant!... I will be trying this tomorrow 👏🏼👏🏼
Great Simon, thank so much.
Sir
I'm tired of praising you really sir you are very unique and best man ever
Thank you so much Saddam. I really appreciate that.
I know, me too. He's relentless with awesome videos, week after week!
Hey Randy, hope you and the Family are well, this is something I've been look for for years, cant wait, your are really talented.
Thank you so much Shamiel. I can't wait to bring this training to you and i hope you enjoy it.
Randy you are a guru
Thank you very much. I do appreciate that.
Amazing advice
Glad you think so! Thank you very much. So nice of you Fatema
Great video!
Thank you so very much, I really appreciate that.
You are my Master Excel 💪 stay safe sir, I tried most of your tutorials. Thank you so much for sharing your knowledge.
Thanks very much Dan, I am happy I could help.
Dear Randy,
It is really very helpful video.
This channel is best for excel learning on youtube..
Thank you very much. I do appreciate that Guiliver.
Good video 💖💖
Thanks for the visit. Thanks so much Rofiqul
Always interested in your posts n videos
Thank you very much. I think you will really enjoy this training.
Beautiful video
Thank you so very much, I really appreciate that
Great for advertising and promotion with the right client lists.
Absolutely Joe. Thanks again for your continued support
Awesome ..... waiting for this...
Thanks so much Anand. I am sure you will love it.
thanks man you are great. you got a new subscriber :)
Thank you so very much, I really appreciate that Subal
Great video very useful
Thanks so much, I do appreciate that.
Nice explain sir..your each and every video is awesome and I learn lot of thing from it. Because of you I can Make variety of excel sheet for my business and save lot of time
Thanks so much. I am really glad to hear that Pravin.
Great video Randy, not sure I’ll ever use this but really informative 👌🏻
Thanks so much Graham. I do appreciate that.
Sir Excellent video. You are a genius. I was waiting this type of video. Finally, I got it.
Thank you so much Ashok, I am really happy i can bring this to you.
honestly.. this video so good.......
Thank you very much. I do appreciate that Vindri. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers i'll share this video to my friend and office peer.. maybe can help they too...
Thanks so much.
Great work
Thank you! Cheers Khan :)
I really love this video. It's very easy to use, and very good 🌟
I'm so glad Mai, Thanks so much for the nice comment. You can learn to do this yourself, or have someone you know teach you. You seem very smart. :)
Nice video good video.
Thank you so very much, I really appreciate that Akter
Thank you Mr.
You are very welcome and thank you
Very nice 😅😅😍
Thank you for your Likes, Shares & Comments. It really helps Kaium
Nice video good 👍
Thank you 👍 very much :)
Excellent
Thank you so very much, I really appreciate that
Thanx for this video
You are very welcome Rishabh.
amazing...simply amazing!!
Thanks so much. I am really glad you enjoyed the training.
Thank you Sir for sharing all your knowledge for free. 😊
For sure, you are very welcome
Hey Randy, stay safe you and your loved ones..Thank you so much for this brief video.very helpful!! Have a great day ahead!!
Thank you very much. I do appreciate that.
Thank you so much...
You're most welcome
Nice video
Thank you for your Likes, Shares & Comments. It really helps.
Hello Randy, I don't see the lesson on how to create the SMS text message in your lesson group. I am really impressed with this application and would love to learn how to do this.
HI and thanks very much. I have just one training on SMS, and this is the video you commented on. I hope this helps and thanks so much.
Hi Randy! I know you get a lot of request's all the time but at my work we put up event tents (not camping tents) and with those tents theirs a lot of parts and pipes, vinyl, straps, etc. our tent sizes range from the smallest being a 10X10 to a 50x120. I would like a system where for example you click 10x10 and shows you a picture and pops up the exact list of what you need to build that 10x10. I also want it to keep track of how many parts and pipes, vinyl, straps, etc. we have in the warehouse. this is all just a concept and I have more ideas but I think with your skill it can be done, it might also make a great video:) obviously its totally your choice whether you want to help me or not , love your videos and I know you have changed peoples lives for the better! thank you so much!
Hi Erik, thanks so much for your suggestion. I have a similar video, so perhaps check one called "Pictures in Tables" which will help you achieve your idea. Thank you for your Likes, Shares & Comments. It really helps.
Perfect as usual BUT What if I wanna send bulk messages instead of sending one by one? For example I wanna send 1 message to all list numbers at once?
I am sure that is possible as well. Please have a look at the Twilio API. Thanks again.
Excel For Freelancers what about code modifications?! In that case how to iterate through numbers and separate the with a comma to be able to send a bulk SMS?
Please check the Twilio API that i went over in the training. Thanks so much.
It is possible for either sms (with your mobile No. and at a standard rate charge of your network carrier or whatsapp but its all in google sheet.
I am sure there is a way of course however I am mostly focused on Excel. Please search my channel for 'Google Sheets' to see how you can integrate Google Sheets with Excel. Thank you for your Likes, Shares & Comments. It really helps.
Nice video of the
Thank you for your Likes, Shares & Comments. It really helps Ripon
Hello sir i am very happy that your team is providing such a detail of excel that helps many business i recently join this channel and i am gald to say that i am very thankful to you and your team
Sir i want to send sms from excel sheet but with our company mobile number it can be possible from excel sheet please give me some information about this because of this i can manage our company customer very properly
Thank you so very much, I really appreciate that Haidar
Sir please say how i can send text messages from excel but using mobile sim or from Android mobile
Please watch the video again because you can use any phone # to send messages, even the one in your mobile sim from Android.
So this is what Kelly Rowland was doing in the Dilemma video 😂
Perhaps. Thank you for your Likes, Shares & Comments. It really helps..
Underrated
😂😂😂
Underrrated
Another Great Video, Thanks for all the time and effort you put into them. This is something i will add in to my world when I get back to work. Stay safe and Thanks again for everything.
Thank so much Mike, I really appreciate it and happy i could help.
@@ExcelForFreelancers lk/SDJj
nice video
Thank you so very much, I really appreciate that Joy
Seriously it's like you're God sent brother, you always do things I desperately need. But Always when I ask myself how am I gonna archive all of my plans, boom your video shows up as a solution.
Thanks brother God bless you.
Thanks so much Siphiwo I am so happy i can help and share. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy... Its a great tutorial and how to configure this excel with twilio?
Hi and thanks so much. I do go into detail on how to use the API with Twilio in this training. Please make sure to watch the entire training. Thank you for your Likes, Shares & Comments. It really helps.
Wow👌👌👌
Thank you so very much, I really appreciate that
Amazing
Thanks so much, I really appreciate that Anand.
best sir
Thanks so much. I am glad you like it.
Hello Randy, Thank you for you for this training. Have you any plans to make a video on receiving SMS messages from twilio? Thanks
Hi J D, and thanks. Yes and No :). I do have plans to create an application in that creates a log in Excel of all phone Messages and calls, but I plan to do it without Twilio. I hope to get to that in just a few weeks. Thanks for the great suggestion
Nice
Thank you so very much, I really appreciate that Shahidul
nice vedio
Thank you so very much, I really appreciate that Hasan
Can you make a similar video where we can send multiple messages(different msgs for different numbers)from excel to whatsapp via web whatsapp?
Same request 😊
Hi and thanks, it may be possible however this would be a custom application. You can request this application from the developers in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 40,000 Members who would love to help you with this. 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: ruclips.net/video/ScUBSfEqcrY/видео.html
Keren 👍👍👍👍👍👍👍🔥❤️❤️❤️❤️❤️❤️❤️
Thank you very much. I do appreciate that.
bravo
Thank you very much. I do appreciate that.
Respected sir
Please make a video on school management system
HI and thanks that type of application could not be taught in an hour. That would be a custom solution taking many hours so is not something I can do in a RUclips video. Thanks for understanding.
i need this but after giving mail i did not get it. this is amazing one.
Hi and thanks for your comment and sorry you did not get the workbook. Can you please send all of your details including the workbook requested and the email you used to angeli@ExcelForFreelancers.com , so that you can get the workbook needed. Thanks again
Good
Thanks. Very kind of you Jklsgf
Hello, thank you so much for this content! I am wondering if there is a way I could set the customer type to work based off of a condition within another excel sheet. For example if I can make the customer types "Yes" and "No" and then base whether they are yes off of whether the value in the other sheet does not equal 0? I am trying to make a payment reminder for customers.
Hi and thanks for your comment. Yes it is certainly possible through VBA to open, check for values and close another workbook, however I strongly recommend all of your data is combined into a single workbook for speed and accuracy.
I hope this helps and thanks so much.
@@ExcelForFreelancers Ok, thank you! Sorry I am new to VBA. When I try to run the campaign after putting in my twilio, it throws an error code 429: ActiveX component can’t create object and highlights the Set ObjHttp line. How should I go about debugging this?
Hi and thanks so much. ActiveX controls do not work on a Mac computer so you would want to use a Windows PC or use parallels so you can run windows inside of a Mac. I hope this helps and thanks so much.
@@ExcelForFreelancersThank you so much for all your help! I got it up and running! One other question I had was that when I go to send the message with [All Types] it isn’t updating the criteria on the customer page. When I load up the campaigns they don’t change the criteria, how could I fix this? Thanks!
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.
Hello Randy , thanks for this training. have you any plans to a video on automate WhatsApp for bulk sms with the help of Excel? Thanks
Shubham from India.
Hi and thanks. I do have that on my list of videos to create in the near future. Thanks so much.
@@ExcelForFreelancers Please do that, it is required by many in India😐
Thank you all frid
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: ruclips.net/video/ScUBSfEqcrY/видео.html
Genius
Thank you very much. I do appreciate that Genius.
good
Thanks. So nice of you ইয়াসিন ইয়াসিন
Great tutorial and exactly the XL application I was looking for, also Twillo seem like a good partner to work with (thanks for the discount). One problem you might be able to solve is that I am working on a MAC and am getting a 429 run time error when the macro tries to create the URL for Twillo. Do you have any suggestion how to work around this problem?
HI Peter, thanks so much for the comment. For the Mac I believe there are some alternate options however I have not tried myself. You can find some solutions for Mac's here: www.rondebruin.nl/mac.htm
When the magic comes true 👍
Thanks very much yousef :)
I am also in waiting list hope this works well because there are many videos regarding this but I thought they are not so easy so I thought that this will complete the inconvenience of father videos it will be great I hope so
Thanks so much. It will work perfectly as long as you follow the video training. I have tested it a lot to be sure. Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much for the training! I'm curious, what is the limit to the amount of messages you can send at the same time? Is there a good way to schedule a certain amount so it doesn't get flagged as spam?
HI and thanks those limits depend upon the API and the service you are using to send those messages from (such as your phone carrier service) Please check with them to understand what those limits are. I hope this helps and thanks so much.
plz make video on how to make barcode generator in excel plz
Hi and thanks I have that on my list and will get to that very soon. Thanks for the nice idea.
Amazing training! Thank you! Is there a time limit to the excel download? I get an access denied when I click on the emailed link.
Hi and thanks. I think this was just a temporary issue, while we uploaded new versions. Can you just try again and it should work fine. I hope this helps and thanks so much.
@@ExcelForFreelancers Brilliant! Thank you, it works now :-) Thank you for the great content!
For sure, you are very welcome
@@ExcelForFreelancers jhtguiililui
Hi :) thank you for this wonderful content! But my question is: Can we use this file and translate it in an application on the phone?? Maybe with power app??
HI and thanks. I am sure that is possible with the right apps however I have not tried this. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers thank you!! I hope that one I will finish my seasonal job I can start studying all your materials now we are two! But one of us doesn't speak English but he told me that he is enthusiastic about your channel!! Hope you will continue and thank you 👍👍👍👍
Hi, another great job there. You're gifted.
Can this method be used to send, say, a millon sms automatically to unsaved numbers generated in excel plz? If yes, how should the phone numbers be formated in excel?
Hi and thanks so much for your comment. Yes it is certainly possible, and as long as your cell contains only #'s and no other characters the format would not matter as much. I hope this helps and thanks so much.
Dear Sir,
thanks for traning
can i make customise massage to each no not coman massage
HI yes Shah, that is correct. Please watch the entire video to see how to do this.
Is it possible to do the same thing with whatsapp?
I will try to add that in the near future. Thanks very 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: ruclips.net/video/ScUBSfEqcrY/видео.html
This is a great tutorial. I'm curious if there is a way to specify on what date and time a message should be sent out. I have a list of guests whose phone numbers I've collected over the last year and would like to send them a "Happy Holidays" text; however, I'd prefer to throttle the frequency with which they're sent out.
You have a "Send On" variable but I don't see in the code where that is taken into account as to when the text will be sent.
Thoughts?
Hi and thanks very much. You can automate actions based on a specific date and time. I have another video that demonstrates this as well.
ruclips.net/video/0vmtkTBb3j0/видео.html
I hope this helps and thanks so much.
please can you do that with ms access
Hi and thanks you may want to request a project on Upwork with help in Access applications. Thanks very much.
Hi is there any chance you can do some beginners vba please that would be great if you can
Hi Paul, thanks for your comment. I have posted a great and free beginners VBA course on my site taught by MVP Sumit Bansal here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
I hope this helps and thanks.
@@ExcelForFreelancers thank you very much I will take a look 😁
Hi, Randy, this sms messages works in any country (Portugal with Vodafone)?
Hi Jose, yes that is correct. This should work in every single country. I hope you enjoy this video.
@@ExcelForFreelancers I have used Twilio with international number and it worked perfectly. The only drawback is that SMS to some countries are more expensive than internal US SMS.
Yes i am sure but the costs are based on the carriers in those countries since the phone companies control the costs.
wich office are you using
Hi and thanks for your comment. I used Excel 2010 to make this. Thank you for your Likes, Shares & Comments. It really helps.
what is vba and how can i install it
That is a great question. In these cases, Google would be a great help with some very clear answers.
Shall I have this link to download?
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hello Randy, Please can you direct me to the video that can help on the conditional formatting.
HI and thanks. I use conditional formatting in many of my videos however I do not have a video that covers it specifically. Perhaps try searching other Excel channels for videos that train on Conditional Formatting. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Yes I know, but the part of video above where you talk about condition formatting in the Message Campaign, I just need one your video training special coded conditional formatting. Thanks
Hi thanks you can download the application to view all of the conditional formatting rules. I will try to add a video in the future that focuses on this.
Thank you sir ,
can i have that excel please
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi, Is it possible to send an automatic sms msg once a specific cell changes value?
Hi and yes you can. You can use the Worksheet Change Event to run any macro or perform an action when a specific cell changes. I hope this helps and thanks so much.
Can I buy it
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Randy, regarding the scheduling ahead of a message using Application.Ontime, will Excel need to be open for this to work? Can you explain just a little how this will work? Thanks!
Hi Scott, yes you will want to make sure Excel is open in order to run this. You can also use Windows Task Scheduler to open that specific Excel file on a regular schedule for a fully automated, hands-free, solution. Thanks again.
Can you link me to the autohotkey information to auto fill the vba code?
Hi Caleb, thanks for the info, you can search google for the free download but i will also be creating an entire training around how to make it for VBA. Thank so much.
@@ExcelForFreelancers I would love to see this as I like it and did try to google it, but could not find the exact information I was looking for.
Thanks, a lot of people have asked me about it so I really should do it. Much appreciated.
Any thought of creating a pop-up sms "chat" window? Basically emulate what you do when using a messenger app.
HI Pat, thanks so much for your comment. I did something very similar in this video with a Live Chat here: ruclips.net/video/d5ZlcYR8dOk/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
Is there a simple way to have the advancedfilter be able to do a wildcard so if my Customer type is Commercial AND Wholesale it would pick up either one?
Hi Jimmy, yes certainly . You can have two Customer Type columns within the criteria. You can then add each of those types within the columns which will serve as the "OR" feature, which is what I think you want. Since a customer type would be Commercial Or Wholesale. I hope this helps and thanks so much.
This is a good news
Thank you so very much, I really appreciate that Kamal
Do you use any API?
HI you can watch the video to see exactly how it is done.
So amazing next massive I want to see on massive with line chat application
Thank you very much. I will do my best to get that done. Perhaps send to Whatsapp. I will do my best and thanks.
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: ruclips.net/video/ScUBSfEqcrY/видео.html
Hi Randy, That´s very great, let me ask you, have you ever see any possibility to send by WhatsApp ?
HI thanks the Whatsapp API is still in beta release so hopefully one day they will finish i so i can adapt it for Excel. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers there are a few videos on youtube with whatsapp sharing , but didnt work when tried on system
@@ExcelForFreelancers Sir any chance of What's app automation using Excel?
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: ruclips.net/video/ScUBSfEqcrY/видео.html
how we are going to donwload the workbook of your class
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/SendSMS_Wb
💬 FACEBOOK MESSENGER: bit.ly/SendSMS_FbDl
Please read the video description in future.
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Thanks so much Ben :)
@@BenLinfordUK how do I download this workbook