Have you asked this in the Outlook Developers arena? I think you
will get a much better response from the folks that work with this
regularly.
Below are some GREAT resources for you:
microsoft.public.outlook.program_forms
Yahoo! Groups:
http://groups.yahoo.com - Outlook-Dev
http://tech.groups.yahoo.com/group/outlook-dev/
Slipstick:
http://www.slipstick.com
Sue Mosher's Outlook Developer:
www.outlookcode.com/
Nikki Peterson
The macro is used to send out the schedule for the team (daily tasks
that need to be performed) as AppointmentItems.
Example:
4 employees: Andy, Brenda, Chris and Diana
3 tasks that have to be performed throughout the day like:
1 - "Ensure windows are clean", 2 - "Jump around and look happy" and 3
- "Make weird noises"
Now the macro first assignes the people to the tasks like:
AM 1 -> Andy AM 2 -> Chris AM 3 -> Brenda
PM 1 -> Chris PM 2 -> Diana PM 3 -> Andy
Then Andy who is assigned to take care of the schedule sends out the
meeting invitations (by clicking on the appropiate button):
1. The macro saves appointments in the group calendar with title:
Ensure windows are clean AM (Andy) ; Jump around and look happy AM
(Chris) , etc as full day meetings (mgmt requirement to have them
like this so they are at the top of the calendar)
2. The macro sends out personal meeting invites on behalf of Andy. In
the following form:
Title: Make weird noises AM TO: Brenda Start: 8:30 AM End: 1:00
PM
Title: Make weird noises PM TO: Andy Start: 1:00 PM End: 5:30
PM
ETC
As a result today Andy's calendar is busy every day as it has all the
meeting invitations in it (except the ones saved in the group
calendar), but we only want Andy's calendar to show those timeframes
as busy where he is actually assigned.
If it is possible to send out meeting invitations without an organizer
(deleting it manually) then I believe it should be also possible
automatically, I just don't know how.
I greatly appreciate any help with this matter. If there is really
nothing else left I can set up a group calendar only for this purpose.