ATL74
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.