Sending SMS messages using VBA (UK-based)

[Ruddles]

I've searched the forum and I've Googled. No joy.

Is anyone sending SMS messages using VBA? I'm happy to subscribe to a paid service but before I do that I'd like to be fairly sure it can be driven from a VBA app, even if it's form-based and I have to automate an IE session.

(I know some mobile phone networks map an email address on to their numbers but I don't think they all do, and the solution has to be able to cope with any number, including an overseas one.)

 

[mole999]

I don't have details as such

we used to from work push an external website with information from an excel spreadsheet to do automated paging everyday


we also have something tagged into our outlook where sending as an +4478645377@company.co.uk will send the message body as SMS


so it must be possibly to drive outlook from excel to send sms

 

[mole999]

http://www.pageone.co.uk/services/connect/excel-plug-in

http://www.smsco.it/en/sms_tutorials/sms_from_excel.jsp

 

[Ruddles]

Cheers, I'll take a squiz when I get home.

 

[JP2112]

I have some code here, but it's limited to specific countries:

Send SMS messages via XMLHTTP and VBA

Countries:
Austria - Mobilkom
Bulgaria - Mobiltel
Croatia - Cronet
Germany - E-Plus,Mannesman D2
Israel - Pelephone
Lithuania - Omnitel
Maldives - Dhiraagu
Norway - NetCom,TeleNor
Switzerland - Bluewin
USA - Ameritech Cellular services ,Cellular One, Cingular
Brazil - ATL express,Telemig Cellular
Canada - Bell Mobility, Clearnet, Rogers AT&T Wireless ,Telus
France - Itineris
India - Essar Cell Phone,RPG Cellular
Japan - NTT Docomo
Malaysia - Celcom
New Zealand - Messagetrack
Spain - MoviStar
Ukraine - Golden Telecom, UMC
USA - Comcast Cellular Communications,Voicestream Wireless Corp.

You might want to look into some other web APIs that also offer SMS service:

http://www.programmableweb.com/apitag/?q=SMS

 

[Ruddles]

Thanks, I'll definitely check that out.

And of course I'll post the outcome here.

 

[Ruddles]

First of all, thanks for the various suggestions and recommendations.

I found one Web site (http://www.mutube.com/projects/open-email-to-sms/gateway-list/) which claims to list the methods for sending emails to SMS recipients but I couldn't get this to work with O2, Virgin or Vodafone mobiles so I gave that up. TANSTAAFL!

I ended up using http://www.txtlocal.co.uk/ which charges a maximum of 4.9p per text message and provides a Web interface as well as a programming API which works like a dream.