How To Send SMS Messages From Excel With VBA | Step-by-Step Tutorial 💬
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- 👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱 𝘁𝗵𝗲 𝗘𝘅𝗰𝗲𝗹 𝘁𝗲𝗺𝗽𝗹𝗮𝘁𝗲 𝗵𝗲𝗿𝗲: pythonandvba.com/sevenio-exce...
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 ✌️
✅ Chapters:
0:00 Demo
0:32 How it works
3:18 VBA Code
06:46 Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: pythonandvba.com/coffee-donation
![How To Send Bulk SMS From Excel With TWILIO + VBA [Excel Template]](http://i.ytimg.com/vi/i_HgBaL_xjE/mqdefault.jpg)
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! 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
Thanks for watching. Glad you like the solution!
*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 ✌
Man, thank you for this video!!! I am making Course Work now. And your guide have given me important information. THANK YOU FOR THIS!!!
A pleasure! Thanks for watching the video :)
Thank you so much for sharing your knowledge, great video!
Hi Lorena,
*I am glad you liked the video, thanks for watching and for your comment!*
Nice 👌 sir , love from India 💓
Thank you! 🙏 Glad you enjoyed the video!
VERY GOOD LESSON, THANKS.
Thank you! :)
very Nice tutorial, thank you.
Thanks for watching!
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!
Hi André. Thank you very much for the hint! 👍😉
Thank you for this
You're very welcome! Thank you for watching and for the comment!
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
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: th-cam.com/video/OLrC4J2-pvk/w-d-xo.htmlsi=Kc13CBfkYgtdaOvW
Happy Coding, and good luck with your project.
Excellent video, I have a question. How can I incorporate adding the message service sid into the code?
Thanks for watching. I am not sure if that is possible with sms77.io
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
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
how to automate it to run this "send sms" macro whenever a specific message/text appears in message box.
Thanks for watching the video & your question. That is not possible with this solution - sorry! 😕
thank you so much
You're very welcome! Thank you for watching and for the comment!
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
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.
Muito bom, obrigado.
My pleasure! Appreciate you taking the time to watch and leave a comment.
Do you have an example of grabbing all the inbound texts from the API using VBA?
Thanks for watching. No, I don't have
I can't find the visual basic code (example) to send an attachement (file) with an sms... ?
Thanks for watching. Yes, you cannot send attachments.
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.
Sorry, I am not sure why the message is not delivered.
Thank you for your insightful video i have a question: is there a way to send a message teams using vba?
A pleasure! Do you want to send a message to Microsoft Teams using VBA?
@@CodingIsFun yes
@@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!
@@CodingIsFun really big thanks for u
How can i use it with excel userform from access database to activate my program designed in excel
You could do with that VBA. Happy Coding! Cheers, Sven ✌️
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.
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.
@@CodingIsFun I tried that but it did not solve the problem. Any other suggestions?
@@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
@@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.
@@CodingIsFun Thank you so much for your explanation of how the code works!
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
Thanks for watching. You might want to try out another template/service. Have a look here: th-cam.com/play/PL7QI8ORyVSCbL1ylVlhaFgum690xtwYz8.html
Thank you
You're welcome! Thanks for watching the video and for your comment!
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
Thank you for watching the video.
If you want to send multiple messages, please use this workbook [Google Drive]:
► bit.ly/38r4IkD
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
Can i linking outlook web with vba or vba works just for desktop application
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
@@CodingIsFun thank u for ur help
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.
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.
@@CodingIsFun Vielen Dank!
@@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!
@@CodingIsFun
@@CodingIsFun
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
*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"
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
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.
Hi, is it possible to send student marks individually at one click from database?
If you know how to program in VBA, then yes.
@@CodingIsFun sorry, I don't. Umm, do you have any videos regarding that topic?
@@oni9773 Nope
Can you make one with pushbullet API?
Thanks for your video suggestion. I will have a look into it.
Do you have anything that works with an 8 port gsm modem???
Unfortunately not.
@@CodingIsFun can you create something???
@@truetrue669 Sorry, but probably not, as this is an extraordinary use case. I hope you can understand.
Can this send in bulk? I have Telnyx api. Thanks
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! :)
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.
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!
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.
@@amandusabren4149 Each API is different. Have a look at the official documentation: developers.arkesel.com/#section/Status-Responses(V2)
Happy Coding!
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.
Is it possible to make this with Google Messages? I dont mind if its paid or not
Thanks for watching the video. I have not tried it out yet. But theoretically, it should also work :)
How do i make it so that i can send all the messages with other phone numbers by just 1 button?
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! :)
Preety nice.........but i got status code 500.how to solve this error pls help me
Status Code 500 means that there is too little credit available. Could you kindly check your account balance? Thank you!
I am speaking from Bangladesh. I need this sheet. please help me
Thanks for watching. What exactly is the issue? Feel free to use another API
I have an idea
why you dont make a game in vba ...sounds good
thanks 4 video
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 😅
Can i use my phone to send SMS?
Yes, you can use the following solution: th-cam.com/video/VwzaNjpcEZ0/w-d-xo.html
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?
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 ✌️
Sir error on line no 210 send SMS
...and what does the error say?
Is it free to send bulk sms?
No
How you can send mms using same?
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!
How to send sms for multiple numbers
If you want to send multiple messages, please use this workbook [Google Drive]:
► bit.ly/38r4IkD
Thank you. Can you also send a mms?
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
Please help me translite language Indonesian
Thanks for watching the video. How exactly can I help you?
If possible, please Indonesian subtitles for the video
@@pragusofficial8823 Sorry, this will be a little difficult for me 😕
Please make ledger book with sms api
Thanks for watching the video & your suggestion!
How to send one message to multiple numbers?
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 ✌️
@@CodingIsFun can you send me a sample spreadsheet? I need it badly
@@Chad-md4jg nope, you can try it out yourself ;)
So if i follow your step, will ill be sending the message in many numbers in 1 click?
When i send sms it says Microsoft Excel 900
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.
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!
I appreciate
I have already sent it.
How to send sms using python
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!
Bro api key is not showing
How get api key
Read the pinned comment, thanks!
@@CodingIsFun bro i am not finding api key mam
@@MR.ReddyBlasters bro, here it is! www.screencast.com/t/0iiSvuFrdQKP
@@CodingIsFun thanks a lot
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.
*Thanks for watching the video*
Please feel free to reach out to me via mail:
✉ contact.coding.is.fun@gmail.com
Thank you Sir for your help. It works perfectly fine.
@@fksoftware glad to hear that :)
free or no key api
*Thanks for watching the video & your comment.*
I did not find any free or no API Key solution 😌
im try can't find setting api key
@@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
Free unlimited massages I only need to buy API
????
I do not know what you mean
you dont 3rd party program
I don't know what that means
Thank you so much for sharing your knowledge, great video!
A pleasure, thanks for watching! 😃