Send Text Message 2

[ineedhelplease]

I am looking for a way to send a text message using VBA out of Access.

I created a program using Access and VBA that runs many times a day. I have used proper error handeling so that errors are logged, but I am not able to monitor the program all day long. When an error is logged, I would like for it to send me a text message showing that there was an error while processing.

Is there code out there that will allow me to generate a text message?

Thanks in advance for any help.

 

[PHV]

Why not using the SendObject method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ineedhelplease]

What I meant to ask; can I send a text message to my cell phone?

This will allow me to monitor for errors while away from the office. If I do not receive any error messages during the day, I know I will not need to return to the office to check for or correct any errors before heading home.

Again thank you for any help on this subject.

 

[AlexCuse]

You need to find out how to send an email to your cell phone (which will receive it as a text message)

Ex:

For my wireless provider it is 1234567890@vtext.com

Just the ten digit number, no 1 before the area code (if US).

You can then use CDO to send an email to this address, just make sure it is nothing too long / fancy so that it all gets there.

Hope this helps,

Alex

[small]----signature below----[/small]
According to recent reports, the US Missile Defense System is actually just Cole Hamels on Speed Dial.

Ignorance of certain subjects is a great part of wisdom