Avatar of Wilmette
WilmetteFlag for United States of America

asked on 

VB script to add Holidays in Outlook 2010

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.

VB ScriptOutlook

Avatar of undefined
Last Comment
Bill Prew
Avatar of Bill Prew
Bill Prew

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?

Avatar of Bill Prew
Bill Prew

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



Avatar of Wilmette
Flag of United States of America image


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.

Avatar of Bill Prew
Bill Prew

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo