Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
How to code Excel to send SMS text message automatically.
I am looking for code to automatically send an sms text message from Excel via Outlook. Thank you very much..
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Microsoft Excel MVP Ron de Bruin has a number of webpages discussing how to send emails from Excel using VBA. I am guessing you want to send a short message, so try this webpage in his site.
You may wonder why I am blathering about emails when you specifically wanted to send an sms text message. The reason is that Outlook can send an sms as an email provided you know the phone number and cell provider. For example, for an AT&T customer, you would send the sms to 1234567890@txt.att.net Wikipedia has an article that lists the gateways for the major cell service providers.
Regarding your request that the text message be sent automatically--Excel vba is driven by events. If you can define some action that ought to trigger the sms message, then one of Excel's many event subs can probably be used to test for that action, and then to send the sms when it occurs.
You may wonder why I am blathering about emails when you specifically wanted to send an sms text message. The reason is that Outlook can send an sms as an email provided you know the phone number and cell provider. For example, for an AT&T customer, you would send the sms to 1234567890@txt.att.net Wikipedia has an article that lists the gateways for the major cell service providers.
Regarding your request that the text message be sent automatically--Excel vba is driven by events. If you can define some action that ought to trigger the sms message, then one of Excel's many event subs can probably be used to test for that action, and then to send the sms when it occurs.
Thank you very much Ron, I think I'm almost there. I can handle the VBA part just fine from your first link but I don't understand from the second link how to convert it to an sms text message. Yes, my messages will be very short and my cell provider is Verizon.
Are you using Office 365 as your email host? You can create a distribution list in O365 for which the destination will be a cell phone (so a SMS will be sent).
Yes, I'm using Office 365. What are the procedures required to create and send the SMS while Excel is running. I always have outlook running as well. Thanks!
In Ron de Bruin's webpage, the addressee of the email will be 1234567890@vtext.com That's the only change you need to make, assuming his cell phone number is (123) 456-7890.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial