Solved

automatically copying events from one calendar to another calendar???

Posted on 2006-11-16
1
213 Views
Last Modified: 2010-04-08
Hi,

I have two calendars and I want to write up a code or macro to copy events from one calendar to anther.
I have one chief calendar and he would like to copy to allManagersCalendar each day.

How do I do this in VB or should  I try to do this in Macro??
Thanks for your help as always

0
Comment
Question by:dkim18
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 18015136
If you want to do this from inside Outlook, then use a macro.  Otherwise, use VB.  If you plan to run the code from a central location, then the account the code is run under must be given access to all of the managers' calendars and they must all be added to an Outlook profile.  The other issue to deal with is how to make this work.  You don't really want to copy the events, you want to do a one way synchronization from each manager's calendar to the central calendar.  The problem is how to identify which event came from which calendar and how to tell when an item has changed or when one has been deleted.  That's a bit more difficult in Outlook than it might seem.  The only unique value in an Outlook item is the "EntryID".  Unfortunately it's of little use since it changes if the item is moved or copied to a different folder.  For example, let's say we have an appointment with an EntryID of 1233456 on manager A's calendar.  When we copy the appointment to the shared calendar the EntryID will no longer be 123456, leaving us unable to use the EntryID to identify the item on future synchronization runs.  Using an item's subject is unsafe, since it's entirely possible that multiple managers would have a common appointment.  To get around the problem of uniquely identifying each item requires creating a user-defined field in the source item to hold the unique value.  The next step is to devise a way of generating unique values for each calendar.  Adding items in a syncing run is simple.  Merely search the shared calendar for an item with a matching unique key value.  If none is found, then add the item to the shared calendar.  If the item is found, then update it.  Deleting items is a bit more difficult.  It requires reversing the process and reading through the items on the shared calendar and searching the individual calendar for a match.  If one is not found, then the code needs to delete the item from the shared calendar.
0

Featured Post

Scamming the Scammers!

Have you ever heard of Scam Baiting?
It's a highly entertaining sport that you can participate in.
Introduction to beating scammers at their own game and how you can help
Share your thoughts, ideas and experiences on the topic.
Links to top Anti-Scam resources provided.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft Outlook 2016/365 1 61
Restriction incoming email to Exchange 2010 4 62
exchange, outlook, calendar 11 61
Outlook Outbox Messages in Exchange 4 28
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Changing a few Outlook Options can help keep you organized!
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question