🚨 *Please note: This solution only works on Windows + Android!* 🚨 I will be here in the comments section. Please provide your exact error message for any issues, and I will try to help.
I don't know how to thank you for this. It has made my work so much easier. I have been struggling for years to find a way to send bulk sms using my own number as i can't afford other options available. Thank you so much. I am very excited
Hey Kindly Can You Elaborate how to sens all the masseages at once , i have Completed all the steps and Messages are Sending also But at Once only . I have to manually Type The Sms In each and every Row of all the numerbs Or It will Automatically Send to all the pasted numbers . Plz help me out
brother i don't know how to thank you, you are really the best i was looking for a free solution for 3 months now, i was sending sms manually but now it's waaaaay easier, keep up the great content, you earned a subscriber !
Hey Kindly Can You Elaborate how to sens all the masseages at once , i have Completed all the steps and Messages are Sending also But at Once only . I have to manually Type The Sms In each and every Row of all the numerbs Or It will Automatically Send to all the pasted numbers . Plz help me out
Works perfectly. I was also able to modify the VBA and integrate this into my existing spreadsheet where i have a userform that writes customised messages. This is brilliant, thank you.
Happy to hear that. If you'd like to give me a caffeine boost, you can do so here: pythonandvba.com/coffee-donation. Your support is much appreciated! 🙏
Hi. Yes, it is possible, but it depends on your phone provider. Have a look at the following article: docs.pythonandvba.com/sms-blaster/faq/how-many-sms-messages-can-i-send-is-there-a-limit - Sven
In the video are you sending the same message to every person? What if you wanted to send a different message to every person. i.e. to customise each message with their name “Hello Tim” “Hello John”
Thanks for watching. You could add a new "Name" column and then concatenate your text in column C with the new name column. Here is an example: www.screencast.com/t/5m5CvPEN9P Hope it helps! Happy sending!
Thank you! Regarding your question: Sending the same message to multiple recipients is possible with the paid template available here: pythonandvba.com/sms-excel-template/. The paid template does support the use of placeholders. However, in the current version, it is not possible to use only one placeholder (e.g., for the first name) that will then be replaced depending on the recipient's number. That said, I am planning to incorporate that feature at some point in time.
Is the receiver able to report the message as spam? If they do for standard messages in Apple devices for example they could lose their iMessage capabilities right??
The messages are still sent from your smartphone. The recipient will have the same options as they do when you send an SMS directly from your smartphone when using the SMS Blaster.
Hello! I hope this finds you well and thank you very much for creating this great video. I would like to know before delving into it whether we can send one message to many contacts. Please let me know, thank you.
You can send one message per row. To send the same message to multiple numbers, copy the same message in every row (you can also use Excel formulas to refer to the first cell, for example). I hope it helps! Happy Sending!
Did I understand correctly? When I send an sms the way you showed in the video, the sms will be sent from my native sms app and the replies to the messages will arrive on my phone and not in the Pushbullet app?
That is absolutely correct. In the following video, I also briefly explain how it works: docs.pythonandvba.com/sms-blaster/guides/how-does-sms-blaster-send-sms-from-my-phone-and-whats-the-cost
@@CodingIsFun thank you! Is there a way to select certain numbers to sms? If you do not want to send to all contacts. NOTE: I have downloaded your Excel template.
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!
Thanks for watching. Yes, I also have a solution for WhatsApp: ua-cam.com/video/Wn9L1MD_y0Y/v-deo.htmlsi=mZm6j2uDGw6GQJW3 Happy Sending! Cheers, Sven ✌️
this is so awesome!!! thank you so much!! Coffee is on us! Is there a way to create a 1-5 seconds delay between a batch of 10 messages?? my operator keeps blocking me if I send more than 10-15 messages at once. Highly appreciate your work sir!! you are the Robin hood of coding!
Thanks for watching and the kind words. Coffee donations are always welcome :) pythonandvba.com/coffee-donation. Regarding your question, you can adjust the delay time between the messages in the VBA code. There is already a default delay applied. Feel free to change the value.
Hello Sir, great video ! Thanks a lot ! I implemented this for a customer, but I encountered a problem… since July every messages aren’t sent. But return a 200: ok code. I try another account, and another smartphone. Nothing to do.. have you got a similar problem, or heard something like this. Before July everything worked fine. Please let me know, it could be really helpful. Thanks in advance. ^^
@@CodingIsFun thanks for your prompt reply I’ll try to find a solution ASAP if it will work I’ll share here in case someone else encounter the same thing. Sincerely :)
Thanks. Wonder what Sender's number or Sender's Name would the receiver see on their device for this bulk SMS sent? I have unlimited SMS text for my mobile plan.
Thank you for watching the video. I went ahead and checked the Vonage Website. I could also create a custom solution for you. Feel free to shoot me an email: contact@pythonandvba.com Thanks!
Hi Sir. Applicationm works perfectly. Any ways to add delay between the SMS' like 10s between each, or variable delay (between 5s to 15s) to avoid being blocked by phone carrier. Thank you for your support
Happy to hear that! You can either manually adjust the delay time in the VBA code, which is currently set to 2 seconds, or you could upgrade to the PRO version. In the PRO version, you can set the delay time directly within the Excel sheet, along with some other nifty features: pythonandvba.com/sms-excel-template/ Happy sending! Cheers, Sven ✌️
Bro your code are amazing, but if i want to add dynamic messages in message column are formula are not set. Can you help out me .??? Or Can we link Google form with your already excel sheet ?? If yes ! Then how can I do that ?
Thanks for watching the video. Just delete the cell formatting in the "Text Message" column and use an Excel formula, e.g. concatenate. No, you can not *easily* combine it with Google Sheets.
Fantastic!, that was exactly what I needed. Thank you for this! but unfortunately I'm getting an error. Error Location is: Line no: 220 SendSMS.SendSMS. Please help
Thanks for the tutorial. Have you ever tested how many SMS you can send per hour with the pro plan. Do you ever get any bans, restrictions etc with your phone plan provider?
Thanks for watching! As I said in the video, messages come from your own phone, so they count towards your phone plan with your carrier. If you've got unlimited texts, you're all set. If not, keep in mind that sending texts through the PushBullet API is the same as texting by hand, cost-wise. Plus, you'll need Pushbullet Pro to send more than 100 messages a month. It's a good idea to check with your carrier about any message limits you might have.
One more questions, how do I set the time in between text messages sent. For example if I send out 50, how do I make it so in between each text is say 30 seconds.
I am sending sms from an excel sheet I’m running macros on to send individualized messages with their unique name and business name and a sentence or two from a list of potential customers I have met with’s business cards I’ve collected and exported from Covve scan. My problem is that my phone continues giving me a warning about push bullet and that it is sending too many sma and would I like to allow it to continue. I am getting this every small hand full of I amend messaging 250 at once. Am I able to set up a delay between sending sms automatically?
Thanks for watching. In the settings menu of the template, you can set a default and random delay between messages. Here is a tutorial on that: ua-cam.com/video/roLmCCHok2g/v-deo.htmlsi=zHQ1dAITq13F7x7U. I hope it helps! -Sven
Firstly Thanks for this great Tool! I would ask about my phone number I don't wanna people to see the phone number but see the name of my business you know that didn't make them comfortable. can I do that?
Probably the specific version 6.0 of msxml2.serverxmlhttp is not (properly) installed on the computer your script runs on. I have adjusted the code to create a version-independent object: Please try it again with the updated workbook: bit.ly/3cERjY7 I hope it helps! :)
Regarding waiting 30 seconds, is this because your phone signal wasn’t strong enough to send them every 2 seconds? I’ve tried using this system with the 2 seconds setting today and lots of the messages were stuck ‘failed to send.’ I had to go through and click ‘resend’ one-by-one in the phones message screen.
Thanks for watching. Very good question. Please find my answer here: docs.pythonandvba.com/sms-blaster/faq/how-many-sms-messages-can-i-send-is-there-a-limit Let me know if have any further questions. -Sven
Hi, The workbook is not giving me an option to send messages. After having the push bullet on the computer and on my cell phone. I badly need this solution I can pay you if it works for me . Will be truly grateful
@@CodingIsFun What about Libreoffice Calc? I assume it does not work on it, either. I have tried, without any success. But maybe I did something wrong with my Libreoffice Calc.
Hello and thank you so much for your work, I have a question though. I Am trying to use your instructions personalize the text message using ( ="Hello " &A10&"! How are you?" ) but I keep getting an error “06/02/2023 21:42:47| Status Code: 400 | Status Text: Failed to decode JSON body.”. I have simply expanded your sheet to reveal column “A” and titled it “Name” and used the Name “Joe” for an example. Please assist if you are able and I am also willing to pay you for your time. Thank you
Hi Sven, thank you for your video. I'ma trying to open your excel but il doesnt work. I have a pop up "Microsoft visual basic (error 485)". I have a macbook ? Do you know what is causing the issue ? Thank you
You don't need to have the recipient's numbers in your phone's address book. It's just like sending an SMS from your phone, but instead of typing it on your phone, you're using Excel to compose and send the message.
@@CodingIsFun Sry! I will try to reformulate the question because it seems that we do not understand each other. I don't have customer contacts saved in my phone and I don't pretend to have them. I'm just curious, where in Excel do I define the name of the person I'm sending an SMS to? So, if I want to write a custom sms "Hello Peter", I have to define somewhere in excel which is related to the number of the recipient of the message.
@@Nemanja_Zivanovic There is a "Placeholder" sheet. Please have a look at the following video: docs.pythonandvba.com/sms-blaster/guides/how-to-use-placeholders
@coding is fun - for an IOS iPhone alternative, would this code work with KDE Connect? It seems like it functions just like pushbullet. Or perhaps intel unison?
can u add the time delay function after sending one message.while sending multiple message at once the network doesn't function properly thanks for the wonderful video .
Thank you very much for watching the video & your feedback. I added a 2 seconds delay after sending each message. Please find the updated version here: e.pc.cd/hXsotalK Hope it solves the issue!
@@CodingIsFun tHIS LINK IS NOT WORKING, AND NETWORK DONT SUPPORT SENDING MESSAGES SO QUICKLY, PLEASE EXPLAIN HOW TO ADD DELAY OF 3 SECONS AFTER AFTER EACH SMS
hello how to send personalized message? like i wanted to send to multiple receiver the same message but with their indicated personal names. hope you answer
Thanks for watching the video. You could add an additional column to insert the receiver name. Afterwards, you could use the Excel formula concatenate to combine the Text in the 'Text Message' column with the 'Receiver Name' column. Hope this helps!
@@tdmkingrusher4182 What is the error message? I have other videos on my channel, if you want to use an API instead to send out SMS via Excel. Please check them out. Thanks!
Happy to hear that it works. Unfortunately, it really depends on your phone carrier. If they have limitations in place, there's no possibility for me to change that for you ☹️
This is fantastic. I just came across it and I really want to use it. I copied all (macros, forms, etc) into my existing Excel workbook to integrate it and when I run it I get this message: Compile Error: User-Defined Type Not Defined. Any ideas, please?
Thanks for watching. Please use the template I provide on my website. Debugging from a distance can be quite hard for me. If you need a custom solution, please get in contact here: pythonandvba.com/contact Thanks!
@@KenNguyen-ZZ 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. If you want to have a template specific to your requirements, you could hire me as a freelancer. You can get in contact with me here: pythonandvba.com/contact
Hello Great video! Is there a way to put line breaks in the text message? Right now, everything is bulked together and doesn't look great. I tried some things, but I get this error: status.400 failed to decode. Thanks!
cannot run the macro====== The macro may be available in this workbook or all macros may be disbaled... this shows when I send message, How to solve this? Thanks
If you can currently send SMS abroad with your mobile phone, you’ll be able to do the same with this template. It works just like sending SMS from your phone. Best, Sven
I’m trying to get my head round this as would love to send group messages. I’ve spent all morning sending about 30 messages. Can this be done in iPhone?
Hola!!! Por alguna razón esta función no me funciona en Windows 7 últimate 32 bis solo en Windows 10. 32 bist y 63, Por si acaso no tenes alguna idea de como solucionarlo. Algún consejo?
I did this last year and it worked great, tried doing it again and keep getting the error that it cannot send due to Macro, not sure what to do i have tried enabling macro but nothing will work. Please help.
HI - using this technique is it possible to replace the sending ID number with various Alpha Tags (names). if not would you be able to write a custom script? Paid for obviously. .
Hey I used this before and it was great, now I am getting an error 0 message when i try and the messages don't send....i rang the network support a few times and it didn't help...any ideas how to fix this?
I cannot give legal advice. Please check with your mobile phone service provider. As mentioned in the video, Pushbullet has an SMS limit if you use the free service. Thanks!
Hello Sir, I was looking similar kind of tool. I have setup all you told in the video. But messages are not going. Error comes- Status Code: 400 | Status Text: Failed to decode JSON body. I tried message as- hi No line break, no extra characters. I have downloaded the same excel version has mentioned in description. Can you please guide.
I have updated the template. Kindly try to use the latest version available here: www.pythonandvba.com/blog/send-bulk-sms-from-your-own-number-using-excel-free-template/
I might be a little too stupid for this. LOL! 1. If I have 300 recipients, am I typing one message in the spreadsheet and copying it down so that each person shows the identical message or does one message get sent to each recipient on the spreadsheet with no need to copy the message down the page? 2. When I click the send button nothing happens at all. 3. I used the latest version with now luck. I know you didn't create this. Just thought I's ask you since you got it to work. Thanks! LOL!
Hey. This sounds amazing but I can find the app in the App Store and when I try to download the application on my desktop it get “connecting” and nothing more happens. Help please?
Thanks for watching. When downloading the file, ensure it is 'unblocked', see here: hotcakescommerce.zendesk.com/hc/en-us/articles/10932095222157-How-to-Unblock-File-Downloads#:~:text=Right%2Dclick%20on%20the%20file,of%20Windows%20have%20the%20checkbox. I hope it helps! Cheers, Sven
⭐ *Get the Excel template here:* pythonandvba.com/sms-excel-template/
good
before i can use your template for free now it has a payment already 😞
@@PinkParlourAlabang the free version has not changed at all. I just included new features
very nice
I don't see the free template. I just see you selling it for $69.00
🚨 *Please note: This solution only works on Windows + Android!* 🚨
I will be here in the comments section. Please provide your exact error message for any issues, and I will try to help.
I want to send bulk sms but inside the sms is a reply to opt out "Stop". I want to receive that that and make it part of report.
please fix your card payment , it says "An unhandled server error occurred".
Hello could i pay
You to help?
@@GooP777 It depends on the scope of the project. Feel free to shoot me an email at: contact@pythonandvba.com
@Sir Chest TV Just add more rows to the bottom of the sheet (copy the current rows and append them to the end of the table).
Wow. Love this. I couldn't find another solution that allows me to send out multiple texts to my clients from my own phone number...until I saw this.
Happy to hear that you like the solution. Thanks for watching the video and taking the time to leave a comment!
@@CodingIsFun is there a way to attach pictures into the messages?
@@CodingIsFunI don’t see pushbullet in the App Store, iPhone
@@CodingIsFun I'm interested
@@dennishavlik8403 Currently MMS are not supported with this template
Just used it. Amazing. For Android, if you're sending more than 30 SMSes in 30 minutes, you will have to figure out how to change the SMS limit.
Thanks for watching. Glad you like the solution. Happy Sending!
I don't know how to thank you for this. It has made my work so much easier. I have been struggling for years to find a way to send bulk sms using my own number as i can't afford other options available. Thank you so much. I am very excited
Glad I could help! Thanks for watching and for the kind words.
Hey Kindly Can You Elaborate how to sens all the masseages at once , i have Completed all the steps and Messages are Sending also But at Once only . I have to manually Type The Sms In each and every Row of all the numerbs Or It will Automatically Send to all the pasted numbers . Plz help me out
brother i don't know how to thank you, you are really the best i was looking for a free solution for 3 months now, i was sending sms manually but now it's waaaaay easier, keep up the great content, you earned a subscriber !
Glad you like the solution and welcome aboard!
Is it working now??
Hey Kindly Can You Elaborate how to sens all the masseages at once , i have Completed all the steps and Messages are Sending also But at Once only . I have to manually Type The Sms In each and every Row of all the numerbs Or It will Automatically Send to all the pasted numbers . Plz help me out
Works perfectly. I was also able to modify the VBA and integrate this into my existing spreadsheet where i have a userform that writes customised messages. This is brilliant, thank you.
Excellent! Happy to hear that is working and that you modified the code to meet your requirements! 👍🚀
Unfortunately, Pushbullet mobile app cannot be downloaded in my country @@CodingIsFun
pls i need the VBA for the customized SMS extracting data from excel columns like name and location to be included in a customized SMS
Works well, makes sending bulk reminders so much easier.
Happy to heat that you like the solution. Thanks for watching & your comment!
Thanks! I needed this for a school Project!
Good with your project! 🍀🤞 -Sven
Dont stop your great work.
I will try my best
You have no idea but you just changed my life. THANK YOU - I will be buying you 1000 Coffee's in the near future!
Happy to hear that. If you'd like to give me a caffeine boost, you can do so here: pythonandvba.com/coffee-donation.
Your support is much appreciated! 🙏
Awesome. Finally Landed up on the right video. Thanks for sharing
Thanks for watching! 👍
Thank you bro! You are the best! Keep up the Good Work!!!
Thank you! 😀
It works like a charm. You are brilliant!
Happy to hear that! :)
hello can we use this to send more than 50k numbers? Thank you for your reply
Hi. Yes, it is possible, but it depends on your phone provider. Have a look at the following article: docs.pythonandvba.com/sms-blaster/faq/how-many-sms-messages-can-i-send-is-there-a-limit
- Sven
In the video are you sending the same message to every person?
What if you wanted to send a different message to every person.
i.e. to customise each message with their name “Hello Tim” “Hello John”
Thanks for watching. You could add a new "Name" column and then concatenate your text in column C with the new name column. Here is an example: www.screencast.com/t/5m5CvPEN9P
Hope it helps! Happy sending!
Hi, thank you for sharing your video! can it be used with Samsung, Galaxy phones too?
Thanks for watching. Yes, that should work. Cheers, Sven ✌️
Thanks for the great solution. Quick bugger though, it seems longer messages are not supported. Are you aware of any load limitations on the API?
Thanks for watching. I am not aware of any load limitations, but I have also not tested it with longer messages
great tutorial very helpful is there a way to be able to send to multiple people the same text and have them personalized with their first name?
Thank you! Regarding your question: Sending the same message to multiple recipients is possible with the paid template available here: pythonandvba.com/sms-excel-template/. The paid template does support the use of placeholders. However, in the current version, it is not possible to use only one placeholder (e.g., for the first name) that will then be replaced depending on the recipient's number. That said, I am planning to incorporate that feature at some point in time.
Thank you posting this. It works really well.
Thanks for watching. Glad you like the solution :)
Is the receiver able to report the message as spam? If they do for standard messages in Apple devices for example they could lose their iMessage capabilities right??
The messages are still sent from your smartphone. The recipient will have the same options as they do when you send an SMS directly from your smartphone when using the SMS Blaster.
Hello! I hope this finds you well and thank you very much for creating this great video. I would like to know before delving into it whether we can send one message to many contacts. Please let me know, thank you.
You can send one message per row. To send the same message to multiple numbers, copy the same message in every row (you can also use Excel formulas to refer to the first cell, for example). I hope it helps! Happy Sending!
Hi. Thank you for this video. Is it possible to cancel the subscription from the recipients side if they don't want to receive sms anymore.
Thanks for watching. With this template you can only send SMS. Cheers, Sven ✌️
Did I understand correctly? When I send an sms the way you showed in the video, the sms will be sent from my native sms app and the replies to the messages will arrive on my phone and not in the Pushbullet app?
That is absolutely correct. In the following video, I also briefly explain how it works:
docs.pythonandvba.com/sms-blaster/guides/how-does-sms-blaster-send-sms-from-my-phone-and-whats-the-cost
Great information. Thank you. Is there a way, using the Excel spreadsheet, to send to contacts with my business that are not contacts on my phone?
Thanks! This solution will send SMS to any numbers (also to those not in your contact list). Happy Sending!
@@CodingIsFun thank you! Is there a way to select certain numbers to sms? If you do not want to send to all contacts. NOTE: I have downloaded your Excel template.
Thank you! This worked well and saved me hours of work. You have another subscriber!
Awesome! Welcome aboard! :)
@@CodingIsFun can you help me to set this...with team viewer..please.
@@fabricadeursuleti What exactly is the issue?
Hi! This tutorial is fantastic! Wonder are we able to track whether the receiver has read / opened the sms? Or is that anyway we can do it?
Thanks for watching the video and your question. Unfortunately, that is not possible, and I am also not aware of any workaround 😕
Hi thank you so much for this. How do i change to sending the exact same text to all once instead of copying and pasting. Thank you again
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!
Thanks for the template. the worksheet can only take limited amount of numbers and receiver. What should I do if i want to send say. 600 numbers?
Just add more rows :)
Thank you for this video!
My pleasure! Appreciate you taking the time to watch and leave a comment.
You are always the best ❤❤.
Will explain this method using Microsoft Access
It's very kind of you to say so, thank you!
Thanks for the tutorial!
I'm curious, is there a way to code this to send it from excel to apps like Signal or Whatsapp?
Thanks for watching. Yes, I also have a solution for WhatsApp: ua-cam.com/video/Wn9L1MD_y0Y/v-deo.htmlsi=mZm6j2uDGw6GQJW3
Happy Sending! Cheers, Sven ✌️
@@CodingIsFun Thanks, Sven! I'll check the WhatsApp video later and see if I can figure out how to do the same with Signal!
I have dual sim by default it sends messages through 2nd sim but I want to send message through my first sim what to do
I would try to change the default SIM card for sending SMS in your phone settings.
@@CodingIsFunthank you it worked ❤
A good video. thank you so much for these tips.
And is it possible to download these codes? The link you put above does not load
Thanks for watching. The links works fine for me
Another excellent tutorial. Very helpful thanks Sir for sharing this. Really appreciate your efforts.
*Thank you.* I am glad you enjoyed the video 😃
Thank you for creating this!
Quick question- is it possible to personalize these messages for the purpose of mail merge?
Yes, feel free to use Excel formulas to make the input text more dynamic.
@@CodingIsFun Immediatly i enter a "=" sign i get an error
@@davidchege1163 It is a standard Excel sheet. Perhaps you might need to change the cell formatting.
@@davidchege1163 Were you able to get this to work In a mail merge scenario?
this is so awesome!!! thank you so much!! Coffee is on us! Is there a way to create a 1-5 seconds delay between a batch of 10 messages?? my operator keeps blocking me if I send more than 10-15 messages at once. Highly appreciate your work sir!! you are the Robin hood of coding!
Thanks for watching and the kind words. Coffee donations are always welcome :) pythonandvba.com/coffee-donation. Regarding your question, you can adjust the delay time between the messages in the VBA code. There is already a default delay applied. Feel free to change the value.
thank you...found it - did you happen to have a 485 error while trying to run this in a MAC? it gives all kinds of errors on it >(@@CodingIsFun
Amazing technique! Is there a way to assign the returning text messages to the outgoing ones? I don't seem to understand the API
Thank you. That is not possible with the template. And I am not sure, if that is even possible with the API.
Hello thank you so much!!! is it possible to add a timer for each sms to send? If so how?
Thanks for watching. Feel free to adjust the following value: www.screencast.com/t/rlJpPFOWl
Happy sending!
@@CodingIsFun Great! thank you so much, will try this one!
Hello Sir, great video ! Thanks a lot !
I implemented this for a customer, but I encountered a problem… since July every messages aren’t sent. But return a 200: ok code.
I try another account, and another smartphone.
Nothing to do.. have you got a similar problem, or heard something like this.
Before July everything worked fine.
Please let me know, it could be really helpful.
Thanks in advance. ^^
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@@CodingIsFun thanks for your prompt reply
I’ll try to find a solution ASAP if it will work I’ll share here in case someone else encounter the same thing.
Sincerely :)
Thanks.
Wonder what Sender's number or Sender's Name would the receiver see on their device for this bulk SMS sent? I have unlimited SMS text for my mobile plan.
The receiver will see your phone number
Nice solution! Can I send personalized messages using the template?
Thanks! You would need to adjust the template/VBA code
Thanks so much!!
Can you please help me set this up with Vonage? That's the service we use for business and I have no idea about coding.
Thanks again
Thank you for watching the video. I went ahead and checked the Vonage Website. I could also create a custom solution for you. Feel free to shoot me an email: contact@pythonandvba.com
Thanks!
Hi will this template work with Google Messages w/RCS?
I am afraid that RCS Chats are not fully supported.
How to know if the messages are sent? It doesn't show the app or the phone.
This kind of videos made my work much easier. ❤
Thanks for watching. That is not possible in the current template.
Thank you for this amazing lesson.
Thanks for watching the video & your comment! :)
Hi Sir. Applicationm works perfectly. Any ways to add delay between the SMS' like 10s between each, or variable delay (between 5s to 15s) to avoid being blocked by phone carrier. Thank you for your support
Happy to hear that! You can either manually adjust the delay time in the VBA code, which is currently set to 2 seconds, or you could upgrade to the PRO version. In the PRO version, you can set the delay time directly within the Excel sheet, along with some other nifty features: pythonandvba.com/sms-excel-template/
Happy sending! Cheers,
Sven ✌️
Hi, could you please tell me How many devices can be added in pushbullet?
And is there any limit to sms per day from different devices.
Thanks
Thanks for watching. I am not sure about that. You might want to reach out to the Pushbullet support team
Fantastic!, that was exactly what I needed.
Thank you very much😁
You're very welcome! Thanks for watching the video & your comment! :)
Bro your code are amazing, but if i want to add dynamic messages in message column are formula are not set. Can you help out me .???
Or
Can we link Google form with your already excel sheet ?? If yes ! Then how can I do that ?
Thanks for watching the video.
Just delete the cell formatting in the "Text Message" column and use an Excel formula, e.g. concatenate.
No, you can not *easily* combine it with Google Sheets.
@@CodingIsFun thanks buddy.
Fantastic!, that was exactly what I needed. Thank you for this! but unfortunately I'm getting an error. Error Location is: Line no: 220 SendSMS.SendSMS. Please help
Thanks for watching. Hard to tell from a distance why you are facing an error. Sorry that I cannot help
Thanks for the tutorial. Have you ever tested how many SMS you can send per hour with the pro plan. Do you ever get any bans, restrictions etc with your phone plan provider?
Thanks for watching. No, I have not tested out the rate limits of Pushbullet or my phone provider.
@@CodingIsFun Thanks for the quick reply. Will have to test myself 😆
What did u find out?
Hello , very interested in trying this out , was there any info on how many messages can be send out at a time ? Any banning ?
Thanks for watching! As I said in the video, messages come from your own phone, so they count towards your phone plan with your carrier. If you've got unlimited texts, you're all set. If not, keep in mind that sending texts through the PushBullet API is the same as texting by hand, cost-wise. Plus, you'll need Pushbullet Pro to send more than 100 messages a month. It's a good idea to check with your carrier about any message limits you might have.
One more questions, how do I set the time in between text messages sent. For example if I send out 50, how do I make it so in between each text is say 30 seconds.
Press ALT + F11, and change the value here: www.screencast.com/t/t7Ufof1Tz
@@CodingIsFun Thanks dude!
@@CodingIsFun One more questions, what rate should I set each text message to? 15 seconds, 30 seconds?
@@bugattiss4314 Whatever you like
I am sending sms from an excel sheet I’m running macros on to send individualized messages with their unique name and business name and a sentence or two from a list of potential customers I have met with’s business cards I’ve collected and exported from Covve scan. My problem is that my phone continues giving me a warning about push bullet and that it is sending too many sma and would I like to allow it to continue. I am getting this every small hand full of I amend messaging 250 at once. Am I able to set up a delay between sending sms automatically?
Thanks for watching. In the settings menu of the template, you can set a default and random delay between messages. Here is a tutorial on that: ua-cam.com/video/roLmCCHok2g/v-deo.htmlsi=zHQ1dAITq13F7x7U.
I hope it helps!
-Sven
Great video! Can I send photos too? or text only? hope to hear your response. and thanks again
[EDIT] Thanks for watching the video and for your question. No, unfortunately with the current template you cannot send MMS
@@CodingIsFun thank you so much!!!
@@markshi1226 Oh sorry, I posted the wrong link. No, unfortunately with the current template you cannot send MMS
Firstly Thanks for this great Tool! I would ask about my phone number I don't wanna people to see the phone number but see the name of my business you know that didn't make them comfortable. can I do that?
Thanks for watching. Sorry, I am not sure how to do that.
@@CodingIsFun Oh, That’s ok Thanks a lot 😍
Hey ! Thanks for this! I tried this out on my mac, but there is a problem as it says ActiveX component cant create object. Do you know why?
Probably the specific version 6.0 of msxml2.serverxmlhttp is not (properly) installed on the computer your script runs on. I have adjusted the code to create a version-independent object:
Please try it again with the updated workbook:
bit.ly/3cERjY7
I hope it helps! :)
amazing work! how can I delay sending messages for ~30 seconds per SMS?
Thanks!
Change the value here: www.screencast.com/t/qBWJr90r6Lv
Regarding waiting 30 seconds, is this because your phone signal wasn’t strong enough to send them every 2 seconds?
I’ve tried using this system with the 2 seconds setting today and lots of the messages were stuck ‘failed to send.’
I had to go through and click ‘resend’ one-by-one in the phones message screen.
Does Pushbullet have a limit when sending sms?
Thanks for watching. Very good question. Please find my answer here: docs.pythonandvba.com/sms-blaster/faq/how-many-sms-messages-can-i-send-is-there-a-limit
Let me know if have any further questions. -Sven
Very Helpful Application. Strongly Recommended !!!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Hi,
The workbook is not giving me an option to send messages. After having the push bullet on the computer and on my cell phone. I badly need this solution I can pay you if it works for me .
Will be truly grateful
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
Hi! Great video tutorial! Can this be used with Google Sheets? Thanks.
Thanks for watching. No, this solution works only for MS Excel
@@CodingIsFun What about Libreoffice Calc? I assume it does not work on it, either. I have tried, without any success. But maybe I did something wrong with my Libreoffice Calc.
@@gustavobonato I guess it will not work with LibreOffice Calc.
Hello and thank you so much for your work, I have a question though. I Am trying to use your instructions personalize the text message using ( ="Hello " &A10&"! How are you?" ) but I keep getting an error “06/02/2023 21:42:47| Status Code: 400 | Status Text: Failed to decode JSON body.”.
I have simply expanded your sheet to reveal column “A” and titled it “Name” and used the Name “Joe” for an example. Please assist if you are able and I am also willing to pay you for your time.
Thank you
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
@@CodingIsFun Are you able at some point expand on this video to personalize the text messages?
@@loutocco1906 For a custom solution, you can hire me as a freelancer. Feel free to reach out to me at: contact@pythonandvba.com
Thanks!
@@CodingIsFun Ok just sent you an email, thank you
Hi Sven, thank you for your video. I'ma trying to open your excel but il doesnt work. I have a pop up "Microsoft visual basic (error 485)". I have a macbook ? Do you know what is causing the issue ? Thank you
Thanks for watching. The solution only works on Windows.
Thank you ! Do you know if we can set up a rate of sending ? For ex : each 30 seconds ?
@@augustinscalzo3429 Yes, If you open the VBA code, you will that you can adjust the delay time between each message
@@CodingIsFun thanks it works well ! Can I schedule automatic sending at a specific time ?
@@augustinscalzo3429 No, that is not possible with the template
I didn't see either on the website or in the video where the names of the people we send sms are added to?
You don't need to have the recipient's numbers in your phone's address book. It's just like sending an SMS from your phone, but instead of typing it on your phone, you're using Excel to compose and send the message.
@@CodingIsFun Yes, that's what I asked. In which part of Excel are user names entered? Somewhere in the column next to their phone number I guess?
@@Nemanja_Zivanovic No, you cannot enter user names. It needs to be phone numbers.
@@CodingIsFun Sry! I will try to reformulate the question because it seems that we do not understand each other. I don't have customer contacts saved in my phone and I don't pretend to have them. I'm just curious, where in Excel do I define the name of the person I'm sending an SMS to? So, if I want to write a custom sms "Hello Peter", I have to define somewhere in excel which is related to the number of the recipient of the message.
@@Nemanja_Zivanovic There is a "Placeholder" sheet. Please have a look at the following video: docs.pythonandvba.com/sms-blaster/guides/how-to-use-placeholders
Can I use your Excel VBA Template to send bulk MMS instead of SMS ?
Thanks for watching. MMS are currently not supported in the template.
@coding is fun - for an IOS iPhone alternative, would this code work with KDE Connect? It seems like it functions just like pushbullet. Or perhaps intel unison?
Thanks for watching. No, this code will not work with KDE Connect and other solutions. The VBA code solely communicates with the Pushbullet API.
can u add the time delay function after sending one message.while sending multiple message at once the network doesn't function properly
thanks for the wonderful video .
Thank you very much for watching the video & your feedback. I added a 2 seconds delay after sending each message. Please find the updated version here:
e.pc.cd/hXsotalK
Hope it solves the issue!
@@CodingIsFun tHIS LINK IS NOT WORKING, AND NETWORK DONT SUPPORT SENDING MESSAGES SO QUICKLY, PLEASE EXPLAIN HOW TO ADD DELAY OF 3 SECONS AFTER AFTER EACH SMS
@@rahularora8940 The link works fine and a delay of 2 seconds is already implemented: www.screencast.com/t/5HVkHqnK
hello how to send personalized message? like i wanted to send to multiple receiver the same message but with their indicated personal names. hope you answer
Thanks for watching the video. You could add an additional column to insert the receiver name. Afterwards, you could use the Excel formula concatenate to combine the Text in the 'Text Message' column with the 'Receiver Name' column. Hope this helps!
So the messages show up as blue or green ? Majority of US phones are Ifone
The messages are shown as if you were sending them manually from your current mobile phone.
@@CodingIsFun vielen Dank!!
@@CodingIsFun just found out that Push Bullet does not have an app for Apple IOS. This won't work with an IFONE therefore.
Can you schedule when it'll be sent?
Nope, that is not supported
Great tutorial operating 100%, thanks a lot
Thank you for watching the video. Glad to hear that is working :)
Sir the parameter is incorrect please give solution
This need usb hotspot
@@tdmkingrusher4182 What is the error message?
I have other videos on my channel, if you want to use an API instead to send out SMS via Excel. Please check them out. Thanks!
Hi! It works😍, but the telephone company blocks my message if I want to send 50 message at once. What can I do if you help me? 🙏
Happy to hear that it works. Unfortunately, it really depends on your phone carrier. If they have limitations in place, there's no possibility for me to change that for you ☹️
This is fantastic. I just came across it and I really want to use it. I copied all (macros, forms, etc) into my existing Excel workbook to integrate it and when I run it I get this message: Compile Error: User-Defined Type Not Defined. Any ideas, please?
BTW it works fin if I don't copy it into my workbook.
Thanks for watching. Please use the template I provide on my website. Debugging from a distance can be quite hard for me. If you need a custom solution, please get in contact here: pythonandvba.com/contact
Thanks!
Interested in trying this out. Are you able to code {first name} and {last name} to make the message more unique?
Thanks for watching. That is possible, but you would need to adjust the VBA code.
@CodingIsFun don't know how to do that. I really think you can help with this and create another excel sheet for download?
@@KenNguyen-ZZ 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. If you want to have a template specific to your requirements, you could hire me as a freelancer. You can get in contact with me here: pythonandvba.com/contact
Hello Great video! Is there a way to put line breaks in the text message? Right now, everything is bulked together and doesn't look great. I tried some things, but I get this error: status.400 failed to decode. Thanks!
Thanks for watching. This feature is currently not implemented.
cannot run the macro====== The macro may be available in this workbook or all macros may be disbaled... this shows when I send message, How to solve this? Thanks
Here you are: ua-cam.com/video/SFfPrzZAVw4/v-deo.html
hi how can i make the excel like that? do you have a full tutorial on how to set the excel template
Thanks for watching. I do not have a full tutorial on creating such app using VBA.
The mobile app is blocked in my country is there another way>?????
Thanks for watching. Here are some alternatives: ua-cam.com/play/PL7QI8ORyVSCbL1ylVlhaFgum690xtwYz8.html
With this, Can I send out sms with my local number to abroad ?
If you can currently send SMS abroad with your mobile phone, you’ll be able to do the same with this template. It works just like sending SMS from your phone. Best, Sven
Thanks sir you are really doing good❤❤
Glad you liked it. Thanks for watching and taking the time to leave a comment!
thanks , very nice video..
Thanks! Glad you liked it
I’m trying to get my head round this as would love to send group messages. I’ve spent all morning sending about 30 messages. Can this be done in iPhone?
Nope, Pushbullet stopped the support for iOS
@@CodingIsFun is there anything I can do to send sms via my iPhone? I want to send out about 10 thousand messages? :)
I was hoping to do this with an iPhone also. Can I use a cheap android phone and switch my SIM card out when I want to send a message?
@@facelookhairandbeauty
@Codingisfun
@@richardhaus5967 That should work, as long as you can install the latest version of the Pushbullet app on that android phone
Could you do a tutorial on how to accomplish this with google sheets?
Thanks for watching. Most likely I will not create a similar tutorial/template for Google sheets
Hola!!! Por alguna razón esta función no me funciona en Windows 7 últimate 32 bis solo en Windows 10. 32 bist y 63, Por si acaso no tenes alguna idea de como solucionarlo. Algún consejo?
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
I did this last year and it worked great, tried doing it again and keep getting the error that it cannot send due to Macro, not sure what to do i have tried enabling macro but nothing will work. Please 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.
This is a great solution for SEND SMS, In my mobile I can see the SMS, I want to make sure the SMS send is by JASON , or by mobile sms service
0:22 min
Is there a way to get an access token without installing the app on the phone? iPhone app store does not have the app due to the country restriction
Thanks for watching. Pushbullet stopped the support for iOS :/
HI - using this technique is it possible to replace the sending ID number with various Alpha Tags (names). if not would you be able to write a custom script? Paid for obviously. .
Thanks for watching. As far as I know, this is not possible when using Pushbullet.
i need this to did you found someting?
Hey I used this before and it was great, now I am getting an error 0 message when i try and the messages don't send....i rang the network support a few times and it didn't help...any ideas how to fix this?
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
When you paste more than 100 numbers does it matter if the cells are white or do we have to copy and paste formatting to add more tan cells below?
Just paste them below the last entry - it should still work :)
By doing so, will i be able to send 1,000 messages?
Is it legal?
Should I do DLT registration for this?
I cannot give legal advice. Please check with your mobile phone service provider. As mentioned in the video, Pushbullet has an SMS limit if you use the free service. Thanks!
I was so excited, but it says the app (iPhone) is not available in my country/region. I am in the USA. Is that correct?
Thanks for watching. Pushbullet has stopped the support for iOS :(
Is there another solution for iOS that you are aware of? Anybody?
Hello Sir,
I was looking similar kind of tool. I have setup all you told in the video. But messages are not going. Error comes- Status Code: 400 | Status Text: Failed to decode JSON body.
I tried message as- hi
No line break, no extra characters. I have downloaded the same excel version has mentioned in description.
Can you please guide.
I have updated the template. Kindly try to use the latest version available here: www.pythonandvba.com/blog/send-bulk-sms-from-your-own-number-using-excel-free-template/
@@CodingIsFun Yes, working now. Thanks a lot! what a quickest response. You are Awesome !!
had a similar problem... bt the new template works fine,,, thx so much...
I might be a little too stupid for this. LOL! 1. If I have 300 recipients, am I typing one message in the spreadsheet and copying it down so that each person shows the identical message or does one message get sent to each recipient on the spreadsheet with no need to copy the message down the page? 2. When I click the send button nothing happens at all. 3. I used the latest version with now luck. I know you didn't create this. Just thought I's ask you since you got it to work. Thanks! LOL!
the new template works fine
Glad to hear that!
Hey. This sounds amazing but I can find the app in the App Store and when I try to download the application on my desktop it get “connecting” and nothing more happens. Help please?
Thanks for watching m Pushbullet stopped the support for iOS
@@CodingIsFun oh no! Is there anything similar for iOS? How do I get around this?
I don't understand where to use the VBA, because I haven't used coding at all in my life. Can you help me out, please?
You do need to write any line of VBA. You can simply just use the template (download link in the description)
Hey there. When I click "send SMS" , it says "cannot run Macro, the macro may not be available in this workbook". Any advice?? Thanks!
Thanks for watching. When downloading the file, ensure it is 'unblocked', see here: hotcakescommerce.zendesk.com/hc/en-us/articles/10932095222157-How-to-Unblock-File-Downloads#:~:text=Right%2Dclick%20on%20the%20file,of%20Windows%20have%20the%20checkbox.
I hope it helps! Cheers, Sven
Is their an easy way to expand the excel file to more than however many spaces it is?
Not sure what you mean, but it is a normal Excel file. So, you can copy/paste Excel cells below the formatted area.
@@CodingIsFun Got it thx