VB script to add Holidays in Outlook 2010
Hi,
Just been assigned to add US and Jewish Holidays into everyone's calendar. After doing a little Googling, I found this:
http://technet.microsoft.com/en-us/library/ee692767.aspx
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
Hanukkah,5769/3/25,8
Hanukkah,5770/3/25,8
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.
-Thanks
Just been assigned to add US and Jewish Holidays into everyone's calendar. After doing a little Googling, I found this:
http://technet.microsoft.com/en-us/library/ee692767.aspx
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
Hanukkah,5769/3/25,8
Hanukkah,5770/3/25,8
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.
-Thanks
Last Comment
Also be aware that Microsoft makes available a standard set of holidays that you can add to Outlook without scripting, as in:
http://support.microsoft.com/kb/924423
http://blogs.office.com/b/microsoft-outlook/archive/2008/01/18/adding-holidays-to-your-outlook-calendar.aspx
~bp
http://support.microsoft.com/kb/924423
http://blogs.office.com/b/microsoft-outlook/archive/2008/01/18/adding-holidays-to-your-outlook-calendar.aspx
~bp
ASKER
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.
-Thanks,
-Thanks,
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
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.
Outlook
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.
105K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
~bp