Send Bulk Sms from Desktop App

[Moore71]

Hi,
I hope this is going to be easy.
I want code to be sending bulk SMS to customer numbers after purchase has been made thanking the customer for patronage and send customer invoice by SMS.
I have gotten API from clickatell gateway. So please I need urgent help.

Thank you in advance
Moore

 

[Ranman256]

I would guess it would be the same like email:
collect your text
activate the sms object
and send.

 

[gemma-the-husky]

i do not think you can send sms for free.

you need to send via a third party, who charge small amounts for handling.

I think it's just a matter of sending the mobile number, and message to the third party, but no doubt the third party will have requirements about how your message to them is wrapped.

 

[Moore71]

Ok,
can you give me the parameters to route it through third-party.
I mean Codes to connect to the third-party.

I already have a third-party in companies like www.clickatell.com, but how do i connect my access app to send SMS thru them?

Thanks in advance

 

[Cronk]

I have a couple of Access applications which generate SMS messages to selected recipients. The SMS provider being used, as advised in #3, takes an email with the To field comprising a list of cell phone numbers of the multiple recipients at the provider's email

To: Cellphone1;cellphone2;cellphone3;.......@provider.com

and the the message contained in the body of the email.

After a quick glance, Clickatell does not seem to offer generation via email reciept. You could check with them, get an alternate provider, or look to Access triggering something that does generate what this provider wants.

 

[Uncle Gizmo]

Same as Cronk said... Send an email. I used TextMagic.

 

[the-m0th]

we use a company called kapow, i have buttons on a few of our call answer screens that send texts to our client. this is the code i use if it's of any help.

Private Sub cmd_sendsms_Click()
    If MsgBox("Have you checked all details to make sure they're correct?", vbYesNo) = vbNo Then Exit Sub
    If MsgBox("Have you checked your spelling?", vbYesNo) = vbNo Then Exit Sub
    Dim oIE As Object
    Set oIE = CreateObject("internetexplorer.application")
    oIE.Navigate "http://www.kapow.co.uk/scripts/sendsms.php?username=USERNAMEHERE&password=PASSWORDHERE&mobile=NUMBERHERE&sms=Call from " & Me.txt_callername.Value & " At " & Me.txt_company.Value & " No:-" & Me.txt_callertelephone.Value & " Message:- " & Me.txt_notes.Value
    Set oIE = Nothing
    MsgBox ("SMS Message Sent")
End Sub