Link to home
Start Free TrialLog in
Avatar of perifel
perifel

asked on

How to pass appointments from a Shared Calendar To personal Calendar in a Outlook Macro?

We want to be able to automatize the process of copy all the appointments in a shared Calendar to the personal calendar, since the only way to do this is selecting the appointments on the shared calendar and copy them to the personal calendar. we tried to use macros to do that but the macro recorder is not avaliable in outlook so we need to use a vbscript for the macro...
Avatar of David Lee
David Lee
Flag of United States of America image

Hi, perifel.

That's doable, but it does present a problem.  Copying all the appontments from the shared to the personal calendar the first time is simple.  After that things become more difficult.  Unless the personal calendar is always going to be just an exact copy of the shared calendar, then you're faced with synchronizing the two calendars or with devising a way to erase the items from the shared calendar before the next run.  Synchronizing isn't a simple process.  It's possible, but it's complicated.  If you don't want to sync, then finding a way to delete the old appointments from the shared calendar is a must.  Othewise, you end up with duplicate appointments.  Deleting the appointments from the shared calendar is a lot easier than syncing, but it'll still require some planning.  If you want to go this route, non-syncing, then I can provide the code.  If you want to sync, then I'll be glad to offer suggestions, but that's too involved for me to produce the code.
Avatar of perifel
perifel

ASKER

Thanks for your coments!

It would be great if you can give us, both, the code for the non-sync  way, and the suggestions to the sync way, so we can work it out, and find the solution that fits the best for us.

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of perifel

ASKER

Thanks!

We´ve already made a couple of scripts that solve th problem in a non sync way. the main diference with the code you gave us, is that we "peek" into the shared calendar and only copy the appointments that are necesary, also we use some restrictions in the script so it have a better performance, (In calendar with many appointments the response time was too long)

Thanks for your help an if someone wants the code we made, contact us ;).
You're welcome.  Glad I was able to help out.