Send SMS through Access using an SMS gateway API

[tobydobo]

Hello,

I am testing SMS functions in my access database, to notify a technician when a dispatch is requested. I currently have code to send email, but would like to incorporate code to also notify via SMS. I contacted the gateway provider and they have several APIs for developers but I am not sure which one will be best. Could someone look at some of the examples at the website below and tell me how I could incorporate it into a command button?

http://www.redoxygen.com/support/wik...php?id=red_api
One option I thought may work is the VB.NET option but I cant figure out how to implement it -



Code example:

Module Module1

Sub Main()

Dim result As Integer
result = RedOxygen.SendSms("CI00001234",
"username@company.com",
"MyPassword",
"61409000000,614090000001",
"Hello from VB.NET")

End Sub

End Module

[June7]

VBA language and syntax is closer to VB6 than VB.net. I have on several occasions taken VB6 code and plugged into VBA with little modification.

Review http://smsco.it/en/sms_tutorials/sms...sual_basic.jsp

This refers to a dll and tlb file when setting reference http://vb-helper.com/howto_vb6_use_system_dll.html

[pbaldy]

I send SMS out from Access, but we use Twilio. I use what is probably the equivalent of the HTTP method from your link. It does require the XML library be referenced in VBA, but it works nicely. I don't know what the code for your provider would be though. I found mine by Googling "twilio vba" or something like that.

[tobydobo]

June7 I saw this link earlier today but it appears to require a phone or modem connected to the pc. Hoped that maybe there was some vb code that would allow you to send the text through the actual database.

[tobydobo]

Thanks pbaldy. Would you be able to share the code you are using now perhaps? Im sure it is very similar since Twilio uses the same type of technology.

[pbaldy]

This got me going:

https://www.twilio.com/blog/2013/08/...nd-access.html