Automating from excel into shared Calendars

Status
Not open for further replies.

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.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
This macro will import from a spread sheet into shared calendars - http://www.slipstick.com/developer/create-appointments-spreadsheet-data/ (I'm also working on the steps needed to use powershell to import a csv to office365 calendars but it will probably be 1 csv per calendar.)

I'm not sure exactly what you mean by 'send a separate update' - if you mean an email says 'we just added these dates to your calendar', it should be doable, but the best way depends on how many people there are. Sending an email that says 'we just updated the calendar' without including the dates is definitely doable.

Updating schedule changes might be more difficult - or not. I have macros that can update meetings on a second calendar - that method should work with this. Will the updates be in a separate file or mixed in with the shift csv?
 
Status
Not open for further replies.
Top