Send BULK SMS From Your OWN Number Using EXCEL [Template]
👉 Download the Excel template here: pythonandvba.com/sms-excel-te...
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This video will show you how to send SMS with your own phone number in Excel using the free Pushbullet API. The messages are sent from your own phone number. Any replies will go right to your phone as expected. Additionally, you can send as many text messages as you want without needing to worry about paying per message as you would for services like Twilio.
Since the messages are coming from your phone, they are covered by your phone plan with your carrier. If you have unlimited SMS, you are set. If you don't, be aware that sending text messages using the Pushbullet API costs the same as sending SMS yourself by hand.
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】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
Пікірлер: 821
⭐ *Get the Excel template here:* pythonandvba.com/sms-excel-template/
@abdallahramadhani1268
6 ай бұрын
good
@PinkParlourAlabang
5 ай бұрын
before i can use your template for free now it has a payment already 😞
@CodingIsFun
5 ай бұрын
@@PinkParlourAlabang the free version has not changed at all. I just included new features
@sjdutta5752
5 ай бұрын
very nice
@brianhoffman836
2 ай бұрын
I don't see the free template. I just see you selling it for $69.00
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.
@CodingIsFun
2 жыл бұрын
Happy to hear that you like the solution. Thanks for watching the video and taking the time to leave a comment!
@dennishavlik8403
Жыл бұрын
@@CodingIsFun is there a way to attach pictures into the messages?
@michaelparsons3007
10 ай бұрын
@@CodingIsFunI don’t see pushbullet in the App Store, iPhone
@AaronLightbourne
Ай бұрын
@@CodingIsFun I'm interested
@CodingIsFun
Ай бұрын
@@dennishavlik8403 Currently MMS are not supported with this template
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
@CodingIsFun
Жыл бұрын
Glad I could help! Thanks for watching and for the kind words.
@Kshitijsoni28
Жыл бұрын
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
Another excellent tutorial. Very helpful thanks Sir for sharing this. Really appreciate your efforts.
@CodingIsFun
3 жыл бұрын
*Thank you.* I am glad you enjoyed the video 😃
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.
@CodingIsFun
8 ай бұрын
Excellent! Happy to hear that is working and that you modified the code to meet your requirements! 👍🚀
@ElvinTechUP-qm5cb
8 ай бұрын
Unfortunately, Pushbullet mobile app cannot be downloaded in my country @@CodingIsFun
@oluseyeolowookere497
7 ай бұрын
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.
@CodingIsFun
2 жыл бұрын
Happy to heat that you like the solution. Thanks for watching & your comment!
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 !
@CodingIsFun
Жыл бұрын
Glad you like the solution and welcome aboard!
@saifislam2283
Жыл бұрын
Is it working now??
@Kshitijsoni28
Жыл бұрын
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
It works like a charm. You are brilliant!
@CodingIsFun
2 жыл бұрын
Happy to hear that! :)
Thank you bro! You are the best! Keep up the Good Work!!!
@CodingIsFun
2 жыл бұрын
Thank you! 😀
Fantastic!, that was exactly what I needed. Thank you very much😁
@CodingIsFun
2 жыл бұрын
You're very welcome! Thanks for watching the video & your comment! :)
Awesome. Finally Landed up on the right video. Thanks for sharing
@CodingIsFun
7 ай бұрын
Thanks for watching! 👍
Thank you posting this. It works really well.
@CodingIsFun
2 жыл бұрын
Thanks for watching. Glad you like the solution :)
Thank you! This worked well and saved me hours of work. You have another subscriber!
@CodingIsFun
Жыл бұрын
Awesome! Welcome aboard! :)
@fabricadeursuleti
Жыл бұрын
@@CodingIsFun can you help me to set this...with team viewer..please.
@CodingIsFun
Жыл бұрын
@@fabricadeursuleti What exactly is the issue?
Thank you for this amazing lesson.
@CodingIsFun
2 жыл бұрын
Thanks for watching the video & your comment! :)
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?
@CodingIsFun
2 жыл бұрын
Thanks for watching the video and your question. Unfortunately, that is not possible, and I am also not aware of any workaround 😕
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.
@CodingIsFun
2 жыл бұрын
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!
Dont stop your great work.
@CodingIsFun
9 ай бұрын
I will try my best
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?
@CodingIsFun
2 жыл бұрын
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! :)
Very Helpful Application. Strongly Recommended !!!
@CodingIsFun
Жыл бұрын
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
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.
@CodingIsFun
Жыл бұрын
Thanks for watching. Glad you like the solution. Happy Sending!
You have no idea but you just changed my life. THANK YOU - I will be buying you 1000 Coffee's in the near future!
@CodingIsFun
9 ай бұрын
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! 🙏
You are always the best ❤❤. Will explain this method using Microsoft Access
@CodingIsFun
10 ай бұрын
It's very kind of you to say so, thank you!
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?
@CodingIsFun
11 ай бұрын
Thanks for watching. I am not aware of any load limitations, but I have also not tested it with longer messages
Great tutorial operating 100%, thanks a lot
@CodingIsFun
2 жыл бұрын
Thank you for watching the video. Glad to hear that is working :)
@tdmkingrusher4182
2 жыл бұрын
Sir the parameter is incorrect please give solution
@tdmkingrusher4182
2 жыл бұрын
This need usb hotspot
@CodingIsFun
2 жыл бұрын
@@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!
Thank you for this video!
@CodingIsFun
8 ай бұрын
My pleasure! Appreciate you taking the time to watch and leave a comment.
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
@CodingIsFun
3 жыл бұрын
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!
Thank you for creating this! Quick question- is it possible to personalize these messages for the purpose of mail merge?
@CodingIsFun
2 жыл бұрын
Yes, feel free to use Excel formulas to make the input text more dynamic.
@davidchege1163
Жыл бұрын
@@CodingIsFun Immediatly i enter a "=" sign i get an error
@CodingIsFun
Жыл бұрын
@@davidchege1163 It is a standard Excel sheet. Perhaps you might need to change the cell formatting.
@loutocco1906
Жыл бұрын
@@davidchege1163 Were you able to get this to work In a mail merge scenario?
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?
@CodingIsFun
2 жыл бұрын
Thanks! This solution will send SMS to any numbers (also to those not in your contact list). Happy Sending!
@triciahelton6085
2 жыл бұрын
@@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.
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?
@CodingIsFun
2 жыл бұрын
Just add more rows :)
Amazing technique! Is there a way to assign the returning text messages to the outgoing ones? I don't seem to understand the API
@CodingIsFun
Жыл бұрын
Thank you. That is not possible with the template. And I am not sure, if that is even possible with the API.
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
@CodingIsFun
2 жыл бұрын
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!
What are the character limitations of the JSON format? Anyway to get past that? Thanks
@CodingIsFun
2 жыл бұрын
Thank you for watching the video. In the official Pushbullet API documentation, there is no character limit mentioned: docs.pushbullet.com/#create-text
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!
@CodingIsFun
2 жыл бұрын
Thanks for watching. This feature is currently not implemented.
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.
@CodingIsFun
6 ай бұрын
Thanks for watching. With this template you can only send SMS. Cheers, Sven ✌️
thanks , very nice video..
@CodingIsFun
Жыл бұрын
Thanks! Glad you liked it
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.
@CodingIsFun
2 жыл бұрын
The receiver will see your phone number
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?
@CodingIsFun
2 жыл бұрын
Just paste them below the last entry - it should still work :)
Thanks sir you are really doing good❤❤
@CodingIsFun
Жыл бұрын
Glad you liked it. Thanks for watching and taking the time to leave a comment!
Can i know how to set time for sending message? like set the time when the message will be automatically send to the user phone
@CodingIsFun
2 жыл бұрын
Thank you for watching the video. It can be done, but it requires additional coding. Have a look at the following examples: www.myonlinetraininghub.com/scheduling-macros-in-excel-with-application-ontime I hope this helps!
Hi, thank you for sharing your video! can it be used with Samsung, Galaxy phones too?
@CodingIsFun
3 ай бұрын
Thanks for watching. Yes, that should work. Cheers, Sven ✌️
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
@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!
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. ❤
@CodingIsFun
Жыл бұрын
Thanks for watching. That is not possible in the current template.
hi how can i make the excel like that? do you have a full tutorial on how to set the excel template
@CodingIsFun
Жыл бұрын
Thanks for watching. I do not have a full tutorial on creating such app using VBA.
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?
@CodingIsFun
6 ай бұрын
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.
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
@CodingIsFun
Жыл бұрын
I would try to change the default SIM card for sending SMS in your phone settings.
@rajabalanj6651
Жыл бұрын
@@CodingIsFunthank you it worked ❤
What sim is good for bulk sms fir the uk because most networks have fair use policy for sms so you can’t send that many sms
@CodingIsFun
2 жыл бұрын
Thank you for watching the video. Great question, but I am not really an expert on which sim card to choose.
the new template works fine
@CodingIsFun
2 жыл бұрын
Glad to hear that!
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?
@CodingIsFun
2 жыл бұрын
Thanks for watching. No, I have not tested out the rate limits of Pushbullet or my phone provider.
@ashwill1916
2 жыл бұрын
@@CodingIsFun Thanks for the quick reply. Will have to test myself 😆
@MyBuddyMobile
2 жыл бұрын
What did u find out?
Hi, could it ever notify us or create a report for sender whether our receivers read the SMS or not?
@CodingIsFun
Жыл бұрын
As far as I can see from the Pushbullet docs, that is not possible
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 .
@CodingIsFun
2 жыл бұрын
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!
@rahularora8940
2 жыл бұрын
@@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
@CodingIsFun
2 жыл бұрын
@@rahularora8940 The link works fine and a delay of 2 seconds is already implemented: www.screencast.com/t/5HVkHqnK
hey for some reason when i got to send the messages. it says macros are blocked is there a tutorial so I am able to send the messages. thanks
@CodingIsFun
Жыл бұрын
Please try the following: learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked I hope it helps!
Hello , very interested in trying this out , was there any info on how many messages can be send out at a time ? Any banning ?
@CodingIsFun
Жыл бұрын
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.
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!
@CodingIsFun
7 ай бұрын
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.
@eugenwlf
7 ай бұрын
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
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 ?
@CodingIsFun
2 жыл бұрын
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.
@AmazedExcel
2 жыл бұрын
@@CodingIsFun thanks buddy.
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. .
@CodingIsFun
2 жыл бұрын
Thanks for watching. As far as I know, this is not possible when using Pushbullet.
@assieblazer7802
Жыл бұрын
i need this to did you found someting?
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?
@gwhittaker
Жыл бұрын
BTW it works fin if I don't copy it into my workbook.
@CodingIsFun
Жыл бұрын
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!
Hey I does not show me the send button plus does it able to send sms to shortcode if phone no ?
@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.
Hello thank you so much!!! is it possible to add a timer for each sms to send? If so how?
@CodingIsFun
Жыл бұрын
Thanks for watching. Feel free to adjust the following value: www.screencast.com/t/rlJpPFOWl Happy sending!
@markneilnotarte3692
Жыл бұрын
@@CodingIsFun Great! thank you so much, will try this one!
Hello. Any idea why i do get errors messages when i send more than 100 sms at once? Somethimes even whit less...
@CodingIsFun
5 ай бұрын
Do you have Pushbullet Pro? If not, that could be the issue as I pointed out in the video 0:30 min
@slavimesov4724
4 ай бұрын
@@CodingIsFun i have pushbullet pro
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
@CodingIsFun
Жыл бұрын
Thanks for watching. The links works fine for me
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
@CodingIsFun
7 ай бұрын
Thanks for watching. I am not sure about that. You might want to reach out to the Pushbullet support team
Every time I click send SMS this error code pops up "Compile error: Can't find project or library" any idea how to fix that? I tried to change the references in the VBA but references in the tool menu is not available. I am on a mac.
@CodingIsFun
2 жыл бұрын
Sorry, this solution only works for Windows
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
@CodingIsFun
Жыл бұрын
Here you are: kzread.info/dash/bejne/hXqastSziqS8p5c.html
Hi, is sending a personal sms (with the reciever name) available?
@CodingIsFun
3 жыл бұрын
Thanks for watching the video. Yes, the SMS will be sent from your own phone number (your name as the receiver).
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”
@CodingIsFun
Жыл бұрын
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!
plz help i used the 2010 version and i cant affrod the new excel i got this error moved Part: /xl/comments1.xml part with XML error. (Comments) Load error. Line 2, column 390.
@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.
Hi thanks a lot.. but when the massage multiple line it doesn’t sent can you tell me why
@CodingIsFun
2 жыл бұрын
What is written in the Status column?
Is push bullet still available in 2023 November. Can’t find it on the App Store
@CodingIsFun
9 ай бұрын
Thanks for watching. Pushbullet stopped the support for iOS. It is only available for Android
amazing work! how can I delay sending messages for ~30 seconds per SMS?
@CodingIsFun
2 жыл бұрын
Thanks! Change the value here: www.screencast.com/t/qBWJr90r6Lv
@Bushchannel
Жыл бұрын
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.
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?
@CodingIsFun
Жыл бұрын
You do need to write any line of VBA. You can simply just use the template (download link in the description)
Wow nice video
@CodingIsFun
Жыл бұрын
Happy to hear that you liked it! Thanks for watching and taking the time to leave a comment! 👍
I mistakenly didn't put the country code for me, +1 in front of my numbers. It shows they were sent successfully. Could it be wrong?
@CodingIsFun
2 жыл бұрын
The easiest way would be to send a test message to your own phone number to see if it works.
Can I use your Excel VBA Template to send bulk MMS instead of SMS ?
@CodingIsFun
6 ай бұрын
Thanks for watching. MMS are currently not supported in the template.
Hey there. When I click "send SMS" , it says "cannot run Macro, the macro may not be available in this workbook". Any advice?? Thanks!
@CodingIsFun
6 ай бұрын
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
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?
@CodingIsFun
3 ай бұрын
Thanks for watching. Yes, I also have a solution for WhatsApp: kzread.info/dash/bejne/iaJtrpOGdMLfYLw.htmlsi=mZm6j2uDGw6GQJW3 Happy Sending! Cheers, Sven ✌️
@Buhtbeard
3 ай бұрын
@@CodingIsFun Thanks, Sven! I'll check the WhatsApp video later and see if I can figure out how to do the same with Signal!
The mobile app is blocked in my country is there another way>?????
@CodingIsFun
Жыл бұрын
Thanks for watching. Here are some alternatives: kzread.info/head/PL7QI8ORyVSCbL1ylVlhaFgum690xtwYz8
good morning ! I tried to send sms with the way that you show here but there is a notification "cannot run the macro" what does this mean and how can I enable that ?
@CodingIsFun
Жыл бұрын
Just enable macros: support.microsoft.com/en-us/office/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6
my pc has disabled the excel file cos of vba code. when to the trust center to fix it but still did not work
@CodingIsFun
5 ай бұрын
Please follow the updated setup steps here: kzread.info/dash/bejne/dYZ3ucR8YKTOks4.html
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
@CodingIsFun
Жыл бұрын
Thanks for watching. Pushbullet stopped the support for iOS :/
The pushbullet app has been redrawn in the appstore for iPhone. gaah.. Is there a workaround?
@CodingIsFun
Жыл бұрын
I am not aware of any alternative
Hi! Great video tutorial! Can this be used with Google Sheets? Thanks.
@CodingIsFun
2 жыл бұрын
Thanks for watching. No, this solution works only for MS Excel
@gustavobonato
2 жыл бұрын
@@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.
@CodingIsFun
2 жыл бұрын
@@gustavobonato I guess it will not work with LibreOffice Calc.
Hey, is there anyway to increase the rate of messages being sent???
@CodingIsFun
2 жыл бұрын
As mentioned in video, it is possible by using the Pushbullet Pro version
What if I stay in Romania and I want to send bulk SMS to United Kingdom. But I want to send them with a UK local mobile phone number. Can I do that?
@CodingIsFun
Жыл бұрын
As explained in the video. The SMS are sent from your phone provider.
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.
@CodingIsFun
11 ай бұрын
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 I think Google messages also opens in system is there any coding done where we can send the messages throught Google message on desktop
@CodingIsFun
3 жыл бұрын
Thank you for your comment. Yes, I also think Google messages has a Desktop app. Yet, I do not have any automation solution for this.
@AvinashKumar-xj8dp
3 жыл бұрын
@@CodingIsFun if you can create this like the same way you have done for what's app it would be great helpfull
@CodingIsFun
3 жыл бұрын
@@AvinashKumar-xj8dp I have learned from my mistakes 😅 The last WA BOT was not in line with the WA Terms of Services. Hence, I will not develop any solutions anymore which can be used for bulk messaging. Unless an official API is available that allows sending multiple messages (like the Pushbullet SMS API as shown in this video).
will this work in america? when i go to download app it say that it is not available in my region
@CodingIsFun
9 ай бұрын
Thanks for watching. It should also would in the US. Yet, Pushbullet stopped the support for iOS
When we tried to send a test SMS to multiple numbers, the PushBullet XLSM seemed to only send to the first number in the list, but it's giving a "Code: 200" for all the numbers in the list. How do we solve this problem? Thanks!
@CodingIsFun
2 жыл бұрын
Hard to tell from a distance. I am not sure why it is not working for all the numbers.
@clivesimpson3986
2 жыл бұрын
We've sent you an email with the tester template attached.
Hi, I've been receiving "Status Code: 400 | Status Text: Failed to decode JSON body" error recently. Do you know what may be causing this? thanks.
@CodingIsFun
11 ай бұрын
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
Trying to use the Excel template on my MacBook showing warning "Microsoft virtual basic" is there anything I'm doing wrong?
@CodingIsFun
Жыл бұрын
Thanks for watching. It only works on Windows
@user-rn5tb8fs4n
Жыл бұрын
@@CodingIsFunthank you for information. Is there a limit to how many recipients can be allowed to excel fine with pushbullet pro?
@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?
@CodingIsFun
Жыл бұрын
Thanks for watching. No, this code will not work with KDE Connect and other solutions. The VBA code solely communicates with the Pushbullet API.
Bravo Sir!!!
@CodingIsFun
Жыл бұрын
Thank you! :)
@stephenmacharia7976
Жыл бұрын
@@CodingIsFun I wonder if there is a way of sending PDF Attachments from Gmail to many recipients
@CodingIsFun
Жыл бұрын
@@stephenmacharia7976 To send an email with an attachment in Python, you can use the smtplib and email libraries which are part of Python's standard library.
@stephenmacharia7976
Жыл бұрын
@@CodingIsFun Thanks alot Sir!
Hello, I'm trying to send customised messages. The worksheet doesn't allow to place a formula inside the text column. How do I solve the issue?
@CodingIsFun
Жыл бұрын
Thanks for watching. Just format the Excel cell. Currently, the cells are formatted as "text"
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.
@CodingIsFun
2 жыл бұрын
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/
@rohitaagarwal4953
2 жыл бұрын
@@CodingIsFun Yes, working now. Thanks a lot! what a quickest response. You are Awesome !!
@rusechorumphi3104
2 жыл бұрын
had a similar problem... bt the new template works fine,,, thx so much...
@WhatToSellOnAmazon
Жыл бұрын
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!
excelent, did work here
@CodingIsFun
2 жыл бұрын
Great! :)
@abdegnojunior6096
2 жыл бұрын
@@CodingIsFun how can i set a delay between sms?
@CodingIsFun
2 жыл бұрын
@@abdegnojunior6096 Have a look at the source code. It is already implemented: www.screencast.com/t/3GkeAOby
I pasted the device id in the Target Device id. There is a squigly red line under the id. Is that why I cannot send SMS texts yet?
@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.
do you have a video to edit for mms messages i'm lost when i read the article lol
@CodingIsFun
8 ай бұрын
Thanks for watching. Nope, I do not have a video/template for sending MMS with Pushbullet.
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.
@CodingIsFun
Жыл бұрын
Press ALT + F11, and change the value here: www.screencast.com/t/t7Ufof1Tz
@bugattiss4314
Жыл бұрын
@@CodingIsFun Thanks dude!
@bugattiss4314
Жыл бұрын
@@CodingIsFun One more questions, what rate should I set each text message to? 15 seconds, 30 seconds?
@CodingIsFun
Жыл бұрын
@@bugattiss4314 Whatever you like
Hi I am using this method however it keeps telling me that the server api is aksing for my username and password. Is there a better way around that ?
@JoannaSmithUnconventional
2 жыл бұрын
What is my user name and password where do I find it ?
@CodingIsFun
2 жыл бұрын
@@JoannaSmithUnconventional If you have entered your Access Token & Target Device Id correctly, you can ignore the popup/close the popup.
Where can we get the excel file you have shown here?
@CodingIsFun
2 жыл бұрын
Thanks for watching the video. You can download the Excel Template here: e.pc.cd/hXsotalK
is it possible to dial gsm phone in android phone on click?
@CodingIsFun
5 ай бұрын
Thanks for watching. I am afraid, that it is not possible. Cheers, Sven ✌️