Solved

Automatic Email

Posted on 2013-06-26
2
211 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 41

Accepted Solution

by:
Amit earned 500 total points
Comment Utility
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
Comment Utility
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

Why do Marketing keep bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now