Use PowerShell to Data Mine Your Outlook Sent Items

re: Use PowerShell to Data Mine Your Outlook Sent Items

Craig Landis — Fri, 17 Jun 2011 13:34:00 GMT

If you receive error message:

Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80080005

Make sure that Outlook and Powershell are either both running as a standard user (not elevated) or that they are both running elevated as Administrator. They need to be running at the same integrity level to avoid that error.

re: Use PowerShell to Data Mine Your Outlook Sent Items

jrv — Tue, 14 Jun 2011 20:15:57 GMT

Steven -

Change: 'Select-Object -Property Subject, SentOn, Importance, To'

To: Select-Object *

This will retrieve all properties available.

re: Use PowerShell to Data Mine Your Outlook Sent Items

Steven White — Tue, 14 Jun 2011 17:28:28 GMT

"and I choose the four properties with which I want to work."

Does this mean that there are other properties? If so, how would I find them. I did try modifying the syntax of your script to see if I could obtain all properties, but I am not yet handy enough with Powershell to know how to do that successfully.

Thank you.

re: Use PowerShell to Data Mine Your Outlook Sent Items

Klaus Schulte — Thu, 26 May 2011 08:53:15 GMT

Hi Aemon,

I don't know why Add-Type thinks, that it must load version 12 of the Microsoft.Office.Interop.Outlook' assembly ... no idea!

BUT: As I had the same problem with Outlook 2003, I looked for the strong name of the assembly and used it with Add-Type

Add-Type -AssemblyName "Microsoft.Office.Interop.Outlook, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

this works for me!

kind regards, Klaus

re: Use PowerShell to Data Mine Your Outlook Sent Items

Aemon Murphy — Wed, 25 May 2011 23:08:27 GMT

Hi Ed.

We run Office 2003 here at work and I've had trouble getting this to run.

here's the first error:

PS H:\> $sentItems = Get-OutlookSentItems

Add-Type : Could not load file or assembly 'Microsoft.Office.Interop.Outlook, Version=12.0.0.0, Culture=neutral, Public

KeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

At H:\Scripts\Get-OutlookSentItems.ps1:51 char:10

+ Add-type <<<< -assembly "Microsoft.Office.Interop.Outlook"

+ CategoryInfo : NotSpecified: (:) [Add-Type], FileNotFoundException

+ FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.AddTypeCommand

I figure it's to do with Microsoft.Office.Interop version so I downloaded the Office 2003 Primary Interop Assemblies and installed them, still no luck.

Any help you can give be would be great. I'm probably not the only person running 2003... or am I(embarrassing)

Luv your work btw.