Archive for category MS Office

Outlook: Hong Kong Holidays 2010

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.

outlook01

outlook02

outlook03

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.18_1163]
Rating: 0 (from 0 votes)
Total views: 10,993 views

, ,

2 Comments

Outlook: Hong Kong Holidays 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

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.18_1163]
Rating: 0 (from 0 votes)
Total views: 3,582 views

, ,

No Comments

Modify Outlook 2007 View by using vbscript (vbs)

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

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

After running vbs, modified Outlook view

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.18_1163]
Rating: 0 (from 0 votes)
Total views: 22,731 views

, , , ,

1 Comment