Hi, I want to export the column data e.g. Subject, Date & Time, & From, to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data. Can this be done ?
Regards
Graham

One message or a ton of them..?

--
...winston
ms-mvp mail

"Graham" wrote in message ...
Hi, I want to export the column data e.g. Subject, Date & Time, & From, to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data. Can this be done ?
Regards
Graham

SysExporter
Outlook Express Tree Lists and Message Lists (NT/2000/XP)
http://www.nirsoft.net/utils/sysexp.html

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, &
From, to
Excel (or similar) for editing to insert into a report. I don't need
the
content of each email, just the message data. Can this be done ?
Regards
Graham

I already did it with OETool. www.oehelp.com/OETool/

steve

"Michael Santovec" wrote in message
...
SysExporter
Outlook Express Tree Lists and Message Lists (NT/2000/XP)
http://www.nirsoft.net/utils/sysexp.html

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, & From,
to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data. Can this be done ?
Regards
Graham

I already did it with OETool. www.oehelp.com/OETool/

steve

"Michael Santovec" wrote in message
...
SysExporter
Outlook Express Tree Lists and Message Lists (NT/2000/XP)
http://www.nirsoft.net/utils/sysexp.html

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, & From,
to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data. Can this be done ?
Regards
Graham

"Graham" wrote in message ...
Hi, I want to export the column data e.g. Subject, Date & Time, & From, to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data.

Can this be done ?


Roughly. Drag all the messages to an empty directory.
That creates .eml or .nws files from them.
Those are also text files, so you can use other standard parsing
tools to create the records from them.

For example, entering this at the command line of a cmd window
at that directory level would extract only lines like you're asking for:

findstr /i "^Subject: ^Date: ^Time: ^From:" *

(Leave the ignore case switch off if you are sure of the capitalization
of your header labels.)


Then you would have to figure out how to combine the four lines
that would find into one record for your Excel program to read.

One option I think would be the Log Parser Utility...

http://www.microsoft.com/downloads/d...displaylang=en
quote
Log parser is a powerful, versatile tool that provides universal query access to
text-based data such as log files, XML files and CSV files, as well as key data
sources on the Windows® operating system such as the Event Log, the Registry,
the file system, and Active Directory®.
/quote

I am sure you could use Log Parser to solve your problem
but I haven't used it enough to suggest how you might do that
exactly. (It would probably quickly go too far off-topic anyway.)
I think you could find afficionados who would be keen
to demonstrate how though. ; )


Regards
Graham


Good luck

Robert Aldwinckle
---

Just get OETool: www.oehelp.com/OETool/ There is a button that exports the
message list into a CSV file that you can then import into Excel.

steve

"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, & From, to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data. Can this be done ?
Regards
Graham

Hi All,
Thank you for your input.
I have about 30 messages that I want to extraxt info on. I was hoping that
there was a simple Copy/Paste command that I could use.
I've downloaded the OE Tool and new tol bar is showing, but I can't see a
button to export to a CSV file.
I suspect I'll be quicker manually typing the info over that I need,
tedious, buut at least I'll get the job done.
Thank you all anyway
Regards
Graham
"Steve Cochran" wrote:

Just get OETool: www.oehelp.com/OETool/ There is a button that exports the
message list into a CSV file that you can then import into Excel.

steve

"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, & From, to
Excel (or similar) for editing to insert into a report. I don't need the
content of each email, just the message data. Can this be done ?
Regards
Graham

The 4th button from the right ("View Header List") will generate a csv file
on the Desktop (or wherever OETool.exe is located) which contains the
information in the Header list of the folder being displayed.

From the website (www.oehelp.com/OETool/):

"Button 11: View Header List -- This will display the message headers of
the OE folder in an IE window, allowing them to be saved and printed. It
also generates a CSV file (Tab delimited), "Headers.csv" in the same
directory as the OETool.exe file, to enable importing of the message list
into a spreadsheet or database. This feature will probably not function in
Win9X.
"

steve

"Graham" wrote in message
...

Hi All,
Thank you for your input.
I have about 30 messages that I want to extraxt info on. I was hoping that
there was a simple Copy/Paste command that I could use.
I've downloaded the OE Tool and new tol bar is showing, but I can't see a
button to export to a CSV file.
I suspect I'll be quicker manually typing the info over that I need,
tedious, buut at least I'll get the job done.
Thank you all anyway
Regards
Graham
"Steve Cochran" wrote:

Just get OETool: www.oehelp.com/OETool/ There is a button that exports
the
message list into a CSV file that you can then import into Excel.

steve

"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, & From,
to
Excel (or similar) for editing to insert into a report. I don't need
the
content of each email, just the message data. Can this be done ?
Regards
Graham

The 4th button from the right ("View Header List") will generate a csv file
on the Desktop (or wherever OETool.exe is located) which contains the
information in the Header list of the folder being displayed.

From the website (www.oehelp.com/OETool/):

"Button 11: View Header List -- This will display the message headers of
the OE folder in an IE window, allowing them to be saved and printed. It
also generates a CSV file (Tab delimited), "Headers.csv" in the same
directory as the OETool.exe file, to enable importing of the message list
into a spreadsheet or database. This feature will probably not function in
Win9X.
"

steve

"Graham" wrote in message
...

Hi All,
Thank you for your input.
I have about 30 messages that I want to extraxt info on. I was hoping that
there was a simple Copy/Paste command that I could use.
I've downloaded the OE Tool and new tol bar is showing, but I can't see a
button to export to a CSV file.
I suspect I'll be quicker manually typing the info over that I need,
tedious, buut at least I'll get the job done.
Thank you all anyway
Regards
Graham
"Steve Cochran" wrote:

Just get OETool: www.oehelp.com/OETool/ There is a button that exports
the
message list into a CSV file that you can then import into Excel.

steve

"Graham" wrote in message
...
Hi, I want to export the column data e.g. Subject, Date & Time, & From,
to
Excel (or similar) for editing to insert into a report. I don't need
the
content of each email, just the message data. Can this be done ?
Regards
Graham