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

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 he http://www.outlook-tips.net/howto/countdown.htm.

--
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:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"pocono24" wrote in message
...
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

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


"Diane Poremsky" wrote:

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 he http://www.outlook-tips.net/howto/countdown.htm.

--
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:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"pocono24" wrote in message
...
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

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.


"pocono24" wrote:

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

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

"Philip Stromme" wrote:

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


"Diane Poremsky" wrote:

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 he http://www.outlook-tips.net/howto/countdown.htm.

--
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:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"pocono24" wrote in message
...
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

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.

--
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:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Philip Stromme" wrote in message
...
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

"Philip Stromme" wrote:

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


"Diane Poremsky" wrote:

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 he
http://www.outlook-tips.net/howto/countdown.htm.

--
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:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"pocono24" wrote in message
...
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