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

  • @CodingIsFun
    @CodingIsFun6 ай бұрын

    ⭐ *Get the Excel template here:* pythonandvba.com/sms-excel-template/

  • @abdallahramadhani1268

    @abdallahramadhani1268

    6 ай бұрын

    good

  • @PinkParlourAlabang

    @PinkParlourAlabang

    5 ай бұрын

    before i can use your template for free now it has a payment already 😞

  • @CodingIsFun

    @CodingIsFun

    5 ай бұрын

    @@PinkParlourAlabang the free version has not changed at all. I just included new features

  • @sjdutta5752

    @sjdutta5752

    5 ай бұрын

    very nice

  • @brianhoffman836

    @brianhoffman836

    2 ай бұрын

    I don't see the free template. I just see you selling it for $69.00

  • @careyleerouse
    @careyleerouse2 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Happy to hear that you like the solution. Thanks for watching the video and taking the time to leave a comment!

  • @dennishavlik8403

    @dennishavlik8403

    Жыл бұрын

    @@CodingIsFun is there a way to attach pictures into the messages?

  • @michaelparsons3007

    @michaelparsons3007

    10 ай бұрын

    @@CodingIsFunI don’t see pushbullet in the App Store, iPhone

  • @AaronLightbourne

    @AaronLightbourne

    Ай бұрын

    ​@@CodingIsFun I'm interested

  • @CodingIsFun

    @CodingIsFun

    Ай бұрын

    @@dennishavlik8403 Currently MMS are not supported with this template

  • @timothychoongo6473
    @timothychoongo6473 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Glad I could help! Thanks for watching and for the kind words.

  • @Kshitijsoni28

    @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

  • @dovacmarlon7493
    @dovacmarlon74933 жыл бұрын

    Another excellent tutorial. Very helpful thanks Sir for sharing this. Really appreciate your efforts.

  • @CodingIsFun

    @CodingIsFun

    3 жыл бұрын

    *Thank you.* I am glad you enjoyed the video 😃

  • @JackWestrop
    @JackWestrop8 ай бұрын

    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

    @CodingIsFun

    8 ай бұрын

    Excellent! Happy to hear that is working and that you modified the code to meet your requirements! 👍🚀

  • @ElvinTechUP-qm5cb

    @ElvinTechUP-qm5cb

    8 ай бұрын

    Unfortunately, Pushbullet mobile app cannot be downloaded in my country @@CodingIsFun

  • @oluseyeolowookere497

    @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

  • @jupupable4101
    @jupupable41012 жыл бұрын

    Works well, makes sending bulk reminders so much easier.

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Happy to heat that you like the solution. Thanks for watching & your comment!

  • @yassineremmal6044
    @yassineremmal6044 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Glad you like the solution and welcome aboard!

  • @saifislam2283

    @saifislam2283

    Жыл бұрын

    Is it working now??

  • @Kshitijsoni28

    @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

  • @gustavobonato
    @gustavobonato2 жыл бұрын

    It works like a charm. You are brilliant!

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Happy to hear that! :)

  • @petervu5022
    @petervu50222 жыл бұрын

    Thank you bro! You are the best! Keep up the Good Work!!!

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thank you! 😀

  • @sawaeryuiti
    @sawaeryuiti2 жыл бұрын

    Fantastic!, that was exactly what I needed. Thank you very much😁

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    You're very welcome! Thanks for watching the video & your comment! :)

  • @user-yu2sn9zi3h
    @user-yu2sn9zi3h7 ай бұрын

    Awesome. Finally Landed up on the right video. Thanks for sharing

  • @CodingIsFun

    @CodingIsFun

    7 ай бұрын

    Thanks for watching! 👍

  • @gjbester4020
    @gjbester40202 жыл бұрын

    Thank you posting this. It works really well.

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching. Glad you like the solution :)

  • @antlion71
    @antlion71 Жыл бұрын

    Thank you! This worked well and saved me hours of work. You have another subscriber!

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Awesome! Welcome aboard! :)

  • @fabricadeursuleti

    @fabricadeursuleti

    Жыл бұрын

    @@CodingIsFun can you help me to set this...with team viewer..please.

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    @@fabricadeursuleti What exactly is the issue?

  • @user-ll1wb7wd8h
    @user-ll1wb7wd8h2 жыл бұрын

    Thank you for this amazing lesson.

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching the video & your comment! :)

  • @siauphenglee1307
    @siauphenglee13072 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching the video and your question. Unfortunately, that is not possible, and I am also not aware of any workaround 😕

  • @theway4020
    @theway40202 жыл бұрын

    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

    @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!

  • @teddyw.charawa8989
    @teddyw.charawa89899 ай бұрын

    Dont stop your great work.

  • @CodingIsFun

    @CodingIsFun

    9 ай бұрын

    I will try my best

  • @beoneprepaidofficial
    @beoneprepaidofficial2 жыл бұрын

    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

    @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! :)

  • @KidsClub360
    @KidsClub360 Жыл бұрын

    Very Helpful Application. Strongly Recommended !!!

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

  • @khairyfarhan
    @khairyfarhan Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. Glad you like the solution. Happy Sending!

  • @Roxsus777
    @Roxsus7779 ай бұрын

    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

    @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! 🙏

  • @user-rc6vl7tf5y
    @user-rc6vl7tf5y10 ай бұрын

    You are always the best ❤❤. Will explain this method using Microsoft Access

  • @CodingIsFun

    @CodingIsFun

    10 ай бұрын

    It's very kind of you to say so, thank you!

  • @preciousmabena701
    @preciousmabena701 Жыл бұрын

    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

    @CodingIsFun

    11 ай бұрын

    Thanks for watching. I am not aware of any load limitations, but I have also not tested it with longer messages

  • @danielcalderon6287
    @danielcalderon62872 жыл бұрын

    Great tutorial operating 100%, thanks a lot

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thank you for watching the video. Glad to hear that is working :)

  • @tdmkingrusher4182

    @tdmkingrusher4182

    2 жыл бұрын

    Sir the parameter is incorrect please give solution

  • @tdmkingrusher4182

    @tdmkingrusher4182

    2 жыл бұрын

    This need usb hotspot

  • @CodingIsFun

    @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!

  • @Viktor-kb4gf
    @Viktor-kb4gf8 ай бұрын

    Thank you for this video!

  • @CodingIsFun

    @CodingIsFun

    8 ай бұрын

    My pleasure! Appreciate you taking the time to watch and leave a comment.

  • @benjohnson2513
    @benjohnson25133 жыл бұрын

    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

    @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!

  • @jasdeepsingh4885
    @jasdeepsingh48852 жыл бұрын

    Thank you for creating this! Quick question- is it possible to personalize these messages for the purpose of mail merge?

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Yes, feel free to use Excel formulas to make the input text more dynamic.

  • @davidchege1163

    @davidchege1163

    Жыл бұрын

    @@CodingIsFun Immediatly i enter a "=" sign i get an error

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    @@davidchege1163 It is a standard Excel sheet. Perhaps you might need to change the cell formatting.

  • @loutocco1906

    @loutocco1906

    Жыл бұрын

    @@davidchege1163 Were you able to get this to work In a mail merge scenario?

  • @triciahelton6085
    @triciahelton60852 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Thanks! This solution will send SMS to any numbers (also to those not in your contact list). Happy Sending!

  • @triciahelton6085

    @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.

  • @jojobatvghnews9466
    @jojobatvghnews94662 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Just add more rows :)

  • @simifernezelyi3350
    @simifernezelyi3350 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Thank you. That is not possible with the template. And I am not sure, if that is even possible with the API.

  • @margiemontoya6640
    @margiemontoya66402 жыл бұрын

    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

    @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!

  • @Pabbs71
    @Pabbs712 жыл бұрын

    What are the character limitations of the JSON format? Anyway to get past that? Thanks

  • @CodingIsFun

    @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

  • @DestHUN
    @DestHUN2 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching. This feature is currently not implemented.

  • @tqax09
    @tqax096 ай бұрын

    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

    @CodingIsFun

    6 ай бұрын

    Thanks for watching. With this template you can only send SMS. Cheers, Sven ✌️

  • @sandeepkarande155
    @sandeepkarande155 Жыл бұрын

    thanks , very nice video..

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Thanks! Glad you liked it

  • @pmsevenlevel2571
    @pmsevenlevel25712 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    The receiver will see your phone number

  • @yessiprz23
    @yessiprz232 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Just paste them below the last entry - it should still work :)

  • @simper6596
    @simper6596 Жыл бұрын

    Thanks sir you are really doing good❤❤

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Glad you liked it. Thanks for watching and taking the time to leave a comment!

  • @eziochannel9373
    @eziochannel93732 жыл бұрын

    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

    @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!

  • @jeongyihong1441
    @jeongyihong14413 ай бұрын

    Hi, thank you for sharing your video! can it be used with Samsung, Galaxy phones too?

  • @CodingIsFun

    @CodingIsFun

    3 ай бұрын

    Thanks for watching. Yes, that should work. Cheers, Sven ✌️

  • @ibnhassan2249
    @ibnhassan2249 Жыл бұрын

    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

    @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!

  • @j.thefreshest
    @j.thefreshest Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. That is not possible in the current template.

  • @rudilee5726
    @rudilee5726 Жыл бұрын

    hi how can i make the excel like that? do you have a full tutorial on how to set the excel template

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. I do not have a full tutorial on creating such app using VBA.

  • @griffeysexotics4528
    @griffeysexotics45286 ай бұрын

    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

    @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.

  • @rajabalanj6651
    @rajabalanj6651 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    I would try to change the default SIM card for sending SMS in your phone settings.

  • @rajabalanj6651

    @rajabalanj6651

    Жыл бұрын

    ​@@CodingIsFunthank you it worked ❤

  • @colesmith6338
    @colesmith63382 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Thank you for watching the video. Great question, but I am not really an expert on which sim card to choose.

  • @rusechorumphi3104
    @rusechorumphi31042 жыл бұрын

    the new template works fine

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Glad to hear that!

  • @ashwill1916
    @ashwill19162 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching. No, I have not tested out the rate limits of Pushbullet or my phone provider.

  • @ashwill1916

    @ashwill1916

    2 жыл бұрын

    @@CodingIsFun Thanks for the quick reply. Will have to test myself 😆

  • @MyBuddyMobile

    @MyBuddyMobile

    2 жыл бұрын

    What did u find out?

  • @LittleLF718
    @LittleLF718 Жыл бұрын

    Hi, could it ever notify us or create a report for sender whether our receivers read the SMS or not?

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    As far as I can see from the Pushbullet docs, that is not possible

  • @kushalkhanal6203
    @kushalkhanal62032 жыл бұрын

    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

    @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

    @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

    @CodingIsFun

    2 жыл бұрын

    @@rahularora8940 The link works fine and a delay of 2 seconds is already implemented: www.screencast.com/t/5HVkHqnK

  • @danbooth3548
    @danbooth3548 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Please try the following: learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked I hope it helps!

  • @geaux2ill
    @geaux2ill Жыл бұрын

    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

    @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.

  • @eugenwlf
    @eugenwlf7 ай бұрын

    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

    @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

    @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

  • @AmazedExcel
    @AmazedExcel2 жыл бұрын

    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

    @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

    @AmazedExcel

    2 жыл бұрын

    @@CodingIsFun thanks buddy.

  • @bobkenton7409
    @bobkenton74092 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching. As far as I know, this is not possible when using Pushbullet.

  • @assieblazer7802

    @assieblazer7802

    Жыл бұрын

    i need this to did you found someting?

  • @gwhittaker
    @gwhittaker Жыл бұрын

    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

    @gwhittaker

    Жыл бұрын

    BTW it works fin if I don't copy it into my workbook.

  • @CodingIsFun

    @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!

  • @talhariaz4577
    @talhariaz4577 Жыл бұрын

    Hey I does not show me the send button plus does it able to send sms to shortcode if phone no ?

  • @CodingIsFun

    @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.

  • @markneilnotarte3692
    @markneilnotarte3692 Жыл бұрын

    Hello thank you so much!!! is it possible to add a timer for each sms to send? If so how?

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. Feel free to adjust the following value: www.screencast.com/t/rlJpPFOWl Happy sending!

  • @markneilnotarte3692

    @markneilnotarte3692

    Жыл бұрын

    @@CodingIsFun Great! thank you so much, will try this one!

  • @slavimesov4724
    @slavimesov47245 ай бұрын

    Hello. Any idea why i do get errors messages when i send more than 100 sms at once? Somethimes even whit less...

  • @CodingIsFun

    @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

    @slavimesov4724

    4 ай бұрын

    @@CodingIsFun i have pushbullet pro

  • @samsonmww
    @samsonmww Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. The links works fine for me

  • @user-yx9kb3ik1l
    @user-yx9kb3ik1l7 ай бұрын

    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

    @CodingIsFun

    7 ай бұрын

    Thanks for watching. I am not sure about that. You might want to reach out to the Pushbullet support team

  • @erikbowman9777
    @erikbowman97772 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Sorry, this solution only works for Windows

  • @LeonardSaldo
    @LeonardSaldo Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Here you are: kzread.info/dash/bejne/hXqastSziqS8p5c.html

  • @BlackK12
    @BlackK123 жыл бұрын

    Hi, is sending a personal sms (with the reciever name) available?

  • @CodingIsFun

    @CodingIsFun

    3 жыл бұрын

    Thanks for watching the video. Yes, the SMS will be sent from your own phone number (your name as the receiver).

  • @Bushchannel
    @Bushchannel Жыл бұрын

    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

    @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!

  • @gos994
    @gos9942 жыл бұрын

    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

    @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.

  • @walidhanora1566
    @walidhanora15662 жыл бұрын

    Hi thanks a lot.. but when the massage multiple line it doesn’t sent can you tell me why

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    What is written in the Status column?

  • @josephekeng2550
    @josephekeng25509 ай бұрын

    Is push bullet still available in 2023 November. Can’t find it on the App Store

  • @CodingIsFun

    @CodingIsFun

    9 ай бұрын

    Thanks for watching. Pushbullet stopped the support for iOS. It is only available for Android

  • @DJRaminem
    @DJRaminem2 жыл бұрын

    amazing work! how can I delay sending messages for ~30 seconds per SMS?

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thanks! Change the value here: www.screencast.com/t/qBWJr90r6Lv

  • @Bushchannel

    @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.

  • @user-xt4wl8xz6u
    @user-xt4wl8xz6u Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    You do need to write any line of VBA. You can simply just use the template (download link in the description)

  • @mehrinakter5793
    @mehrinakter5793 Жыл бұрын

    Wow nice video

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Happy to hear that you liked it! Thanks for watching and taking the time to leave a comment! 👍

  • @makeshamba1626
    @makeshamba16262 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    The easiest way would be to send a test message to your own phone number to see if it works.

  • @blazexpress
    @blazexpress6 ай бұрын

    Can I use your Excel VBA Template to send bulk MMS instead of SMS ?

  • @CodingIsFun

    @CodingIsFun

    6 ай бұрын

    Thanks for watching. MMS are currently not supported in the template.

  • @TheMgranofsky
    @TheMgranofsky6 ай бұрын

    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

    @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

  • @Buhtbeard
    @Buhtbeard3 ай бұрын

    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

    @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

    @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!

  • @ItzMasonC
    @ItzMasonC Жыл бұрын

    The mobile app is blocked in my country is there another way>?????

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. Here are some alternatives: kzread.info/head/PL7QI8ORyVSCbL1ylVlhaFgum690xtwYz8

  • @ioannaantonaki4883
    @ioannaantonaki4883 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Just enable macros: support.microsoft.com/en-us/office/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

  • @bobbyhomawoo
    @bobbyhomawoo5 ай бұрын

    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

    @CodingIsFun

    5 ай бұрын

    Please follow the updated setup steps here: kzread.info/dash/bejne/dYZ3ucR8YKTOks4.html

  • @kkpsk
    @kkpsk Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. Pushbullet stopped the support for iOS :/

  • @ljungel
    @ljungel Жыл бұрын

    The pushbullet app has been redrawn in the appstore for iPhone. gaah.. Is there a workaround?

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    I am not aware of any alternative

  • @jessrielmarcha8278
    @jessrielmarcha82782 жыл бұрын

    Hi! Great video tutorial! Can this be used with Google Sheets? Thanks.

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching. No, this solution works only for MS Excel

  • @gustavobonato

    @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

    @CodingIsFun

    2 жыл бұрын

    @@gustavobonato I guess it will not work with LibreOffice Calc.

  • @truetrue669
    @truetrue6692 жыл бұрын

    Hey, is there anyway to increase the rate of messages being sent???

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    As mentioned in video, it is possible by using the Pushbullet Pro version

  • @martinfischer466
    @martinfischer466 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    As explained in the video. The SMS are sent from your phone provider.

  • @ISAACSON08
    @ISAACSON0811 ай бұрын

    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

    @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.

  • @AvinashKumar-xj8dp
    @AvinashKumar-xj8dp3 жыл бұрын

    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

    @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

    @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

    @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).

  • @marineparkmp
    @marineparkmp9 ай бұрын

    will this work in america? when i go to download app it say that it is not available in my region

  • @CodingIsFun

    @CodingIsFun

    9 ай бұрын

    Thanks for watching. It should also would in the US. Yet, Pushbullet stopped the support for iOS

  • @clivesimpson3986
    @clivesimpson39862 жыл бұрын

    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

    @CodingIsFun

    2 жыл бұрын

    Hard to tell from a distance. I am not sure why it is not working for all the numbers.

  • @clivesimpson3986

    @clivesimpson3986

    2 жыл бұрын

    We've sent you an email with the tester template attached.

  • @jupupable4101
    @jupupable410111 ай бұрын

    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

    @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.

  • @user-rn5tb8fs4n
    @user-rn5tb8fs4n Жыл бұрын

    Trying to use the Excel template on my MacBook showing warning "Microsoft virtual basic" is there anything I'm doing wrong?

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. It only works on Windows

  • @user-rn5tb8fs4n

    @user-rn5tb8fs4n

    Жыл бұрын

    @@CodingIsFunthank you for information. Is there a limit to how many recipients can be allowed to excel fine with pushbullet pro?

  • @253trails
    @253trails Жыл бұрын

    @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

    @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.

  • @stephenmacharia7976
    @stephenmacharia7976 Жыл бұрын

    Bravo Sir!!!

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    Thank you! :)

  • @stephenmacharia7976

    @stephenmacharia7976

    Жыл бұрын

    @@CodingIsFun I wonder if there is a way of sending PDF Attachments from Gmail to many recipients

  • @CodingIsFun

    @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

    @stephenmacharia7976

    Жыл бұрын

    @@CodingIsFun Thanks alot Sir!

  • @walternhabanga
    @walternhabanga Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Thanks for watching. Just format the Excel cell. Currently, the cells are formatted as "text"

  • @rohitaagarwal4953
    @rohitaagarwal49532 жыл бұрын

    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

    @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

    @rohitaagarwal4953

    2 жыл бұрын

    @@CodingIsFun Yes, working now. Thanks a lot! what a quickest response. You are Awesome !!

  • @rusechorumphi3104

    @rusechorumphi3104

    2 жыл бұрын

    had a similar problem... bt the new template works fine,,, thx so much...

  • @WhatToSellOnAmazon

    @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!

  • @abdegnojunior6096
    @abdegnojunior60962 жыл бұрын

    excelent, did work here

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Great! :)

  • @abdegnojunior6096

    @abdegnojunior6096

    2 жыл бұрын

    @@CodingIsFun how can i set a delay between sms?

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    @@abdegnojunior6096 Have a look at the source code. It is already implemented: www.screencast.com/t/3GkeAOby

  • @robertfrechette5875
    @robertfrechette5875 Жыл бұрын

    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

    @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.

  • @brittanyreynosa-earl1973
    @brittanyreynosa-earl19738 ай бұрын

    do you have a video to edit for mms messages i'm lost when i read the article lol

  • @CodingIsFun

    @CodingIsFun

    8 ай бұрын

    Thanks for watching. Nope, I do not have a video/template for sending MMS with Pushbullet.

  • @bugattiss4314
    @bugattiss4314 Жыл бұрын

    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

    @CodingIsFun

    Жыл бұрын

    Press ALT + F11, and change the value here: www.screencast.com/t/t7Ufof1Tz

  • @bugattiss4314

    @bugattiss4314

    Жыл бұрын

    @@CodingIsFun Thanks dude!

  • @bugattiss4314

    @bugattiss4314

    Жыл бұрын

    @@CodingIsFun One more questions, what rate should I set each text message to? 15 seconds, 30 seconds?

  • @CodingIsFun

    @CodingIsFun

    Жыл бұрын

    @@bugattiss4314 Whatever you like

  • @JoannaSmithUnconventional
    @JoannaSmithUnconventional2 жыл бұрын

    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

    @JoannaSmithUnconventional

    2 жыл бұрын

    What is my user name and password where do I find it ?

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    @@JoannaSmithUnconventional If you have entered your Access Token & Target Device Id correctly, you can ignore the popup/close the popup.

  • @DanFinkJr
    @DanFinkJr2 жыл бұрын

    Where can we get the excel file you have shown here?

  • @CodingIsFun

    @CodingIsFun

    2 жыл бұрын

    Thanks for watching the video. You can download the Excel Template here: e.pc.cd/hXsotalK

  • @TechnicalMamunBengali
    @TechnicalMamunBengali5 ай бұрын

    is it possible to dial gsm phone in android phone on click?

  • @CodingIsFun

    @CodingIsFun

    5 ай бұрын

    Thanks for watching. I am afraid, that it is not possible. Cheers, Sven ✌️