Automatic Email

We have 2 members of the IT dept on call each week so we are on every 5th week. We have a schedule in excel and normally email the entire site with a email on mondays that says whois on call and their cell numbers.
 
Things change, people swap, vaction, sickness so I would like to automate the email if possible to send every monday morning at 8:00 AM to the whole site which is already a distribution list and inclued who is on call and their resoective cell. Is there a way to do this in sharepoint long term? Is there a way to do this with excel 2010 and outlook short term?

The tech names and home and cell numbers as well as the schedule is already on a shared drive so i would like the email to pull this data out of excel and send somehow. Is this possible?

Using Outlook 2010 and exchange 2007.
ATL74Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AmitConnect With a Mentor IT ArchitectCommented:
In SharePoint, you can create one page, name it On-call Status and update it regularly, update to users to check SharePoint URL for On-call Support status. Rather sending emails, or you and put a  ticker webpart on you sharepoint home page with oncall support details. Download ticker from here:
http://webpartgallery.codeplex.com/
0
 
David LeeCommented:
Hi, ATL74.

You can do it with a scheduled task and a bit of VBscript.  Of course the computer the scheduled task is on would have to be up and running at 8:00am on Mondays for this to work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.