I wrote an article a while back on my personal blog about: “How to send a SMS message or Email automatically when SharePoint list is updated. This is very handy when you need to notify users when a document was added or updated in a document library amongst other things.

Here’s the link to the article explaining the steps involved:

Automatically send SMS messages when a Sharepoint List is updated