Automating the distribution of a company Outlook.hol file to all users.

We want to be able to use outlook.hol to post company events and holidays.  We can edit the file and make it available to all of our users, but my question is this:

Since this file will require periodic updates throughout the year, is there away we can automate the distribution and the subscription to the file?  Perhaps use a GPO to push out the file and/or do the Tools>Options>Calendar Options>Add Holidays>Click on the appropriate category and OK?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David LeeCommented:
Hi dmbonilla4,

I'm not sure this is going to work the way you may be thinking.  Adding holidays to a calendar is a one-way process.  There is no synchorization or updating.  If you a Company Picnic on May 1st, and then it changes, each employee would have to remove the first entry and then add the second entry.  If you run a holiday file multiple times it adds multiple entries, it doesn't adjust the existing entries.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dmbonilla4Author Commented:
Thank you for the info BlueDevilFan (they disappointed me in the NCAA Tourney, as I'm sure you were too).  I understand the problem with changing a scheduled event but, if we add an event between two others, would the first two events be duplicated when the holiday file is run the second time? Thanks again.
dmbonilla4Author Commented:
Thank you again BDF.  I've got what I need.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

David LeeCommented:
You're welcome.  Yes, I was very disappointed.  To asnwer your question, yes, if you inserted event C between events A and B and ran the file again you'd end up with 1 C and 2 each A and B.  I was going to offer an alternative to using .hol files using a bit of VBScripting.  Let me know if you're interested in that.
dmbonilla4Author Commented:
I am always interested in alternatives.  Please educate me.  Thank you.
David LeeCommented:
I wrote the script below to allow staff to add events like pay period starting and ending dates, company functions, etc. to their calendars.  The script reads a file containing one event per line in the form EVENT NAME:EVENT DATE.  The script could be modified to check for the existence of a given appointment and update it if it is found, or add it if it isn't.  The script and data file can be placed on a network share or a web site and employees sent a link.  All they have to do is click on the link.  When they do the script runs and modifies their calendar.

Dim olkApp, olkCalendar, olkEvent, objFSO, objFile, arrItem, strFilename
strFilename = WScript.Arguments(0)
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile(strFilename)
Set olkApp = CreateObject("Outlook.Application")
Set olkCalendar = olkApp.GetNamespace("MAPI").GetDefaultFolder(9)
Do While Not objFile.AtEndOfStream
    arrItem = Split(objFile.ReadLine, ":")
    Set olkEvent = olkApp.CreateItem(1)
    olkEvent.Subject = arrItem(0)
    olkEvent.Start = arrItem(1)
    olkEvent.AllDayEvent = True
    olkEvent.ReminderSet = False
Set olkEvent = Nothing
Set olkCalendar = Nothing
Set olkApp = Nothing
Set objFile = Nothing
Set objFSO = Nothing
WScript.Echo "Events Added"
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.