Posts

Showing posts from April 6, 2014

Outlook 2010 – AutoComplete & Suggested Contact

  http://www.slipstick.com/outlook/suggested-contacts-and-auto-complete-lists/   http://www.windowsreference.com/ms-office/how-to-enabledisable-autocomplete-in-ms-outlook/   Outlook.exe /CleanAutoCompleteCache

E14- Bulk update Phone

    Name BusinessPhone ABC.DEF 1234-5678   1. [PS] C:\>$csvinfo = Import-Csv   extension.csv 2. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | ft Name,Phone >>c:\before_ext-1.txt } 3. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | Set-User -Phone "$($Line.Busine ssPhone)"} 4. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | ft Name,Phone >>c:\after_ext-1.txt } 5.. excel 檢核 =IF(A2=D2,"Y","No")