Solved

Automatic Email

Posted on 2013-06-26
2
214 Views
Last Modified: 2013-07-06
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.
0
Comment
Question by:ATL74
2 Comments
 
LVL 42

Accepted Solution

by:
Amit earned 500 total points
ID: 39278262
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
 
LVL 76

Expert Comment

by:David Lee
ID: 39279293
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Read this checklist to learn more about the 15 things you should never include in an email signature.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question