[Microsoft Outlook] 如何在 outlook 中，找出未讀取的信件

Problem
如何在 outlook 中，找出未讀取的信件

How-To
Step 1. 點選收件夾
Step 2. 點選搜尋方格
Step 3. 點選未讀取

[Windows] 用 Excel 打開 CSV，繁體中文都是亂碼

Problem
當我在 Windows 7 打開一份 CSV 檔案，在 Mac 平台可以正常顯示繁體中文，但是在Windows 平台卻是亂碼


Solution
Step 1. 打開 Excel
Step 2. 資料 => 從文字檔


Step 3. 選取要匯入的 CSV 檔案


Step 4. 透過預覽的方式，選擇編碼方式，如原本是 UTF-8，將其修改為 BIG5 就可以正常顯示了




Reference
[1] http://goo.gl/an21Zo

[Windows 7] 參考到的帳戶目前已鎖定，且可能無法登入

Problem
有次在登入windows 7的帳號密碼時，因故輸入三次錯誤，導致電腦被鎖定，即便是重新開機以後還是出現相同的錯誤訊息


Solution
由於之前已經有過一次經驗，必須要有windows 7光碟進入才有辦法解決，故經過上次以後，有建立一個擁有 administration 權限的另外一個 user

所以在本次，我只要先重開機，按下F8，選擇以安全模式進入Windows，再利用另外一個帳號log in 進去

Steps:
1. 在我的電腦按下右鍵，選擇管理


2 .系統工具=>本機使用者與群組=>使用者


3. 於 lock 的使用者帳號按下滑鼠右鍵，選擇內容



4. 將最後一個 checkbox 勾勾取消，並重新開機即可

[Windows] svchost 狂吃 RAM

Problem
某天打開電腦 (OS: Windows 7)，發現整台電腦跑得非常慢
打開工作管理員以後，發現我的 RAM 幾乎被 svchost 這個 process 吃光光所導致


How To
執行以下步驟可以解決此問題
1. 打開命令提示字元，執行以下指令，重新註冊 DDL：
REGSVR32 WUAPI.DLL
REGSVR32 WUAUENG.DLL
REGSVR32 ATL.DLL
REGSVR32 WUPS.DLL
REGSVR32 WUPS2.DLL

2. 在命令提示字元中，執行以下指令暫停Automatic Updates服務：
net stop WuAuServ

3. 進入 C:\windowns，rename  SoftwareDistribution 成其他名字

4. 在命令提示字元中，執行以下指令重新啟動Automatic Updates服務：
net start WuAuServ

5. restart computer

打開工作管理員觀察，可以發現 svchost 吃的記憶體下降非常多，整台電腦就不在像調整前卡卡遲鈍了


Reference
[1] http://sungshu.pixnet.net/blog/post/195361068-%5Bwin%5Dsvchost.exe%E7%8B%82%E5%90%83%E8%A8%98%E6%86%B6%E9%AB%94

[Microsoft Outlook] reading pane had been disabled

Problem
One day I found out my reading panel had been disabled in Microsoft Outlook.

It is very inconvenient for me, because I cannot preview my email anymore.

Root Cause
Because of corporate's security policy, it disabled all employees' reading panel in everyone's Microsoft Outlook.

Solution
1. Start => type in "regedit" => enter

2. Find the registry : HKEY_CURRENT_USER\Software\Policies\Microsoft\office\14.0\Outlook\options

3. Change the value of property, disablereadingpane, from 1 to 0

4. Restart Microsoft Outlook

Reference
[1] http://www.slipstick.com/outlook/rules/disable-outlooks-reading-pane/

How to find out the PID (process ID) of processes in Windows

Problem
If I would like to find out the PID of javaw.java proecess, how do I do?
Windows task manager seems does not have PID information.

Solution 1
View-->Selected Columns-->Checked PID-->OK

Then we can find out the PID information.

Solution 2

Open command prompt, and execute tasklist /fi "Imagename eq JAVAW.exe"

Then we can get the PID information

映像名稱                       PID 工作階段名稱      工作階段 #    RAM使用量

========================= ======== ================ =========== ============

javaw.exe                    10368 Console                    1  1,620,884 K

Reference

[1] http://technet.microsoft.com/en-us/library/bb491010.aspx

How to set Static IP Address from command line

Requirement
Owing I need to move workplace from office to customer site lately, I need to change my laptop's IP address as I change workplace. So I edit a batch file to set my static IP address automatically.

Syntax
Let’s say I want to give my Windows 7 system an IP address of 10.144.38.195, a subnet mask of 255.255.255.0, a default gateway of 10.144.38.254. Type the following command and save as a batch file with encoding with ANSI

 netsh interface ipv4 set address name="區域連線" source=static address=10.144.38.195 mask=255.255.255.0 gateway=10.144.38.254  

The address will be found via netsh interface ipv4 show interfaces command.

Idx   Met     MTU     狀態         名稱  
 --- ---------- ---------- ------------ ---------------------------  
  1     50 4294967295 connected   Loopback Pseudo-Interface 1  
  13     50    1500 disconnected 無線網路連線  
  12      1    1500 disconnected 區域連線  
  19     30    1500 disconnected 區域連線 2  
  16     40    1500 disconnected Bluetooth 網路連線  
  20     20    1500 connected   區域連線 3  

In this case, I would like to configure 區域連線. So the address name="區域連線"

Step by step
Step1. open command prompt.
Step2. execute the batch script file, i.e.SetIP4Office.bat

 C:\Users\albert\Desktop>SetIP4Office.bat  
 C:\Users\albert\Desktop>netsh interface ipv4 set address name="區域連線" source=static address=10.14  
 4.38.195 mask=255.255.255.0 gateway=10.144.38.254  

Well Done!

So you can edit different batch files to set different IP address for different workplace.

Reference
[1] http://www.windowsreference.com/networking/how-to-set-staticdhcp-ip-address-from-command-line/

Bat(Batch) script 執行出現出現中文亂碼問題

Problem
I edit a batch script which be used to set IP address

netsh interface ipv4 set address name="區域連線" source=static address=10.144.38.195 mask=255.255.255.0 gateway=10.144.38.254 

But when I execute this batch script in command prompt, it seems that the Traditional Chinese characters are broken.

C:\Users\albert\Desktop>netsh interface ipv4 set address name="?€?€??" source=static address=10.14  
 4.38.195 mask=255.255.255.0 gateway=10.144.38.254  
 檔案名稱、目錄名稱或磁碟區標籤語法錯誤。  

Solution
This problem results from the encoding of the batch script file. You need to change its encoding from UTF-8 to ANSI.

Reference
[1] http://www.bathome.net/viewthread.php?tid=24088

Windows 無法自動偵測此網路的proxy設定

今天在公司，突然電腦無法上網，出現 "Windows 無法自動偵測此網路的proxy設定 (Windows could not automatically detect this network's proxy settings)"此錯誤訊息
檢查了網路孔沒問題、ip相關設定沒問題，也重開機了，還是無法上網

最後 Google 到兩個指令，依照以下四步驟就可以解決了(只是還是不知道原因是什麼)：

1. 打開命令提示字元 (open command line)
2. 執行 netsh winsock reset (execute netsh winsock reset)
3. 執行 netsh int ipv4 reset (execute netsh int ipv4 reset)
4. 重開機 (reboot)

Reference：http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/windows-could-not-automatically-detect-this/d243dea1-d1c8-4c4a-ba96-2b49bc9bab1a