Procedure to send group SMS

[Sachin2k6]

Hi all,

I'm working on a management program for a small company. As one of it's feature i need a procedure which send a prewritten SMS to it's employees using a web service like fullonsms.com (10 employees at a time.).

Is it possible by VBA code? If yes ,Can any one give me the source code??

Thanks in advance

 

[Sachin2k6]

any one..........

 

[JLGWhiz]

any one..........

I am sure somebody will eventually find a way to do it, but I have not yet seen any postings related to SMS via Excel VBA or even Outlook VBA. But there is plenty of information on sending email via Excel VBA and that can be found through the search procedure. Or if you have a specific question regarding email with VBA, post it and somebody will probably respond to it.

 

[Sachin2k6]

Dear JLGWhiz,
I want procedure for SMS not for e-mail

 

[Sachin2k6]

Can any Excel Genius write this code for me??

 

[JP2112]

Is it possible? Yes. Do you have any code written so far?

It will be difficult to find someone to write your entire code for you. Far better to post what you have tried so far and where you are stuck.

 

[Sachin2k6]

I'm in the process of learning VBA? Do not have so much experties right now to right such kind of code. That's why I'm looking someone's help to give me clue to start with.

 

[JP2112]

I'm guessing by your avatar you are in India. Didn't they just issue a temporary ban on SMS?

 

[Sachin2k6]

I'm guessing by your avatar you are in India. Didn't they just issue a temporary ban on SMS?

Ban is for Bulk SMS. One can send up to 100 SMS per day.

My need is for only 40-50 SMS. And also ban would be withdrawn after the the condition becomes normal.

Apart all it is a topic to gain advanced knowledge of VBA.

Can you give some clue to start with?????

 

[JP2112]

OK. What phone carrier are your employees using? They might have a gateway you can leverage.

Ex: You can send SMS to a T-Mobile user using phonenumber@tmomail.net .