how to set up a 6 day school cycle in outlook

[pocono24]

My son just started school today and there school runs on a 6 day cycle. For
example day 1 is gym, day 2 is art and so on. Is there a way to set this up
as a reminder in outlook calender for the 6 days without doing each one
seperate for the 180 school days
thanks
sam

 

[Diane Poremsky]

no, not really.... every 6 days won't work unless he goes to school on
weekends... the easiest way to do it is to create the items in Excel and
import into the calendar.
general concept is here: http://www.outlook-tips.net/howto/countdown.htm.

 

[Philip Stromme]

I was looking for this same information.
I tried using the technique in the webpage you gave, but it didn't work
right. It would only import one item from the excel spreadsheet, instead of
all of the items.

I see a certain a student once every 4 school days. Here is what I did:
1) I made a spreadsheet listing each date that I will see that student:
Subject StartDate StartTime EndDate EndTime
Susie 9/4/2007 10:25:00 AM 9/4/2007 11:15:00 AM
Susie 9/10/2007 10:25:00 AM 9/10/2007 11:15:00 AM
Susie 9/14/2007 10:25:00 AM 9/14/2007 11:15:00 AM
Susie 9/20/2007 10:25:00 AM 9/20/2007 11:15:00 AM
Susie 9/26/2007 10:25:00 AM 9/26/2007 11:15:00 AM
2) I imported the spreadsheet into Outlook.
3) When I verified that the data was imported correctly, only one instance
was imported.

Can you help me figure out what's going wrong?

Thanks,
~ Phil

 

[DaveinPA]

I'm starting Outlook '07 calendaring this month and my kids have a similar 6
day school cycle (I'm near Allentown). After not getting an "easy" answer
either, I created an all day event for each of the six days with the
reminders for the one's I needed (book returns, gym clothes days). Then in
calendar view, I "copied" those appointments to fill in the rest of the month
(select the appt, hold the shift key and drag to other days).

I plan to do this monthly, as I did with a paper calendar, b/c if there's a
snow day everything shifts forward anyway.

I think some additional options in recurrence would help us out but that's
what I'm using for now. Good luck and let me know if you find or come up with
anything better.

 

[Philip Stromme]

It has been awhile since I figured this out, so my details might not be
exact...

I discovered the same problem that you are having. On a whim, I decided to
save the file as a comma separated values (*.csv) file, rather than an *.xls
file. When I did that, it imported everything correctly. You start the same
way - Import from another file, then select Comma Separated Values. If I
remember correctly, there are two options for importing csv files - DOS and
Windows. I used the DOS selection, and it worked fine. I don't know if using
the Windows selection would make a difference or not.

Good luck,
~ Phil

 

[Diane Poremsky]

1. You probably didn't create a named range for the entire range you are
importing.
2. Windows CSV will also work. The main reason for using Excel is because
it's easier to see the fields and you can use Excel tools to automate
creating the items.... but its just as easy to save a CSV from Excel.