SMS text messaging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I've been asked to set up a system for texting patients with a reminder of their appointment. I'd like to do it from the Access database I've created. Can anyone help point me in the right direction (I hold the mobile number in the database)

Cheer

Donna
 
G'day Donna,

have a look at the SendObject method
I don't know whos phone number this is but (here in Australia) to send an
SMS this way the user has to subscribe to the service and is charged for
receiving the email(sms), I have just used strings in the example but you
could use DAO or ADO to pull the details out of the database tables.

stPhoneNo="(e-mail address removed)"
stAppointment="Your Appointment is at 9:30"
DoCmd.SendObject acSendNoObject, outputformat:=acFormatTXT, to:= stPhoneNo,
subject:=stAppointment

Outlook has some real cruddy security blocks now so this may not be a viable
method of sending emails as each send may require a manual acknowledgement.

Doug

Donna Watling said:
Hi

I've been asked to set up a system for texting patients with a reminder of
Click to expand...
their appointment. I'd like to do it from the Access database I've created.
Can anyone help point me in the right direction (I hold the mobile number in
the database).
 
If you download a pgm called ClickYes, you can bypass the
Outlook security. It may leave you somewhat vulnerable to
mass mailing virus.
-----Original Message-----
G'day Donna,

have a look at the SendObject method
I don't know whos phone number this is but (here in Australia) to send an
SMS this way the user has to subscribe to the service and is charged for
receiving the email(sms), I have just used strings in the example but you
could use DAO or ADO to pull the details out of the database tables.

stPhoneNo="(e-mail address removed)"
stAppointment="Your Appointment is at 9:30"
DoCmd.SendObject acSendNoObject,
Click to expand...
outputformat:=acFormatTXT, to:= stPhoneNo,
 
Hi Donna,

As Doug said, some mobile phone users sign up to services that receive
short emails and forward them as text messages, but these don't work for
all mobiles.

To send actual text messages (as opposed to emails) from your system
you'll need to open an account with a service provider, but I don't know
any of the details (or even what country you're in).
 
Thanks for your suggestions. I'm in the UK. I'll try a few service providers here, if any of you have any more suggestions or have tried any SPs here, I'd be interested in hearing about them

Cheer

Donna
 
Hi,
I've been asked to set up a system for texting patients with a reminder of their
appointment. I'd like to do it from the Access database I've created. Can
anyone help point me in the right direction (I hold the mobile number in the
database).
Click to expand...

We use PageGate to send out prescription reminders, and it works like a charm.
There is a download you can try at http://www.notepage.net/pagegate.htm but be
sure to ask for a key so you can really test its full capabilities.

Jill Parker
 
Back
Top