Automated SMS messages from RMS

Jul 03, 2008 4 Replies

Have a strange enough request from a customer. They are an apparel store and take orders for alterations etc. They would like RMS to automatically send an SMS message to the customers cell phone when the alteration is done. Does anyone know of an add-on that can do this?


Add this stored procedure to their database, making mods as necessary. It uses the built-in CDOSYS to send mail.

formatting link
Then add an UPDATE trigger to the proper table (order?) to fire the SP upon record update and send out the message.

It's actually pretty easy.

Thanks Root

That would work f> Add this stored procedure to their database, making mods as necessary. It

Every carrier can receive SMS messages via email. For example, for AT&T, you send an email to: ##########@txt.att.net

Google it for other carriers.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required