VB script to add Holidays in Outlook 2010

Posted on 2011-10-07
Medium Priority
Last Modified: 2012-05-12
Just been assigned to add US and Jewish Holidays into everyone's calendar.  After doing a little Googling, I found this:


This script worked very well, but I would like to make some changes and I was hoping a VBS guru could give me a hand.  
1.  Instead of entering all of the holiday dates right underneath the dictionary object, can I make this script reference a txt file?  The file I am particularly talking about is the .hol file within Outlook.
2.  The .hol file within Outlook is in this format:
     [United States] 384
     Christmas Day,2009/12/25
     Christmas Day,2010/12/25
     [Jewish Religious Holidays] 148
Would this script read this Outlook.hol file with the syntax above, especially when the format of this Outlook.hol file is Name,Date + for the Jewish Holidays it's Name,Date(different type of calendar),Number(I am not even sure what this number represent - maybe for sort of calendar category?)
3.  I would like to also categorize this event as a Holiday within Outlook.  The script does not put the event in any type of category.  

Any help on this is greatly appreciated.

Question by:Wilmette
  • 3
LVL 59

Expert Comment

by:Bill Prew
ID: 36932539
The script could be adjusted to read a text file, but the .HOL file should already be in the Outlook calendar, so not sure why you are adding them again via a script?

LVL 59

Expert Comment

by:Bill Prew
ID: 36932556
Also be aware that Microsoft makes available a standard set of holidays that you can add to Outlook without scripting, as in:




Author Comment

ID: 36932583
Sorry I didn't clarify.  I want to create a script that will automate the process of importing the Holidays (that we want created and imported) into all of the users' Calendar.  The user should not do anything, but maybe except just double-clicking on the script - and that's it.  Currently, the best that I can do is just double-click the modified .hol file, select the country(s) that I want imported and click OK.  I want to go beyond this - maybe just a one time double-click and all of the Holidays are imported without any further user intervention.  No user intervention is ideal.

LVL 59

Accepted Solution

Bill Prew earned 2000 total points
ID: 36963694

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Suggested Courses

621 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