How to target outlook subfolder using powershell

Question

I'm trying to filter about 2000 automated alerts in an outlook sub-folder.

I need to do the following series of steps:

Parse sub-folder Account Alert Lockouts
Search for a specific phrase that has a variable username
Dump out that whole phrase with the variable username into csv

Example Phrase

Account Name:       jdoe

I have all of the required emails in a sub-folder, I just need to analyze them.

I've gotten my code to work in the Inbox, but it doesn't cover the sub-folder.

Add-Type -Assembly "Microsoft.Office.Interop.Outlook"
$Outlook = New-Object -ComObject Outlook.Application
$namespace = $Outlook.GetNameSpace("MAPI")

$inbox = $namespace.GetDefaultFolder([Microsoft.Office.Interop.Outlook.OlDefaultFolders]::olFolderInbox)    

$RE = [RegEx]'(?sm)Account Name\s*:\s*(?<AccName>.*?)$.*'

$DebugPreference = 'Continue'

$Data = foreach ($item in $inbox.items) {
    if ($item.body -match $RE) {
        Write-Host "ding "
        [PSCustomObject]@{ AccName = $Matches.AccName }
    }
}

$Data 
$Data | Export-CSv '.\data.csv' -NoTypeInformation

Lews Therin · Accepted Answer · 2019-08-02 18:30:55Z

2

Per the documentation for NameSpace.GetDefaultFolder:

To return a specific non-default folder, use the Folders collection.

And the documentation for the Folders collection referenced above:

Use Folders (index), where index is the name or index number, to return a single Folder object. Folder names are case-sensitive.

You should be able to add this:

$subfolder = $inbox.Folders('Account Alert Lockouts')

and change your foreach to iterate over $subfolder.

edited Aug 2, 2019 at 18:30

answered Aug 2, 2019 at 18:23

Lews Therin

3,7872 gold badges33 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ghawblin Over a year ago

Ugh. I spend a couple hours researching other questions and yours is so stupid simple. I'm a big dummy. Yeah, it worked immediately just as you said. Thank you.

Lews Therin Over a year ago

Haha I've been there plenty of times. Glad I could help!

Collectives™ on Stack Overflow

How to target outlook subfolder using powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related