Archive for category MS Office
Outlook: Hong Kong Holidays 2010
Posted by Victor Tong in MS Office, Uncategorized on September 20th, 2009
Hong Kong Holidays 2009 for Outlook 2007
Reference:
http://www.gov.hk/en/about/abouthk/holiday/2010.htm
Hong Kong Holidays 2010 for Outlook:
HK2010 Holidays Outlook
Installation:
1. Download Holidays file
2. Double-click the holidays file
3. Click OK
4. Click OK
5. Open Outlook Calendar, Holidays information imported.


Outlook: Hong Kong Holidays 2009
Posted by Victor Tong in MS Office, Uncategorized on September 20th, 2009
Hong Kong Holidays 2009 for Outlook 2007
Reference:
http://www.gov.hk/en/about/abouthk/holiday/2009.htm
Hong Kong Holidays 2009 for Outlook:
HK2009_Holidays
Modify Outlook 2007 View by using vbscript (vbs)
Posted by Victor Tong in Exchange Server, MS Office on September 20th, 2009
Currently I am checking how to modify Outlook 2007 default view by using vbs.
Following is my working vbs. You can download and test it.
MSDN reference:
http://msdn.microsoft.com/en-us/library/bb177050.aspx
VBS code example
Const ForReading = 1
Const olFolderInbox = 6
Const olColorRed = 10
Set olApp = CreateObject("Outlook.Application")
Set objName = olApp.GetNameSpace("MAPI")
Set objTableView = objName.GetDefaultFolder(olFolderInbox).CurrentView
objTableView.ColumnFont.Size = 10
objTableView.ColumnFont.Name = "Arial"
objTableView.RowFont.Size = 10
objTableView.RowFont.Name = "Arial"
objTableView.AutoPreviewFont.Name = "Arial"
objTableView.AutoPreviewFont.Size = 10
' Save the table view.
objTableView.Save
objTableView.Apply
Set objView = objName.GetDefaultFolder(olFolderInbox).CurrentView
For Each objRule In objView.AutoFormatRules
If Not objRule.Name = "Unread group headers" Then
'MsgBox objRule.Name
'MsgBox objRule.Font.Color
objRule.Font.Color = olColorRed
End If
objRule.Font.Size = 10
objRule.Font.Name = "Arial"
Next
objView.Save
objView.Apply
wscript.echo "Completed"
Outlook 2007 default view

Outlook 2007 default view
After running vbs, it makes the following change
1. Font changed from Segoe to Arial
2. Font size changed to 10pt
3. Unread mail changed from black to red

After running vbs, modified Outlook view

Comments