SMS Via Excel using Microsoft Your Phone app

[amitmanglik]

Hi is there a way vide which i can connect Excel and your phone app and send sms to mobile numbers in excel sheet and a unique message in the next cell.
or is there any other app which can connect my own phone and help me to send various sms.
I have a data in excel for eg.
employee Mobile No. and next to it a specific SMS
now i need a program to send them using my own phone

[stefano78]

Hello. I need the same macro you requested.

[nordicdust]

Randy Austin has made a Application for sending sms
Either download it (It is free)
or watch the video were he creates it.

https://youtu.be/V11uDrUYUPw

[CK76]

now i need a program to send them using my own phone

VBA won't be able to do it using your own phone. As VBA will have no access to it.

Method linked by nordicdust uses twilio.com's API to send SMS (after trial period, it will cost some money). In general, to send mass SMS, you need some service provider. Also, when choosing service provider, you should check what countries the provider supports. Some only support specific geographic region, and often, cost will vary based on destination.

There are ways to send SMS using email service... but that requires you to know the receiver's provider and their SMS gateway. (ex: to send SMS to phone number that's serviced by Verizon you need to send message to... 'phone#@vtext.com' where phone# should follow NPANXXxxxx pattern).

There's no "one size fits all" type of solution here. You'll need to do some research and find service that suites your need.

[stefano78]

i found links for the use of vBA with the GSM phone.
by connecting my old GSM phone Nokia Classic 2700 I noticed that if I click on the reference to objects, the components of Nokia appear

[CK76]

You mean when you click on phone number? That is handled by hyperlink.follow and separate from sms process. Unless there is some custom library that exposes objects to vba, I can't think of ways to manipulate your phone via vba.

[stefano78]

http://www.smsco.it/tomcat/en/sms_tu...from_excel.jsp

https://www.nowsms.com/sending-sms-from-microsoft-excel


http://www.programmisemplici.com/aut...SMS_Co_51.html

[stefano78]

nokia 2007 classic has telephone management software (Cp suite) connected to the cable computer.
i must have installed something so much that I've seen several libreries among other references to objects

[stefano78]

nokia 2007 classic has telephone management software (Cp suite) connected to the cable computer.
i must have installed something so much that I've seen several libreries among other references to objects

the picture is a little blurry, but you can see

[stefano78]

Other links:

https://www.activexperts.com/xmstoolkit/howto/gsm/vba/
http://www.ozekisms.com/index.php?owpn=466

nokia software:

https://gist.github.com/anonymous/27...7541b9ab21beb4

https://filehippo.com/it/download_nokia_pc_suite/

https://pcsuite.net/nokia-2700-pc-suite/


i could already use telephone software, but a Macro could have more potential to schedule the sending and other links to sheet with variable data

[stefano78]

I attach the photo of the references

[CK76]

OK so as I stated, you have external library exposing those components to vba. I really can't help there as I have no experience with that particular library.

[stefano78]

so with the Nokia libraries, it's possible to create a Macro that sends sms?
Is possible to use the link code I attached to the previous messages to send sms from a GSM phone or modem?

[stefano78]

With reference to the possibility of sending sms with the Nokia I found other links:

https://stackoverflow.com/questions/...nokia-pc-suite
https://www.tandasoft.com/software/o...a-pc-sync-fix/
https://it.toolbox.com/question/how-...c-suite-031212
https://www.codeproject.com/Question...Nokia-PC-Suite
https://www.codeproject.com/Question...a-pc-suite-API
https://www.forum.nokia.com/info/sw....y_API_1_1.html
http://www.forum.nokia.com/info/sw.n...y_API_1_1.html

[stefano78]

Hello.
I found this link on the web:
http://www.scampers.org/steve/sms/samples.htm
If visual basic can be inserted in a vba module, could this code be changed to manage the phone by scheduling the sending of sms?