How to code Excel to send SMS text message automatically.

Phil
Phil used Ask the Experts™
on
I am looking for code to automatically send an sms text message from Excel via Outlook. Thank you very much..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
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.
PhilPresident

Author

Commented:
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.
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
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).
Success in ‘20 With a Profitable Pricing Strategy

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!

PhilPresident

Author

Commented:
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!
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
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.
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
in fact the distribution list is not required. as byundt said, sending an email to yournumber@vtext.com will work
PhilPresident

Author

Commented:
Unbelievable, this works.  Thank so much!!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial