Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Automatic Email

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

837 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