⭐Download the Excel template here: pythonandvba.com/twilio-excel-template/
@CodingIsFun
2 жыл бұрын
@Divakaran Sivasamy Have a look here to find out more about the Twilio pricing: www.twilio.com/sms/pricing/jp As far as I know, Twilio has no physical limit on the number of messages per day (but you might need to validate this on their website).
@richardadams9159
2 жыл бұрын
First let me say that you are a life saver with this tutorial and the download..thank you so much..my question is..how do I upload the numbers and how to do edit the message that says twilio and vba?..I hope you understand what I meant?..hope to read from you soon..thanks
@williamsvelma1445
2 жыл бұрын
HELLO I HAVE A QUS TO ASK ARE U ONLINE NOW
@CodingIsFun
2 жыл бұрын
@@williamsvelma1445 yes
@williamsvelma1445
2 жыл бұрын
good to have u here now
@maxsaltykov3321
3 жыл бұрын
Bro, you're the best. I just did everything and it works. Thank you!
@CodingIsFun
3 жыл бұрын
Thank you! Glad it was helpful :)
@sandeepprajapat8468
3 жыл бұрын
i use my mobile on desktop using ADB and i love that. its save my time because all i need to do like sms or calling someone its on my finger tip i never touch my phone during the programming or somthing else on laptop. just change the tab and see my mobile screen on desktop. might be possible through using ADB i am linux user, love from india...........Coding with fun.
@CodingIsFun
3 жыл бұрын
That sounds very convenient 👍 Greetings to India 😃
@garycurtis
Жыл бұрын
Excellent video, thank you. I have a question, I need to add my messaging service SID when sending messages, how would I incorporate that?
@CodingIsFun
Жыл бұрын
Thanks for watching. You can specify the alphanumeric sender ID in the from number: support.twilio.com/hc/en-us/articles/223181348-Alphanumeric-Sender-ID-for-Twilio-Programmable-SMS
@garycurtis
Жыл бұрын
@@CodingIsFun How can I send spanish (Spanish Characters) messages here in America without it using 3 times the number of segments to send a message vs english messages?
@augustinscalzo3429
10 ай бұрын
Thank You Sven , excellent video. Can I schedule automatic sending at a specific time ?
@CodingIsFun
10 ай бұрын
Thanks. That is not possible with the current template
@landoncrigler3942
Жыл бұрын
I found the answer. Thanks again for the fantastic info.
@CodingIsFun
Жыл бұрын
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
@surreyincanada
Жыл бұрын
Thank you! This is a life saver! I am not sure if others have asked this, is there a way to tweak it to only send to selected contacts in Receiver Number column, Lets say I have 100 numbers, and I only want to send a message to 10 of them. Can I partially select?
@CodingIsFun
Жыл бұрын
Glad you like the solution. It is possible, but you need to tweak the VBA code. Happy Coding!
@Cgggg7
Жыл бұрын
@@CodingIsFun Hello, could you please give some details on how to accomplish this? Thank you!
@CodingIsFun
Жыл бұрын
@@Cgggg7 Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
@SuaFavorita-q6j
8 ай бұрын
Meus parabéns pelo seu trabalho !! salvou minha aqui no Brasil ! estava a dias procurando um video com uma planilha funcional e nada, ate que encontrei seu video !!! toma like e ganhou mais um fã e seguidor !
@CodingIsFun
7 ай бұрын
Fico feliz em ouvir isso e obrigado por assistir ao vídeo! Cheers, Sven ✌️
@marylandmojophoto3313
Жыл бұрын
@CodingIsFun This is a great tutorial and I've successfully re-created what you've done here. 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. Thoughts?
@CodingIsFun
Жыл бұрын
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
@jmchamberplayers
Жыл бұрын
Thanks for the video! Quick question, I can't figure out why the program stops here:'UseXML HTTP Set Request = CreateObject("MSXML2.ServerXMLHTTP.6.0") when check to make sure the code is working?
@CodingIsFun
Жыл бұрын
Thanks for watching. Hard to tell from a distance without knowing the error message.
@jmchamberplayers
Жыл бұрын
I think it's because I am on a Mac, is there a easy work-around? Or I will have to create a partition and run Windows 11?@@CodingIsFun
@@jmchamberplayers This solution only works on Windows. I do not have a solution for macOS.
@jmchamberplayers
Жыл бұрын
@@CodingIsFun ok thank you
@TTinfoz
11 ай бұрын
Can this somehow be used en masse? And does this help to send messages via WhatsApp and not have the number dropped?
@asrafpaz
2 жыл бұрын
I love this tool. any option to add schedule option?
@CodingIsFun
2 жыл бұрын
Thanks! In the template there is no option to schedule the SMS.
@summitrealtors3594
3 жыл бұрын
great tutorial
@marylandmojophoto3313
Жыл бұрын
@codingisfun Good evening... I'm using this and trying to send a message using my Twilio that is 200 characters long. However, for some reason, it only sends the first 58 characters. Any idea why this would happen?
@CodingIsFun
Жыл бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@dovacmarlon7493
3 жыл бұрын
Awesome video. Very helpful. Thanks for the upload Sir.
@CodingIsFun
3 жыл бұрын
Thank you for watching the video. Glad it is helpful! 😃
@BlaiseHappy
Жыл бұрын
Hi I downloaded the workbook from the description Is this ready to be used once I enter my SID & other info? Or must I still enter code? When just using the downloadable workbook & entering all of my individual info When attempting to send SMS to numbers I entered - I get the status code 400 - that I sent to invalid numbers with the "+" symbol - although none of the numbers i entered lead with a + Do I need to add a country code? Or how can I fix this? Thank you in advance!
@CodingIsFun
Жыл бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@BlaiseHappy
Жыл бұрын
@@CodingIsFun after more trials. You have to have the country code in place of the destination number to successfully send. Works great.
@familyexotics6586
2 жыл бұрын
Hi this works great. Can I ask how do I attach a picture to a message so an MMS?
@CodingIsFun
2 жыл бұрын
Thank you! I do not have a template for sending MMS using VBA, but it is possible with the Twilio API. Have a look at the docs: www.twilio.com/docs/sms/tutorials/how-to-send-sms-messages-vbnet#send-a-message-with-media-mms I hope it helps! Happy Coding!
@pilisieviczkrystof
Жыл бұрын
hey, do we need to put all this code in order to get this working? I don't know anything about codes but I still want to use this.
@CodingIsFun
Жыл бұрын
As explained in the video, simply download the template from the description and you are good to go. Happy Sending!
@alanrochaestudosmed9895
7 ай бұрын
Consigo alterar a planilha para usar no Pushbullet?
@CodingIsFun
7 ай бұрын
I also have a Pushbullet template
@garycurtis
2 жыл бұрын
Excellent Video, I really appreciate it, this is simply amazing. I want to convert this to MS Access. Question do we use the same code for receiving messages or reply back to messages?
@CodingIsFun
2 жыл бұрын
Thanks for watching the video & your question. *Short answer is:* No 😕 *Longer answer is as follows:* In general, to 'receive' the messages, Twilio is using a webhook. In simple terms, Twilio will notify your web server whenever they receive an SMS message. The more extended version on what a Webhook is: Webhooks are user-defined HTTP callbacks. They are usually triggered by some event, such as receiving an SMS message or an incoming phone call. Twilio makes an HTTP request (usually a POST or a GET) to the URL configured for the webhook when that event occurs. To handle a webhook, you only need to build a small web application to accept the HTTP requests. Almost all server-side programming languages offer some framework for you to do this. Examples across languages include ASP.NET MVC for C#, Servlets and Spark for Java, Express for Node.js, Django and Flask for Python, and Rails and Sinatra for Ruby. PHP has its own web app framework built-in, although frameworks like Laravel, Symfony and Yii are also popular. That being said, VBA is not a server-side programming language. Hence, it is not very straightforward to receive (and reply) messages using only VBA 😕 Further reading on Twilio's SMS API: www.twilio.com/docs/sms/tutorials/how-to-receive-and-reply-csharp I hope this helps! :)
@garycurtis
2 жыл бұрын
@@CodingIsFun Question, can I send an attachment also using this code? If so how?
@UpTheHillMusic
Жыл бұрын
Hi - looks like excel disabled the macros on this doc? Anyway to fix that?
@CodingIsFun
Жыл бұрын
Thanks for watching. Here you are: kzitem.info/news/bejne/tHyctqawk3OHqmk
@chriskinggard7135
3 жыл бұрын
Hello When i was writing the code in the module part of excel it reads " error Macros....." i am unsure what that means. May we hop on a zoom call so you could help me out.
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. Have you tried running the version, which I linked in the description? bit.ly/3y6T61k
@chriskinggard7135
3 жыл бұрын
@@CodingIsFun Yes
@CodingIsFun
3 жыл бұрын
@@chriskinggard7135 Any chance you could let me know the full error message? Or even better, send me a screenshot of the error to: contact@pythonandvba.com Thanks!
@yitzchokwagner4565
2 жыл бұрын
Thank you so much, this really helped me. I know this is not necessarily what you're covering but is there a way to add the first name of the contact automatically into the text? (Like a merge tag?) I tried inserting the name into the a column and adding =a9 into the message but it would not pick up the formula.
@yitzchokwagner4565
2 жыл бұрын
I figured it out, Not sure if it's the right way, But I add names to the a column and than in the message I put "=CONCATENATE(A9," Text you'd like to add")" and it filled in the name as well as the message. Thank you again
@CodingIsFun
2 жыл бұрын
@@yitzchokwagner4565 Great! Thanks for watching the video :)
@walkerpaul7571
3 жыл бұрын
Thanks for the education. I subscribed to your channel. Do you know how I could connect your VBA template to the CRM Cloze?
@CodingIsFun
3 жыл бұрын
Welcome aboard! Thanks for watching the video & your question. I do not have a ready-to-use template to connect with CRM Cloze. Yet, I have checked their website; Cloze also offers an API for developers, which you could access using VBA: developer.cloze.com/#!/Get_Started/get_v1_profile
@danoxtreme007
2 жыл бұрын
You deserve a Super Like!
@CodingIsFun
2 жыл бұрын
Wow, thanks! Glad you liked the video and template.
@danoxtreme007
2 жыл бұрын
@@CodingIsFun i loved it! Thanks a lot!
@guillermoramirez668
2 жыл бұрын
thank you so much, this was so helpful for my!.
@CodingIsFun
2 жыл бұрын
Happy to hear that. Thanks for watching the video and taking the time to leave a comment! :)
@lettherebelight6910
11 ай бұрын
Grrr im getting an error "404" Requested resource not found.... Looks like the URL address isn't being recognized
@CodingIsFun
10 ай бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@basilharoon6767
2 жыл бұрын
Hi, Thank you very much for your great efforts. Is there a way for us to use alphanumeric sender ID? I have Twilio account set up and its enabled there.
@CodingIsFun
2 жыл бұрын
Thanks! After looking at the Twilio documentation, you should be able to use the alphanumeric sender ID instead of the 'From' number. In that case, you need to do a minor modification to the VBA code. See below: www.screencast.com/t/fALxy0QK Twilio reference: support.twilio.com/hc/en-us/articles/223181348-Alphanumeric-Sender-ID-for-Twilio-Programmable-SMS I hope this helps!
@PaulaKornegayNC
3 жыл бұрын
Is there a way to have a future scheduled date? If I want to schedule an sms for next week to go out instead of having to do it real time?
@CodingIsFun
3 жыл бұрын
Thanks for watching the video & your questions. I have not come across any good solution that lets you schedule VBA code. That said, perhaps the following article might help: www.myonlinetraininghub.com/scheduling-macros-in-excel-with-application-ontime
@PaulaKornegayNC
3 жыл бұрын
@@CodingIsFun - great! thanks for all the info!
@RafiqulIslamloanofficer
2 жыл бұрын
I need help about to set up with this twilio. But i do not know any coding . Is there any way you can help me out .
@CodingIsFun
2 жыл бұрын
Thanks for watching the video. There is no further coding required from your side. * Download the Excel template here: pythonandvba.com/twilio-sms-sender * Enter your Account SID & Token as shown in the video ...and you are ready to send our SMS via the Twilio API
@tansinghrathore4572
2 жыл бұрын
hello my requirements is Whenever i run my code it should save all unread messages from all chats, in the excel along with media if any. it is possible with twillio
@CodingIsFun
2 жыл бұрын
I don't have such a solution
@tansinghrathore4572
2 жыл бұрын
@@CodingIsFun thank you for replying 👍
@egvNY
3 жыл бұрын
Excellent video, although I keep getting "upgrade required". If I send it to my phone using the console, it is ok, also port8843 is active and the TLS updated version. I gave up
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. Sorry to hear that you are facing difficulties. Is there any more information in the error message? If you are using the free trial version of Twilio, you can only send SMS to pre-registered phone numbers. Perhaps this might be the issue.
@Lifebang
2 жыл бұрын
can it send to mutiple numbers?
@CodingIsFun
2 жыл бұрын
Yes
@hmwgcuf9668
3 жыл бұрын
Hello Sir, Thank you so much for your video, Can you please guide me how can i send sms in bulk using your code, like i can upload the numbers (receivers) file in excel format and can send them the messages on one click. Thank you.
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. I might misunderstand you, but this is exactly what I am covering in the video. You could paste the numbers in column B and send the messages with a single button click.
@trieudinh8570
Жыл бұрын
Hello sir , thanks for the video , can you guide me on how I can use the same TEXT MESSAGES for all the numbers i pasted in the COLUMN B ….i hope you understand me like i want to send the same MESSAGES to all the numbers …how do i do it ???
@allnaijashopsads5822
3 жыл бұрын
Great video but I am getting this error on mac: Run time error 429; Component can't create object. When I tried to debug, it point me to this code -> Set Request = CreateObject("MSXML2.ServerXMLHTTP.6.0"). Please help.
@CodingIsFun
3 жыл бұрын
Thank you very much for watching the video. Unfortunately the XMLHTTP Reference library works only on Windows - sorry! 😕
@stephaniemarin
Жыл бұрын
Great video, Is there a way to attached a pdf file to the text?
@CodingIsFun
Жыл бұрын
Thanks for watching. To attach a pdf, you would need to adjust the VBA code. Also, it is mentioned, that is only supported in the US and Canada: support.twilio.com/hc/en-us/articles/360056727314-Carrier-support-for-PDF-files-sent-using-Twilio-MMS I hope it helps! Happy Coding!
@stephaniemarin
Жыл бұрын
@@CodingIsFun Thank you for the reply, is there a tutorial or a class that i can purchase to learn how to send pdf attachments in excel? thank you
@amirfakhim7797
2 жыл бұрын
Hi, Great Video, thank you for sharing. I am getting error when the code hits: Private Function json_ParseObject(json_String As String, ByRef json_Index As Long) As Dictionary line. Any help you can please provide? Many thanks.
@CodingIsFun
2 жыл бұрын
Are you on a mac?
@diegocastiblanco2905
2 жыл бұрын
@@CodingIsFun I have the same problem, I am on a mac, what can i do?
@CodingIsFun
2 жыл бұрын
@@diegocastiblanco2905 I do not have a solution for mac
@horatiupistol373
Жыл бұрын
Great job. What should be changed in the VbA code to make the solution work for Telnyx instead of Twilio. Telnyx has better rates. I would really appreciate. Tks!!
@CodingIsFun
Жыл бұрын
Thanks for watching. Each API is different. Hence, you would need to look at the API docs from Telnyx to adjust the VBA code. Happy Coding!
@surreyincanada
Жыл бұрын
Has anyone figured out how to insert a link in message text body e.g If I want to send a notification via this saying" Please click on this link to get details" where link will be a hyperlink to a site.
@CodingIsFun
Жыл бұрын
You can also insert links in the text. Please try it out. Here is what the SMS looked on my phone: dl3.pushbulletusercontent.com/Tbu8fhOQEWEeGvF6PPE1asX1DTT3n6id/Screenshot_2023-01-14-10-59-32-605_com.android.mms.jpg
@kemalgunay3999
Жыл бұрын
macbook didn't work either. how can i run it?
@CodingIsFun
Жыл бұрын
It only works for Windows
@ShawnPeschel
3 жыл бұрын
Amazing and easy to use. I've only had one issue and it appears that you can only text 79 characters from the Text Message field. Is there a fix for this? I would love to be able to send the whole 160 characters.
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. I have just tested it out - I could send the whole 160 characters in one message. I am not sure why it is not working on your end 😕
@ShawnPeschel
3 жыл бұрын
@@CodingIsFun Figured out why my message was getting cut off. I have an "&" (ampersand) in my message and it stops at the "&". If I change it to "and" then it sends. Do you know how to edit so I can use the "&"? BTW. Thank you for following up!!!
@ShawnPeschel
3 жыл бұрын
@@CodingIsFun Figured out how to use the &!!! Use %26 in place of the & and it'll work :) Thanks again for your work.
@amirfakhim7797
2 жыл бұрын
Hi, I changed the POST to GET and I can connect to Twilio. But my request is being rejected and I am getting Error Code 20011 Saying: "INVALID TLS Version" , The request was rejected because it was not correctly configured to use TLSv1.2 . All new accounts are required to use TLSv.12 with supported cipher suites. Could anyone help please? Thank you.
@CodingIsFun
Жыл бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@reliablechauffuerinc.388
2 жыл бұрын
Is there a way to receive msg's as well?
@CodingIsFun
2 жыл бұрын
It is possible. But you would need to configure a webhook. Kindly have a look at the Twilio docs: www.twilio.com/docs/runtime/quickstart/serverless-functions-receive-inbound-sms
@alphantaguinod9057
2 жыл бұрын
Holy cow! you saved my job. Thank you!
@CodingIsFun
2 жыл бұрын
A pleasure. Glad you like the solution
@23inchesolives84
Жыл бұрын
What do you do
@sinalydembele7442
2 жыл бұрын
It don't work for me please help. Message error: Runtime error '-2147012867 (80072efd)': Unable to establish a connection with the server
@CodingIsFun
2 жыл бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@truckinsurance7966
2 жыл бұрын
Hello i have not be able to get the workbook, the browser does not aloud me. Is there a way you can get it to me. Thanks
@CodingIsFun
2 жыл бұрын
Hi. Please click the following download button: www.screencast.com/t/WvKWd1F1HX1w Thanks!
@truckinsurance7966
2 жыл бұрын
@@CodingIsFun Twilio SMS excel? link ! . You sent PNG
@CodingIsFun
2 жыл бұрын
@@truckinsurance7966 You can download the Excel file from that website
@truckinsurance7966
2 жыл бұрын
@@CodingIsFun if i click on it, it pops a PNG picture file. No downloads link, can i buy from your website?
@truckinsurance7966
2 жыл бұрын
i need your services, can we talk/
@jordansantley534
2 жыл бұрын
Is there any way to attach a link to the Text Message?
@CodingIsFun
2 жыл бұрын
Thanks for watching the video. I assume you could simply write the link in the 'Text Message' column (I have not tested it). Or do you get any errors?
@LegendaryAngelX
Жыл бұрын
I keep getting Compile Error: Can't find project or library
@CodingIsFun
Жыл бұрын
Thanks for watching. Hard to tell from a distance why you are facing an error. Sorry, that I cannot help
@gondkarsir
3 жыл бұрын
I have got the message ( Status Text: {"code": 20011, "detail": "Invalid TLS version", "message" ) how to solve this issue
@CodingIsFun
3 жыл бұрын
Thank you for watching the video. I just tested it out - the code was still working on my side, and I could send messages using the template I have attached in the description box. I have tried to google your error code, but with no success. I am not quite what the error could be or how to fix it - sorry!
@gharbisedky
2 жыл бұрын
Hello, I am confronted with this same problem, have you solved this one?
@afzalkhanmiefellow8661
Жыл бұрын
It's free or price?
@CodingIsFun
Жыл бұрын
The template is free and Twilio is a paid service
@HowdHooo
9 ай бұрын
That is good...
@CodingIsFun
9 ай бұрын
Glad you liked it. Thanks for watching :)
@DiazZaid
3 жыл бұрын
hi friend.. how to add delay and call contact name variable
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. You can include a delay time as follows, e.g. 10 seconds: Application.Wait (Now + TimeValue("0:00:10")) For the variable name, you would need to tweak the code a little further. Example placeholder {NAME}. In the VBA code, you can use Replace("{NAME}", "Peter"). I hope this helps!
@DiazZaid
3 жыл бұрын
@@CodingIsFun thanks i will try
@johntsai0x0
Жыл бұрын
My test stop at "Request.send postData" line. How to solve it?
@CodingIsFun
Жыл бұрын
Please download the workbook from the description and try again. Also, please let me know if you are Windows or not. Thanks!
@johntsai0x0
Жыл бұрын
@@CodingIsFun yes. I download ur workbook. I follow ur video to create a new module, but run into test error. I'm using windows 10
@CodingIsFun
Жыл бұрын
@@johntsai0x0 Sorry, then I am not sure why you are receiving an error.
@johntsai0x0
Жыл бұрын
@@CodingIsFun found the issue From ur doc, the set request was Microsoft.XMLHTTP From video, it is MSXML2.ServerXMLHTTP.6.0 It's the object that cause request postdata issue.. Any idea?
@johntsai0x0
Жыл бұрын
@@CodingIsFun If I leave set request to Microsoft.XMLHTTP, message send with code 201. It's a success, but I need to add 1 in from of area code to make it work. Here comes new question. 1. How to send msg without edit my phone number with 1 in front of it? 2. How to edit body in long text message like paragraph with media image attached from the link? Thx
@feriamontreal5554
2 жыл бұрын
magic !!!!
@CodingIsFun
2 жыл бұрын
🧙♂🧙♂
@mirechatterfogsjbhanica7137
2 жыл бұрын
Hello
@CodingIsFun
2 жыл бұрын
Hi!
@speedycashfinance3363
Жыл бұрын
Hi, I've just watched your video and I am gonna try this if this doesn't work so is there any way I reach you through email or whatsapp number? I know you don't work for free beside KZitem I really need your help if this workout for me that would life saver so am hoping for your response I just need to send bulk SMS. Thank you
@CodingIsFun
Жыл бұрын
Thanks for watching. Glad you like the solution. Feel free to reach out: pythonandvba.com/contact
Пікірлер: 167