Powershell Script - Outlook Folder & eMail list

 This script to can be used to get the list of folders in Inbox and list the eMails. 

clear

$outlook = new-object -com Outlook.Application

$Namespace = $Outlook.GetNameSpace("MAPI")

$mb=$outlook.session.folders|?{$_.name -like "**MailBox***"}

$inbox = ($mb.folders |?{$_.name -eq "Inbox"}).folders

$Namespace.Folders.Item(1).folders.Item('Inbox').items | select -Property subject, receivedtime

  foreach ($f in $inbox ) {

    Write-Host  $f.name

     Write-Host  "----------------------------"

   if ($f.name -eq "Folder1" -Or $f.name -eq ".Folder2") {

       $Namespace.Folders.Item(1).Folders.Item('Inbox').Folders.Item($f.Name).Items |  sort receivedtime -desc |  %{echo   $_.subject }

   } #End If

         } #End ForEach

Fixed: Excel date format mix up issue

Date's got formatted in multiple type with "/" and "-".
This will make it difficult to sort and filter in excel.

Below dates got mixed up with but showing in  MM/DD/YYYY and MM-DD-YYYY format.

Fixed using below formula

=TEXT(DATE(RIGHT(TEXT(B2,"dd/mm/yyyy"),4),LEFT(TEXT(B2,"dd/mm/yyyy"),2),MID(TEXT(B2,"dd/mm/yyyy"),4,2)),"mm/dd/yyyy")

Now it will all show in same format.

Outlook - Auto discover issue

Outlook 2016 with Office 365 going through additional login validation.
Like SMS or Call confirmation for accessing email through outlook.

Autodiscover is causing this issue, to suppress this additional prompting and using outlook.

Create below entries in registry.

Path	DWORD	Value
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Outlook\AutoDiscover	ExcludeHttpsRootDomain	1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Outlook\AutoDiscover	ExcludeScpLookUp	1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Identity	EnableADAL	0

Snipping Tool


Windows 7 and windows 8 have this tool to capture image from screen.

Instead of taking whole screen as a screen shot we can snip a selected part of screen.

Once snipping of image is done, we can save or highlight the text in it.

Use XP's Applications in Windows 7 and Windows 8 

Troubleshoot compatibility

Right click on the setup select Troubleshoot compatibility

 Then select Try recommended settings

Then Select Next

Installation will be started in Windows Xp mode.