search .msg files for email address

[uffolsen]

Is there a way to write a script that search multiple .msg files containing email address and write it to an excel file ? I´ve searched for hours and need some help, I´m a newbee in vbscript.

Best regards
Glenn

 

[dm4ever]

You can looks at these examples:

http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug06/hey0802.mspx

http://www.microsoft.com/technet/scriptcenter/resources/qanda/all.mspx

http://www.microsoft.com/technet/scriptcenter/resources/officetips/archive.mspx

And if you don't find what you need you'll have to look at the Reference docs and see if you can figure it out.

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[dilettante]

Outlook .msg files are OLE Structured Storage (compound) files. I'm not sure about the ones Outlook Express makes. Doesn't it save as .eml files or something?

The problem is their actual content varies a lot with the mail provider (Exchange vs. Internet) and the source and destination (local Exchange mailbox or other), and whether there is Text and/or HTML mail in them. Some addresses are hard to find, it isn't always as simple as just finding a To or From, and for that matter there may be multiples.

I don't know of any built-in way for VBScript to even read such files, though you might find some component to enable this. It's hard enough from VB6!

You might try Outlook Redemption but it may require Outlook installed on the machine to work. I don't know a lot about it.

This is actually a lot hairier subject than it appears.

 

[dilettante]

I should add that when Exchange is the mail provider Outlook is using, addresses may look like:

From: [tt]/O=SPUMCO/OU=WACKED/CN=RECIPIENTS/CN=STIMPY[/tt]