Robert Blakeley
New Member
- Outlook version
- Outlook 2010 64 bit
- Email Account
- Office 365 Exchange
Hi Guys,
Ive been tasked with trying to import our daily/monthly rotas from our excel file into calendars. I work for a company where we have many employees tasked to a different section each day with different shift times. Their departments will be shown as subjects.
Name Date Start Time End Time Subject
Thomas 03/01/2014 08:00 15:00 Tennis
Jack 03/01/2014 11:30 14:30 Tennis
Rob 03/01/2014 06:00 11:00 Tennis
Adam 03/01/2014 04:00 09:00 Soccer
Michael 03/01/2014 04:00 09:00 Soccer
Paul 03/01/2014 04:00 09:00 Ice Hockey
Charlie 03/01/2014 15:00 21:00 Golf
I have got a code which sorts all the shifts to what you see above and can import into one persons calendar but was wondering if the following was possible?
1) Can I send each employee a separate update for their calender or can this be done in a shared calendar?
2) Can there be a macro used to automatically update their rotas as many shifts change from the original one set out at the start of the month or week.
Thanks in advance for those taking their time to look and answer this.
Ive been tasked with trying to import our daily/monthly rotas from our excel file into calendars. I work for a company where we have many employees tasked to a different section each day with different shift times. Their departments will be shown as subjects.
Name Date Start Time End Time Subject
Thomas 03/01/2014 08:00 15:00 Tennis
Jack 03/01/2014 11:30 14:30 Tennis
Rob 03/01/2014 06:00 11:00 Tennis
Adam 03/01/2014 04:00 09:00 Soccer
Michael 03/01/2014 04:00 09:00 Soccer
Paul 03/01/2014 04:00 09:00 Ice Hockey
Charlie 03/01/2014 15:00 21:00 Golf
I have got a code which sorts all the shifts to what you see above and can import into one persons calendar but was wondering if the following was possible?
1) Can I send each employee a separate update for their calender or can this be done in a shared calendar?
2) Can there be a macro used to automatically update their rotas as many shifts change from the original one set out at the start of the month or week.
Thanks in advance for those taking their time to look and answer this.