Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

"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
---

Export Folder Column data to Excel
 

"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
---

Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

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

Export Folder Column data to Excel
 

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