Amazing video! we used this video to create a way to send text messages directly from Excel and through your phone and SIM card! Thank you for this video! 100% useful! 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
@CodingIsFun
Жыл бұрын
Thanks for watching. Glad you like the solution!
@CodingIsFun
3 жыл бұрын
*Download the Excel template here:* pythonandvba.com/sevenio-excel-template Please note that 'sms77.io' has updated to 'seven.io.' Following your feedback, I've upgraded the template to include placeholders and enable the sending of more messages simultaneously. For more information, click the link above. Cheers, Sven ✌
@user-kd8zs8zj8q
2 жыл бұрын
Man, thank you for this video!!! I am making Course Work now. And your guide have given me important information. THANK YOU FOR THIS!!!
@CodingIsFun
2 жыл бұрын
A pleasure! Thanks for watching the video :)
@sharko1046
3 жыл бұрын
Nice 👌 sir , love from India 💓
@CodingIsFun
3 жыл бұрын
Thank you! 🙏 Glad you enjoyed the video!
@sevenAndre
3 жыл бұрын
Thanks a lot for the good tutorial! You can even send text-to-speech messages if you replace /api/sms? with /api/voice? Highly appreciated!
@CodingIsFun
3 жыл бұрын
Hi André. Thank you very much for the hint! 👍😉
@igorwork8908
3 жыл бұрын
Thank you so much for sharing your knowledge, great video!
@CodingIsFun
3 жыл бұрын
A pleasure, thanks for watching! 😃
@segunoloye847
10 ай бұрын
I'm very glad for your video, thank you. But pls I like to ask, what if you want the SMS to send automatically as a reminder for instance when a product will expire in 7 days without you sending it manually
@CodingIsFun
10 ай бұрын
Thank you for watching. In that case, I would suggest using another programming language, for example, Python, and setting up a script on the cloud to periodically send out SMS via an API. In the past, I created a similar use case, but it involved sending out emails. Perhaps that video could be a starting point: kzitem.info/news/bejne/sIKoqWiAa1-hqaAsi=Kc13CBfkYgtdaOvW Happy Coding, and good luck with your project.
@user-ll1wb7wd8h
2 жыл бұрын
VERY GOOD LESSON, THANKS.
@CodingIsFun
2 жыл бұрын
Thank you! :)
@dqtc1qtam
Жыл бұрын
I am from vietnam, I downloaded the example and test, unfortunately when i fill my mobile phone (phone number which send to) and API key in excel and sent but my mobile phone still not received message. Please show me why i still not received message
@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. You might want to try out the Twilio or Pushbullet solution as an alternative. You can find both videos on my channel.
@SIT_NIGER
2 жыл бұрын
very Nice tutorial, thank you.
@CodingIsFun
2 жыл бұрын
Thanks for watching!
@MohamedHamada052
5 ай бұрын
How can i use it with excel userform from access database to activate my program designed in excel
@CodingIsFun
5 ай бұрын
You could do with that VBA. Happy Coding! Cheers, Sven ✌️
@InZa2
3 жыл бұрын
I have an idea why you dont make a game in vba ...sounds good thanks 4 video
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. Interesting idea, thanks for the suggestion. Actually, last weekend I got my feet wet with Game development using Unity & C#. I have never thought about making a game in VBA tho 😅
@stubstudy-azerbaijan7432
6 ай бұрын
Sir thank you for the video But it doesn't work in my excel. I just get this msg: {"success":false,"code":901,"message":"Nonce is invalid"} Can you help me?
@CodingIsFun
6 ай бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help. Cheers, Sven ✌️
@yosef-yosef9414
Жыл бұрын
Thank you for this
@CodingIsFun
Жыл бұрын
You're very welcome! Thank you for watching and for the comment!
@hervensinga6683
Жыл бұрын
Thank for your video i use the vba code in the description in me access 2010, but i have an error in vba telling me that the parameter are incorrect. please some help
@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.
@missmichelleaw
Жыл бұрын
Do you have an example of grabbing all the inbound texts from the API using VBA?
@CodingIsFun
Жыл бұрын
Thanks for watching. No, I don't have
@peterwuytsgenos2481
2 жыл бұрын
I can't find the visual basic code (example) to send an attachement (file) with an sms... ?
@CodingIsFun
2 жыл бұрын
Thanks for watching. Yes, you cannot send attachments.
@vanoski8712
2 жыл бұрын
thank you so much
@CodingIsFun
2 жыл бұрын
You're very welcome! Thank you for watching and for the comment!
@garycurtis
Жыл бұрын
Excellent video, I have a question. How can I incorporate adding the message service sid into the code?
@CodingIsFun
Жыл бұрын
Thanks for watching. I am not sure if that is possible with sms77.io
@amandusabren4149
Жыл бұрын
Hi am using Arkesel to send messages by browsing and attaching excel file to the site. I now want to use a single click from excel. I watched your video but I haven't been able to make it work with Arkesel. Help please, I will pay if I have to.
@CodingIsFun
Жыл бұрын
Thanks so much for watching the video and leaving a comment! 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!
@amandusabren4149
Жыл бұрын
Sure, I do. Are the codes for another service provider totally different? Aren't there few similar parts? Am learning coding, am not there already eady.
@CodingIsFun
Жыл бұрын
@@amandusabren4149 Each API is different. Have a look at the official documentation: developers.arkesel.com/#section/Status-Responses(V2) Happy Coding!
@amandusabren4149
Жыл бұрын
Thank you for the heads up but am not really a developer. I've tried to get help from a lot of places without success. If you happen to rethink of my issue I'll really appreciate if you'd come with a different answer. I will still appreciate your response either way.
@mercrotii9297
2 жыл бұрын
Hello, Over there. I am trying to send SMS using VBA, getting a success response of 100 on Excel but message is not delivered to my phone. What could be the issue? Please assist.
@CodingIsFun
2 жыл бұрын
Sorry, I am not sure why the message is not delivered.
@YehLoh
2 жыл бұрын
how to automate it to run this "send sms" macro whenever a specific message/text appears in message box.
@CodingIsFun
2 жыл бұрын
Thanks for watching the video & your question. That is not possible with this solution - sorry! 😕
@Deatheye_music
3 жыл бұрын
Unfortunately it doesn't work for me and I was really looking forward to it. I downloaded your file with the bulk SMS. But keep getting error 403. Hope for your help
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. I just tested it out again, and the API is still working on my side. According to the documentation, a 403 error occurs because of: "Max. limit per day reached for this number." However, I guess this might be not the case for you. Tomorrow, I will upload an alternative solution to send SMS from your OWN phone number using Excel. Perhaps that solution will work for you.
@assisribeiro8451
7 ай бұрын
Muito bom, obrigado.
@CodingIsFun
7 ай бұрын
My pleasure! Appreciate you taking the time to watch and leave a comment.
@mohamedelaraby3556
Жыл бұрын
HI Thanks for the great Video, I have 2 Problems, 1st : the website SMS77 is always saying registration is rejected i cant make any account dont know why, second: the sheet is not working because I'm using 32 bit excel , can you help Please
@CodingIsFun
Жыл бұрын
Thanks for watching. You might want to try out another template/service. Have a look here: kzitem.info/door/PL7QI8ORyVSCbL1ylVlhaFgum690xtwYz8
@UncleLeeAdventures
3 жыл бұрын
I am trying to find your earlier video on sending bulk WhatsApp using Excel VBA but could not be found. I encountered a problem today where I am not able to send any media files like jpg or jfif. I was able to do so in the past. Now it says "sent with a timestamp" but receiver never receives it. Normal text is fine.... What could be the problem? Appreciate your help.
@CodingIsFun
3 жыл бұрын
Sorry for that, but YT removed the video. Kindly try to increase the delay time, e.g. to 8 seconds. This should solve the issue. Thanks.
@UncleLeeAdventures
3 жыл бұрын
@@CodingIsFun I tried that but it did not solve the problem. Any other suggestions?
@UncleLeeAdventures
3 жыл бұрын
@@CodingIsFun It worked now when I increased the delay to 8 seconds. Baffles me why it didn't work earlier. What do you think could be the cause? Thanks
@CodingIsFun
3 жыл бұрын
@@UncleLeeAdventures Happy to hear that it is now working. Depending on the internet connection & file size, the time to send media/documents varies. If you switch to the next message too soon, the media/documents will not be sent (yet the script will indicate no error). I have tried to prevent this by using a variable delay time: For a 2MB File, the script will wait an additional delay of 1 second on top of the default delay time. Yet, in some cases, this might not be enough. Hence my suggestion to increase the default delay time.
@UncleLeeAdventures
3 жыл бұрын
@@CodingIsFun Thank you so much for your explanation of how the code works!
@abdulhamidalhaddadi2255
Жыл бұрын
Thank you
@CodingIsFun
Жыл бұрын
You're welcome! Thanks for watching the video and for your comment!
@hydrogenperoxide4848
3 жыл бұрын
Thank you Sir, your tutorial was great. How can we send sms with our company name.? Is there any option here? Waiting for your precious reply. Thanks
@CodingIsFun
3 жыл бұрын
*Hello Hydrogen Peroxide, thanks for watching the video and your comment.* You could pass the optional parameter into the URL (documentation: www.sms77.io/en/docs/gateway/http-api/sms-disptach/) I just have tested it. See below the example for the adjusted VBA Line: Url = "gateway.sms77.io/api/sms?p=" & APIKEY & "&to=" & toNumber & "&text=" & BodyText & "&details=1" & "&from=91111111111"
@khadija7303
2 жыл бұрын
Thank you for your insightful video i have a question: is there a way to send a message teams using vba?
@CodingIsFun
2 жыл бұрын
A pleasure! Do you want to send a message to Microsoft Teams using VBA?
@khadija7303
2 жыл бұрын
@@CodingIsFun yes
@CodingIsFun
2 жыл бұрын
@@khadija7303 Use the following VBA code: pastebin.com/cp71HwjJ Change the 'Text' and 'Webhook'. Here is how to get the webhook: docs.microsoft.com/en-us/microsoftteams/platform/webhooks-and-connectors/how-to/add-incoming-webhook Enjoy!
@khadija7303
2 жыл бұрын
@@CodingIsFun really big thanks for u
@informationoffice6814
3 жыл бұрын
Thank you for sharing this helpful piece... i want to know if this can sent to multiple phone numbers at a periodic space of time
@CodingIsFun
3 жыл бұрын
Thank you for watching the video. If you want to send multiple messages, please use this workbook [Google Drive]: ► bit.ly/38r4IkD
@SIT_NIGER
2 жыл бұрын
Thank you sir! I want to kown how to send the sms without opening the sms77 URL in navigator first ? to let the code vba do it in hidden
@khadija7303
2 жыл бұрын
Can i linking outlook web with vba or vba works just for desktop application
@CodingIsFun
2 жыл бұрын
I have not tried it yet, but you could try using the REST API from Microsoft in VBA to interact with the Outlook web app: docs.microsoft.com/en-us/outlook/rest/get-started
@khadija7303
2 жыл бұрын
@@CodingIsFun thank u for ur help
@madrashabaitululoom6180
Жыл бұрын
I am speaking from Bangladesh. I need this sheet. please help me
@CodingIsFun
Жыл бұрын
Thanks for watching. What exactly is the issue? Feel free to use another API
@rolandpeter2596
3 жыл бұрын
I have an excel with more than 1000 different client phone numbers and as soon as they are ready for a follow-up treatment, I would like to send them a text message as a reminder. Do I need to create for each client a send button based on your tutorial, or can I simply send a text message to all the clients which met the criteria "ready for follow-up treatment"? Any help is appreciated.
@CodingIsFun
3 жыл бұрын
Thank you for watching the video. You could use the following template to send text messages to multiple numbers. 👉 bit.ly/38r4IkD Or if you are using 'Twilio', you could use the following one: 👉 bit.ly/3y6T61k If you want, I could also add another column for you, like in the example below: prnt.sc/138wag9 Hope it helps.
@rolandpeter2596
3 жыл бұрын
@@CodingIsFun Vielen Dank!
@rolandpeter2596
3 жыл бұрын
@@CodingIsFun That extra column makes sense as you simply want to send out the text message when someone is actually ready for another treatment. (depends mainly on a certain amount of weeks) Let me see if I can implement it. Thanks again!
@iteduservice7555
2 жыл бұрын
@@CodingIsFun
@iteduservice7555
2 жыл бұрын
@@CodingIsFun
@mrdog-yx9oi
2 жыл бұрын
How do i make it so that i can send all the messages with other phone numbers by just 1 button?
@CodingIsFun
2 жыл бұрын
Thanks for watching! Here is one idea: 1) Include the 'From' number in the API request: www.screencast.com/t/mk9D5TnD 2) Link this from number to your worksheet, e.g. cell A1 3) Insert a drop-down list in cell A1, where you can select the different 'From' numbers: www.excel-easy.com/examples/drop-down-list.html I hope you understand that I do not have time to code the example for you. Happy Coding! :)
@oni9773
Жыл бұрын
Hi, is it possible to send student marks individually at one click from database?
@CodingIsFun
Жыл бұрын
If you know how to program in VBA, then yes.
@oni9773
Жыл бұрын
@@CodingIsFun sorry, I don't. Umm, do you have any videos regarding that topic?
@CodingIsFun
Жыл бұрын
@@oni9773 Nope
@truetrue669
2 жыл бұрын
Do you have anything that works with an 8 port gsm modem???
@CodingIsFun
2 жыл бұрын
Unfortunately not.
@truetrue669
2 жыл бұрын
@@CodingIsFun can you create something???
@CodingIsFun
2 жыл бұрын
@@truetrue669 Sorry, but probably not, as this is an extraordinary use case. I hope you can understand.
@Hibcon
3 жыл бұрын
Is it possible to make this with Google Messages? I dont mind if its paid or not
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. I have not tried it out yet. But theoretically, it should also work :)
@alrabiwash5217
3 жыл бұрын
Can this send in bulk? I have Telnyx api. Thanks
@CodingIsFun
3 жыл бұрын
Thank you for watching the video. Yes, you could adjust the code to send SMS from Excel using the Telnyx API. The corresponding API reference can be found here: developers.telnyx.com/docs/v2/messaging If you need any support, feel free to reach out to me via mail: contact@pythonandvba.com Thank you! :)
@s3cTor0
3 жыл бұрын
Can you make one with pushbullet API?
@CodingIsFun
3 жыл бұрын
Thanks for your video suggestion. I will have a look into it.
@atuljustin
2 жыл бұрын
Is it free to send bulk sms?
@CodingIsFun
2 жыл бұрын
No
@1029eddy
2 жыл бұрын
Can i use my phone to send SMS?
@CodingIsFun
2 жыл бұрын
Yes, you can use the following solution: kzitem.info/news/bejne/t62wx4KgqZV2jWU
@lifeiscrazy2146
3 жыл бұрын
Preety nice.........but i got status code 500.how to solve this error pls help me
@CodingIsFun
3 жыл бұрын
Status Code 500 means that there is too little credit available. Could you kindly check your account balance? Thank you!
@SuperGaurangray
Жыл бұрын
How you can send mms using same?
@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!
@zawarnd1
2 жыл бұрын
Please make ledger book with sms api
@CodingIsFun
2 жыл бұрын
Thanks for watching the video & your suggestion!
@Chad-md4jg
4 ай бұрын
How to send one message to multiple numbers?
@CodingIsFun
4 ай бұрын
Write down all the receiver numbers in the respective column, one row for each receiver. Then, copy and paste the same message into each row. Cheers, Sven ✌️
@Chad-md4jg
4 ай бұрын
@@CodingIsFun can you send me a sample spreadsheet? I need it badly
@CodingIsFun
4 ай бұрын
@@Chad-md4jg nope, you can try it out yourself ;)
@Chad-md4jg
4 ай бұрын
So if i follow your step, will ill be sending the message in many numbers in 1 click?
@Chad-md4jg
4 ай бұрын
When i send sms it says Microsoft Excel 900
@MarkPricekelownamortgagebroker
2 жыл бұрын
Thank you. Can you also send a mms?
@CodingIsFun
2 жыл бұрын
As far as I can see from the documentation, you can also send attachment links: www.sms77.io/en/docs/gateway/http-api/sms-dispatch/#file-attachments
@mdhashmath9353
2 жыл бұрын
Sir error on line no 210 send SMS
@CodingIsFun
2 жыл бұрын
...and what does the error say?
@thanveersultana5690
2 жыл бұрын
How to send sms for multiple numbers
@CodingIsFun
2 жыл бұрын
If you want to send multiple messages, please use this workbook [Google Drive]: ► bit.ly/38r4IkD
@MR.ReddyBlasters
Жыл бұрын
Bro api key is not showing How get api key
@CodingIsFun
Жыл бұрын
Read the pinned comment, thanks!
@MR.ReddyBlasters
Жыл бұрын
@@CodingIsFun bro i am not finding api key mam
@CodingIsFun
Жыл бұрын
@@MR.ReddyBlasters bro, here it is! www.screencast.com/t/0iiSvuFrdQKP
@MR.ReddyBlasters
Жыл бұрын
@@CodingIsFun thanks a lot
@sulalithasannasgala
Жыл бұрын
How to send sms using python
@CodingIsFun
Жыл бұрын
You can send SMS using Python by using an SMS API provider. Here is an example using the Twilio API: First, you need to sign up for a Twilio account and get your Account SID and Auth Token from the Twilio console. Install the Twilio Python library using pip: pip install twilio Use the following code to send an SMS using the Twilio API: # Import the Twilio client from twilio.rest import Client # Your Account SID and Auth Token from twilio.com/console account_sid = 'your_account_sid' auth_token = 'your_auth_token' client = Client(account_sid, auth_token) # Use the Twilio API to send an SMS message message = client.messages.create( body='Hello, World!', from_='your_twilio_phone_number', to='recipient_phone_number' ) # Print the message SID print(message.sid) I hope it helps! Happy Coding & Sending!
@amandusabren4149
Жыл бұрын
Thank you for the heads up but am not really a developer. I've tried to get help from a lot of places without success. If you happen to rethink of my issue I'll really appreciate if you'd come with a different answer. I really need this to work with Arkesel API. I insist that I will pay for the service. I have tried so hard. I will still appreciate your response either way, but am begging you.
@CodingIsFun
Жыл бұрын
Feel free to hit me up at contact@pythonandvba.com. Just let me know what you need exactly. We're all super busy, right? So, to skip the back-and-forth emails, just make sure to spell out what you're looking for. I'll give you an estimate on the cost as soon as I can. Thanks!
@amandusabren4149
Жыл бұрын
I appreciate I have already sent it.
@pragusofficial8823
3 жыл бұрын
Please help me translite language Indonesian
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. How exactly can I help you?
@pragusofficial8823
3 жыл бұрын
If possible, please Indonesian subtitles for the video
@CodingIsFun
3 жыл бұрын
@@pragusofficial8823 Sorry, this will be a little difficult for me 😕
@kampungexcelownerbebenangg8336
3 жыл бұрын
free or no key api
@CodingIsFun
3 жыл бұрын
*Thanks for watching the video & your comment.* I did not find any free or no API Key solution 😌
@kampungexcelownerbebenangg8336
3 жыл бұрын
im try can't find setting api key
@CodingIsFun
3 жыл бұрын
@@kampungexcelownerbebenangg8336 The link to the API has been changed. You can create an API KEY now as follows: 👉 pasteboard.co/JR3auFe.png Hope it helps 🙏 Cheers, Sven
@fksoftware
3 жыл бұрын
Thank you for sharing this great knowledge. I tried to replicate the same code with different sms gateway but it's not working. Please I need your e-mail id to send you the API KEY and the user id.
@CodingIsFun
3 жыл бұрын
*Thanks for watching the video* Please feel free to reach out to me via mail: ✉ contact.coding.is.fun@gmail.com
@fksoftware
3 жыл бұрын
Thank you Sir for your help. It works perfectly fine.
@CodingIsFun
3 жыл бұрын
@@fksoftware glad to hear that :)
@user-ks1el2fz6m
Жыл бұрын
Free unlimited massages I only need to buy API
@user-ks1el2fz6m
Жыл бұрын
????
@CodingIsFun
Жыл бұрын
I do not know what you mean
@David-kj1vm
Жыл бұрын
you dont 3rd party program
@CodingIsFun
Жыл бұрын
I don't know what that means
@lorenacastelvi8460
3 жыл бұрын
Thank you so much for sharing your knowledge, great video!
@CodingIsFun
3 жыл бұрын
Hi Lorena, *I am glad you liked the video, thanks for watching and for your comment!*
Пікірлер: 164