Macro for Outlook viewing Sharepoint Calendars

bruderbell

Active Member
Joined
Aug 29, 2006
Messages
374
Hi,
I have a vision for greater convenience when using sharepoint. I want to have a calendar draw its data from several lower level calendars. So if a manager manages 3 projects, I want each project to have its own calendar, and I want the manager to be able to see the 3 calendars in one calendar. I'm aware of the overlay feature of outlook, but I'm trying to find something that will populate a single "manager" calendar so that it can be viewed in sharepoint.

So I'm trying to write a macro that will fire when I create an appt on a sharepoint calendar (viewed in outlook) that will make a copy of that appt on another sharepoint calendar (also viewed in my outlook).

In a best case scenario, I'd come up with another macro that will fire when the sharepoint appt is deleted and it will delete the corresponding event on the second calendar.
I'm envisioning something that will create some sort of custom data ID for each appt that will allow identification of the duplicates. Maybe it could just be done with some simple if then statements matching the title, location, and description of the appts.

I'm in the starting phase of this, so I don't even have a start. Any ideas or resources are appreciated. Any code is even better :)
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top