J
Joel M. Devonshire
I'm trying to have four users have a single shared calendar that has a
single category associated with it. We are using the program
"ShareOutlook," which lets users share folders through special emails, so
I'm not using an Echange Server.
What I want to do, however, is write macros that will watch each person's
personal calendar, and whenever they add, change, or delete an item of the
particular category of interest, then it will update the shared calendar
accordingly. So, in other words, on each person's copy of Outlook, they
have this separate calendar folder (which is named the same on each machine)
that is shared.
What I've done so far is write macros that use the Item.Add and Item.Change
functions. When an item is added to a personal calendar, it checks to see
if the category matches the one of interest, and if it does, then it copies
and moves the item to the shared calendar. If a person changes a relevant
item in their own calendar, it finds that same item in the shared calendar,
deletes it and re-copies it (to reflect the new changes). Finally, if
someone deletes a relevant item, I have a macro that watches the
DeletedItems folder for that category, and then it deletes that item in the
shared calendar.
Is there a better way of going about this? I'm having troubles, for
instance, with looping. For example, when a person adds a relevant item to
their personal calendar, the macro copies that item and moves the copy to
the shared calendar....but in the process of doing that, Outlook thinks that
a new item has been added to the personal calendar, thereby causing the
procedure to loop endlessly (interestingly, I don't get this problem if I
let the user choose which folder to move the item to).
Also, I get looping when a person deletes a relevant item from their
personal calendar. When a person deletes an item, that item goes into the
DeletedItems folder, triggering the macro that also deletes that item from
the shared calendar. However, when the shared calendar item is deleted,
than that ALSO goes to the DeletedItems folder, thereby triggering the same
procedure.
I'm just wondering if there's just an easier way of doing this. It seems
very difficult to track the same item between folders because their
entryID's change whenever you move them! So I end up having to loop through
each folder, looking for the item of interest (I see if the subject of the
given item matches the one I'm looking for, which in itself can cause
problems if a person has changed the subject of their personal calendar
item, the very change I'm trying to have be reflected in the shared
calendar).
Does anyone have any suggestions?
Thanks,
-Joel
single category associated with it. We are using the program
"ShareOutlook," which lets users share folders through special emails, so
I'm not using an Echange Server.
What I want to do, however, is write macros that will watch each person's
personal calendar, and whenever they add, change, or delete an item of the
particular category of interest, then it will update the shared calendar
accordingly. So, in other words, on each person's copy of Outlook, they
have this separate calendar folder (which is named the same on each machine)
that is shared.
What I've done so far is write macros that use the Item.Add and Item.Change
functions. When an item is added to a personal calendar, it checks to see
if the category matches the one of interest, and if it does, then it copies
and moves the item to the shared calendar. If a person changes a relevant
item in their own calendar, it finds that same item in the shared calendar,
deletes it and re-copies it (to reflect the new changes). Finally, if
someone deletes a relevant item, I have a macro that watches the
DeletedItems folder for that category, and then it deletes that item in the
shared calendar.
Is there a better way of going about this? I'm having troubles, for
instance, with looping. For example, when a person adds a relevant item to
their personal calendar, the macro copies that item and moves the copy to
the shared calendar....but in the process of doing that, Outlook thinks that
a new item has been added to the personal calendar, thereby causing the
procedure to loop endlessly (interestingly, I don't get this problem if I
let the user choose which folder to move the item to).
Also, I get looping when a person deletes a relevant item from their
personal calendar. When a person deletes an item, that item goes into the
DeletedItems folder, triggering the macro that also deletes that item from
the shared calendar. However, when the shared calendar item is deleted,
than that ALSO goes to the DeletedItems folder, thereby triggering the same
procedure.
I'm just wondering if there's just an easier way of doing this. It seems
very difficult to track the same item between folders because their
entryID's change whenever you move them! So I end up having to loop through
each folder, looking for the item of interest (I see if the subject of the
given item matches the one I'm looking for, which in itself can cause
problems if a person has changed the subject of their personal calendar
item, the very change I'm trying to have be reflected in the shared
calendar).
Does anyone have any suggestions?
Thanks,
-Joel