Forum Discussion
How to Export all Messages from MS Outlook into CSV file using PowerShell?
Hi guys,
I am trying to break the problem in to small piece.
1. Now I have the "Outlook Folder Path: \\Personal_PST\UserName1\Subfolder2.1\subfolder3.2" output.
2. I want to use this method "OutlookNameSpace.Folders.Item("Personal_PST").Folders.Item("UserName1").Folders.Item("Subfolder2.2").Folders.Item("Subfolder3.1").Items"
3. So I need to process the Outlook folder path into variable and use it in the OutlookNameSpace.
Here is my code so far but I do not know how to make the result display horizontal. I am open for any advice. Thank you very much in advance.
Code:
#PS Script End
# Clear console
Clear-Host
# Input Outlook folder path
$OutlookFolderPath = "\\Personal_PST\UserName1\Subfolder2.1\subfolder3.2"
# Split Outlook folder by \ and store ito array $SplitOutlookFolderPath
$SplitOutlookFolderPath = $OutlookFolderPath.Split("\")
Write-Host "Split Array Output: $SplitOutlookFolderPath"
$ArrayCount = $SplitOutlookFolderPath.Count
Write-Host "Split Array count : $ArrayCount `n"
foreach($FolderName in $SplitOutlookFolderPath)
{
#"$FolderName = " + $FolderName.length
if($FolderName.Length -ne 0)
{
$NewFolderName = $FolderName
Write-Host "$NewFolderName"
}
}
#Write-Host "`nOutlookNameSpace.Folders.Item(Personal_PST).Folders.Item(UserName1).Folders.Item(Subfolder2.2).Folders.Item(Subfolder3.1).Items`n"
#PS Script End
PS Script Output:
Split Array Output: Personal_PST UserName1 Subfolder2.1 subfolder3.2
Split Array count : 6
Personal_PST
UserName1
Subfolder2.1
subfolder3.2
I want the output to display like below:
Split Array Output: Personal_PST UserName1 Subfolder2.1 subfolder3.2
Split Array count : 6
OutlookNameSpace.Folders.Item(Personal_PST).Folders.Item(UserName1).Folders.Item(Subfolder2.2).Folders.Item(Subfolder3.1).Items