A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Calendar
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Ending Recurring Appointments without Losing Exceptions in 2003



 
 
Thread Tools Display Modes
  #1  
Old October 1st, 2007, 04:46 AM posted to microsoft.public.outlook.calendaring
Jason McClure
external usenet poster
 
Posts: 1
Default Ending Recurring Appointments without Losing Exceptions in 2003

Isn't there some way to end recurring calendar appointments in Outlook 2003
without losing all exceptions?? I see clients on a regular basis and set them
for recurring, and sometimes i need to move them to a different time slot
according to time demands. after i stop seeing the client, i still need to be
able to go back to my calendar and have a record of when i did see them,
including the "exceptions" when i moved them around to a different time.
whenever i go into the recurrences tab to end the recurrences at a certain
date, it makes me lose all exceptions. isn't there some way around this??

Thanks (I hope!)
--

  #2  
Old October 1st, 2007, 01:45 PM posted to microsoft.public.outlook.calendaring
Brian Tillman
external usenet poster
 
Posts: 21,988
Default Ending Recurring Appointments without Losing Exceptions in 2003

Jason McClure wrote:

Isn't there some way to end recurring calendar appointments in
Outlook 2003 without losing all exceptions??


No. Recurring appointments are single calendar entries, with the
recurrences being calculated from the base appointment. When you add an
exception, Outlook keeps a list for the one item of where the calculation is
to be modified. When you perform certain actions in a recurring appointment
(like set an end date), it causes Outlook to regenerate the series, which
resets the exceptions list.

I see clients on a
regular basis and set them for recurring, and sometimes i need to
move them to a different time slot according to time demands. after i
stop seeing the client, i still need to be able to go back to my
calendar and have a record of when i did see them, including the
"exceptions" when i moved them around to a different time. whenever i
go into the recurrences tab to end the recurrences at a certain date,
it makes me lose all exceptions. isn't there some way around this??


Here's how I'd do it. I've tested this, so I know it works. Create a new
calendar folder. Display your original calendar in a table view like Active
Appointments. Find your recurring appointment in the list, click it, and
drag it to the new calendar folder. The entire appointment will move to
that calendar, exceptions and all. Then click FileImport and ExportExport
to a file. Choose some format like "Comma Separated Values (Windows)" -
that's what I used. Select the new calendar folder with its single entry.
Since recurring items can't be exported (there's no way to represent the
recurrence in the exported data), Outlook will prompt you to select the time
frame over which it should export. Select the start date to match the
beginning of the recuurring appointment and an end date matching the date at
which you want it to end. Exporting your calendar from the start of the
original recurring item to its planned end date will give you a file
containing the original appointment and its exceptions as individual
entries.

Delete the original appointment from your main calendar to clear it out, and
import the file you just created, which will import the appointment back and
include all the exceptions. Since you chose an end date on the export, your
original appointment will stop there, but all your exceptions will be
intact. You can then create a new recurring appointment from the new time
onward. You can also delete the extra calendar folder you created, since
you now have the information you wanted in your main calendar again.

You don't really need to create a second calenar folder if you don't want
to, but then you'd have to edit the export file to remove everything but the
one appointment series, and I would find using a temporary second calendar
folder easier because I don't have to sort through all the items I don't
want.
--
Brian Tillman [MVP-Outlook]

  #3  
Old August 4th, 2008, 07:46 PM posted to microsoft.public.outlook.calendaring
Daphne
external usenet poster
 
Posts: 11
Default Ending Recurring Appointments without Losing Exceptions in 200

This is a horiible problem for me as well. Where do we go to submit a
request to Microsoft to get this fixed?

I am unable to keep a history of where I have been. I guess the only way is
to END the recurring appt. Set a single appointment "exception" and then
create a new recurring appointment? That totally sucks.

Microsoft has to have programmers smart enough to fix this...It already is
asking if you want to lose exceptions, so why can't they go the next step and
NOT LOSE exceptions!

"Brian Tillman" wrote:

Jason McClure wrote:

Isn't there some way to end recurring calendar appointments in
Outlook 2003 without losing all exceptions??


No. Recurring appointments are single calendar entries, with the
recurrences being calculated from the base appointment. When you add an
exception, Outlook keeps a list for the one item of where the calculation is
to be modified. When you perform certain actions in a recurring appointment
(like set an end date), it causes Outlook to regenerate the series, which
resets the exceptions list.

I see clients on a
regular basis and set them for recurring, and sometimes i need to
move them to a different time slot according to time demands. after i
stop seeing the client, i still need to be able to go back to my
calendar and have a record of when i did see them, including the
"exceptions" when i moved them around to a different time. whenever i
go into the recurrences tab to end the recurrences at a certain date,
it makes me lose all exceptions. isn't there some way around this??


Here's how I'd do it. I've tested this, so I know it works. Create a new
calendar folder. Display your original calendar in a table view like Active
Appointments. Find your recurring appointment in the list, click it, and
drag it to the new calendar folder. The entire appointment will move to
that calendar, exceptions and all. Then click FileImport and ExportExport
to a file. Choose some format like "Comma Separated Values (Windows)" -
that's what I used. Select the new calendar folder with its single entry.
Since recurring items can't be exported (there's no way to represent the
recurrence in the exported data), Outlook will prompt you to select the time
frame over which it should export. Select the start date to match the
beginning of the recuurring appointment and an end date matching the date at
which you want it to end. Exporting your calendar from the start of the
original recurring item to its planned end date will give you a file
containing the original appointment and its exceptions as individual
entries.

Delete the original appointment from your main calendar to clear it out, and
import the file you just created, which will import the appointment back and
include all the exceptions. Since you chose an end date on the export, your
original appointment will stop there, but all your exceptions will be
intact. You can then create a new recurring appointment from the new time
onward. You can also delete the extra calendar folder you created, since
you now have the information you wanted in your main calendar again.

You don't really need to create a second calenar folder if you don't want
to, but then you'd have to edit the export file to remove everything but the
one appointment series, and I would find using a temporary second calendar
folder easier because I don't have to sort through all the items I don't
want.
--
Brian Tillman [MVP-Outlook]


  #4  
Old August 4th, 2008, 08:23 PM posted to microsoft.public.outlook.calendaring
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Ending Recurring Appointments without Losing Exceptions in 200

if you need a history, recurring events are not the best way to do it - its
too easy to lose all of your history. Create the events in excel and import
so you have individual items that can safely be moved, copied or edited.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


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

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Daphne" wrote in message
...
This is a horiible problem for me as well. Where do we go to submit a
request to Microsoft to get this fixed?

I am unable to keep a history of where I have been. I guess the only way
is
to END the recurring appt. Set a single appointment "exception" and then
create a new recurring appointment? That totally sucks.

Microsoft has to have programmers smart enough to fix this...It already is
asking if you want to lose exceptions, so why can't they go the next step
and
NOT LOSE exceptions!

"Brian Tillman" wrote:

Jason McClure wrote:

Isn't there some way to end recurring calendar appointments in
Outlook 2003 without losing all exceptions??


No. Recurring appointments are single calendar entries, with the
recurrences being calculated from the base appointment. When you add an
exception, Outlook keeps a list for the one item of where the calculation
is
to be modified. When you perform certain actions in a recurring
appointment
(like set an end date), it causes Outlook to regenerate the series, which
resets the exceptions list.

I see clients on a
regular basis and set them for recurring, and sometimes i need to
move them to a different time slot according to time demands. after i
stop seeing the client, i still need to be able to go back to my
calendar and have a record of when i did see them, including the
"exceptions" when i moved them around to a different time. whenever i
go into the recurrences tab to end the recurrences at a certain date,
it makes me lose all exceptions. isn't there some way around this??


Here's how I'd do it. I've tested this, so I know it works. Create a
new
calendar folder. Display your original calendar in a table view like
Active
Appointments. Find your recurring appointment in the list, click it, and
drag it to the new calendar folder. The entire appointment will move to
that calendar, exceptions and all. Then click FileImport and
ExportExport
to a file. Choose some format like "Comma Separated Values (Windows)" -
that's what I used. Select the new calendar folder with its single
entry.
Since recurring items can't be exported (there's no way to represent the
recurrence in the exported data), Outlook will prompt you to select the
time
frame over which it should export. Select the start date to match the
beginning of the recuurring appointment and an end date matching the date
at
which you want it to end. Exporting your calendar from the start of the
original recurring item to its planned end date will give you a file
containing the original appointment and its exceptions as individual
entries.

Delete the original appointment from your main calendar to clear it out,
and
import the file you just created, which will import the appointment back
and
include all the exceptions. Since you chose an end date on the export,
your
original appointment will stop there, but all your exceptions will be
intact. You can then create a new recurring appointment from the new
time
onward. You can also delete the extra calendar folder you created, since
you now have the information you wanted in your main calendar again.

You don't really need to create a second calenar folder if you don't want
to, but then you'd have to edit the export file to remove everything but
the
one appointment series, and I would find using a temporary second
calendar
folder easier because I don't have to sort through all the items I don't
want.
--
Brian Tillman [MVP-Outlook]


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.