Having Excel Send Text Message Alerts

bobjp · 01-21-2010, 07:31 AM

I am becoming involved in managing testing for some laboratories at work. I often have multiple tests running at the same time. Each has its own schedule and different tasks/checks that must be performed throughout the test. For instance I may have a test run for 3 weeks, and during that time I will have to take pictures and or measurements periodically. Keeping track of the schedule while maintaining other responsibilities is difficult, and I often forget things.

So what I would like to do is set up some sort of text message alert system. Would it be possible to have Excel follow my schedule and send me text alerts when a schedule task must be done? I found some information on setting up an email alert system using macros, but I am away from my computer most of the day. Having something sent to my phone would be ideal.

Any ideas?

**Rob99** · 01-21-2010, 07:57 AM

Why does it have to be excel? Can't you just use Outlook Calendar to schedule all of your appointments and send the alerts to your phone?

**_Kyle_** · 01-21-2010, 08:06 AM

Use a macro to send to an email address but put it as your phone number. Should be something like xxxxxxxxxxx@yourcarrier.com.

bobjp · 01-21-2010, 08:14 AM

Quote:

Why does it have to be excel? Can't you just use Outlook Calendar to schedule all of your appointments and send the alerts to your phone?

It doesn't have to be Excel. But the current schedule is in Excel and is used by multiple people. I would like the schedule to exist on the network so that other people can access it to read it and change it. Outlook would only work for one user at one computer, correct? Or is there a way to make it work?

I am interested in hearing about some other programs that could do what I am asking, but it can't cost any money. We won't be buying anything.

Quote:

Use a macro to send to an email address but put it as your phone number. Should be something like xxxxxxxxxxx@yourcarrier.com.

How would the text be routed? I have Verizon and you can send text messages from the website when logged in. Are you suggesting going through this?

This is all unfamilar territory for me. Any suggestions on how to implement this are welcome.

**_Kyle_** · 01-21-2010, 08:16 AM

Quote:

Originally Posted by bobjp

It doesn't have to be Excel. But the current schedule is in Excel and is used by multiple people. I would like the schedule to exist on the network so that other people can access it to read it and change it. Outlook would only work for one user at one computer, correct? Or is there a way to make it work?

I am interested in hearing about some other programs that could do what I am asking, but it can't cost any money. We won't be buying anything.

See above. If a macro can send emails, you can make it send them to a phone as a text.

**Rob99** · 01-21-2010, 10:20 AM

Quote:

Originally Posted by bobjp

It doesn't have to be Excel. But the current schedule is in Excel and is used by multiple people. I would like the schedule to exist on the network so that other people can access it to read it and change it. Outlook would only work for one user at one computer, correct? Or is there a way to make it work?

I'm no expert on Outlook by any means but I know you can give people on a network permissions to access an outlook calendar. They would then be able to access and/or edit it.

**jeepskate** · 01-21-2010, 11:32 AM

Depends upon what you guys have in house. If you're using Outlook with an Exhcange server on the back-end, then you can setup public calendars.

mooseknuckle · 01-21-2010, 12:23 PM

google calendar?

zlatan24 · 02-02-2010, 03:53 AM

Quote:

Originally Posted by bobjp

It doesn't have to be Excel. But the current schedule is in Excel and is used by multiple people. I would like the schedule to exist on the network so that other people can access it to read it and change it. Outlook would only work for one user at one computer, correct? Or is there a way to make it work?

I am interested in hearing about some other programs that could do what I am asking, but it can't cost any money. We won't be buying anything.

How would the text be routed? I have Verizon and you can send text messages from the website when logged in. Are you suggesting going through this?

This is all unfamilar territory for me. Any suggestions on how to implement this are welcome.

Today I was in net and saw there a lot of interesting tool.But one of it helped me quite good-recover information in Excel,it solved my old problems in seconds and without payment.Moreover I knew how tool restore all of your Microsoft Excel documents in several minutes and save many hours or even days of your precious time for .xls recover.

cack- · 02-02-2010, 06:20 AM

yeah i'd just look into using outlook, transfer the shedual on there. you can put specific times of day and it can be shared.. i''m not 100% how to share it. but i know my dad did it. he had the calendar on his comp in his bedroom shared to a computer in the kitchen to make the calendar more accessible...

once you get everything into outlook you can sync your phone to it and your golden