[gonzomd]

Hello. I manage multiple users in an office. We all use Microsoft Exchange Server with Office 2007.

We have a Spreadsheet that assigns duties for each half day and would like to have these added to each users Outlook Calendar. I reviewed an older post about putting events from Excel on to Outlook; however, that would only seem to work if I was wanting to post them on my own calendar. We can set up to have the person who maintains the schedule get shared permission to everyone's calendar, but is there a way to write the macro to put the event on a specific shared calendar?

Thanks for any assistance.