how to set up a 6 day school cycle in outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pocono24 - 04 Sep 2007 23:42 GMT

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

Reply to this Message

Diane Poremsky - 05 Sep 2007 03:35 GMT

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.

Signature

Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

> My son just started school today and there school runs on a 6 day cycle.
> For
[quoted text clipped - 4 lines]
> thanks
> sam

Reply to this Message

Philip Stromme - 06 Sep 2007 18:06 GMT

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

> 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
[quoted text clipped - 9 lines]
> > thanks
> > sam

Reply to this Message

Philip Stromme - 05 Jan 2008 04:20 GMT

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

> I was looking for this same information.
> I tried using the technique in the webpage you gave, but it didn't work
[quoted text clipped - 31 lines]
> > > thanks
> > > sam

Reply to this Message

Diane Poremsky - 05 Jan 2008 14:09 GMT

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.

Signature

> It has been awhile since I figured this out, so my details might not be
> exact...
[quoted text clipped - 56 lines]
>> > > thanks
>> > > sam

Reply to this Message

DaveinPA - 04 Jan 2008 15:22 GMT

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.

> 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

Reply to this Message