Send Message Advertisers Vendors Announcements
Advertise Here
Jeep Forum Classifieds JeepSpace Reviews Gallery Blogs Clubs Groups Videos Wiki Links Events Articles
Jeep Home Jeep Forum Jeep Classifieds Jeep Registry JeepSpace Jeep Reviews Jeep Gallery Jeep Blogs Jeep Clubs Jeep Groups Jeep Videos Jeep Events Jeep Articles

Rough Country TJ Belly Pan Skidplate Giveaway - NEW PRODUCT RELEASE
Best place to buy Rubicon Express! Don't Fear the Jeeper!Insane Rough Country Deals Call for more Info!!! so insanBarnes 4WD Universal 4 Link Kit
Go Back   JeepForum.com > General > General Discussion
Jeep Registry Register Blogs FAQ Mark Forums Read Search Members


Reply
 
LinkBack Thread Tools
Old 01-21-2010, 06:31 AM   #1
bobjp
Registered User
 
Join Date: Aug 2005
Posts: 435
Having Excel Send Text Message Alerts

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?
__________________
97 TJ sport. No swaybar. ;)
bobjp is offline   Reply With Quote
Old 01-21-2010, 06:57 AM   #2
Rob99
You come back...one year!
 
Rob99's Avatar
2003 TJ Wrangler 
 
Join Date: Sep 2003
Location: Ontario, Canada
Posts: 843
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?
Rob99 is offline   Reply With Quote
Old 01-21-2010, 07:06 AM   #3
_Kyle_
Typical broke college kid
 
_Kyle_'s Avatar
1978 CJ7 
 
Join Date: Oct 2005
Location: Montgomery Village, MD/Lambertville, MI
Posts: 2,219
Use a macro to send to an email address but put it as your phone number. Should be something like xxxxxxxxxxx@yourcarrier.com.
__________________
-Kyle

1996 Grand Cherokee

BB Storm 2 FS/FT for a BB Bold

FS/FT: My 96 ZJ for a V8 WJ or similar.
_Kyle_ is offline   Reply With Quote
Old 01-21-2010, 07:14 AM   #4
bobjp
Registered User
 
Join Date: Aug 2005
Posts: 435
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.
__________________
97 TJ sport. No swaybar. ;)
bobjp is offline   Reply With Quote
Old 01-21-2010, 07:16 AM   #5
_Kyle_
Typical broke college kid
 
_Kyle_'s Avatar
1978 CJ7 
 
Join Date: Oct 2005
Location: Montgomery Village, MD/Lambertville, MI
Posts: 2,219
Quote:
Originally Posted by bobjp View Post
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.
__________________
-Kyle

1996 Grand Cherokee

BB Storm 2 FS/FT for a BB Bold

FS/FT: My 96 ZJ for a V8 WJ or similar.
_Kyle_ is offline   Reply With Quote
Old 01-21-2010, 09:20 AM   #6
Rob99
You come back...one year!
 
Rob99's Avatar
2003 TJ Wrangler 
 
Join Date: Sep 2003
Location: Ontario, Canada
Posts: 843
Quote:
Originally Posted by bobjp View Post
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.
Rob99 is offline   Reply With Quote
Old 01-21-2010, 10:32 AM   #7
jeepskate
Moderator
1986 CJ7 
 
Join Date: Aug 2004
Posts: 4,644
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.
__________________
'86 CJ-7 Laredo: 4.2,T-999,D300,D30/D44,'94 YJ tub, full cage, Shrockworks rockers, OYR corners, AC,cruise,restored seats,3 tops,2.5" Superlift,F-T shackle reversal, RS9000x's,35" Dunlop Mud Rovers.
'83 Scrambler: time & money pit under construction with parts from CJ's,YJ's,TJ's,FSJ's,GM,Ford,IH,Honda,Toyota and a whole lotta aftermarket & custom stuff.
http://www.jeepskate.net
jeepskate is offline   Reply With Quote
Old 01-21-2010, 11:23 AM   #8
mooseknuckle
Registered User
2003 TJ Wrangler 
 
Join Date: Jun 2008
Location: E-town, PA
Posts: 62
google calendar?
mooseknuckle is offline   Reply With Quote
Old 02-02-2010, 02:53 AM   #9
zlatan24
Registered User
 
Join Date: Feb 2010
Location: Moscow
Posts: 0
Quote:
Originally Posted by bobjp View Post
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.
zlatan24 is offline   Reply With Quote
Old 02-02-2010, 05:20 AM   #10
cack-
Registered User
1999 TJ Wrangler 
 
Join Date: Oct 2008
Location: Halifax
Posts: 151
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
cack- is online now   Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Jeep Forums Replies Last Post
Don't Text While You Drive, I Repeat Do Not Text While You Drive POLBOSS General Discussion 80 09-02-2009 05:14 PM
send text message from your computer hoosier724 General Discussion 2 08-02-2009 01:01 PM
Need help with MS Excel prjohnson General Discussion 7 01-27-2009 08:45 AM
Excel Help.. GaytorHater703 General Discussion 7 03-05-2007 10:13 AM
Can you send a message to everyone on your buddy list at one time? Bone Down General Discussion 5 06-17-2005 10:29 PM




Jeep, Wrangler, Cherokee, Grand Cherokee, and other models are copyrighted and trademarked to Jeep/Chrysler Corporation.

JeepForum.com is not in any way associated with Jeep or the Chrysler Corp.