Exporting emails to Excel

[gb]

Hi

One of my colleagues has the most peculiar way of dealing with her emails
(through lack of education really) and has an inbox full of hundreds, if not
thousands, of emails. There is no organisation to them and it's getting out
of hand.

We use Exchange and I have been asked to backup her emails somewhere and
start afresh, whilst trying to train her on how to use and manage Outlook
2000 and her emails.

I thought about exporting her emails to Excel, using the from, to, subject
and body headers. The idea would be to have a list that's relatively 'easy
on the eye' and an easy way of performing searches, should the need arise,
rather than just compiling a .pst or pulling all of the emails into a
folder, where only the subject line will be available.

I tested the Excel idea with my own email and I find that the body of the
message is severely truncated. This obviously negates the idea if the full
body of the message can't be read.

Is there a way to ensure the full text is exported? Or, do you know of an
alternative method to use that allows a simple means of backing up the data
using the from, to, subject and body headers, whilst keeping a
straight-forward interface to search? I did try exporting to a basic text
document, which worked, but all of the information is listed like an
extremely long email, which, considering the volume of emails at stake, is
not a good idea.

I hope this makes sense! Thanks in advance for any help you may be able to
give.

gb

 

[Brian Tillman]

I thought about exporting her emails to Excel, using the from, to,
subject and body headers. The idea would be to have a list that's
relatively 'easy on the eye' and an easy way of performing searches,
should the need arise, rather than just compiling a .pst or pulling
all of the emails into a folder, where only the subject line will be
available.

The best way is to use PSTs despite your aversion to them. Searching works
much better that way and you get to read the entire message.

 

[gb]

The file is to be stored on a local drive, separate from Outlook. The idea,
as mentioned, is to clear the old emails from Outlook, but allow them to
still be searchable, and start Outlook from fresh with the new emails that
come through.

So a .pst file is of no use. The only way it could be used is by importing
it back into Outlook, which is pointless.

gb

|
| > I thought about exporting her emails to Excel, using the from, to,
| > subject and body headers. The idea would be to have a list that's
| > relatively 'easy on the eye' and an easy way of performing searches,
| > should the need arise, rather than just compiling a .pst or pulling
| > all of the emails into a folder, where only the subject line will be
| > available.
|
| The best way is to use PSTs despite your aversion to them. Searching
works
| much better that way and you get to read the entire message.
| --
| Brian Tillman
|

 

[Jaime]

You can use OutlookExtract, www.outlookextract.com to extract the messages
from the PST files and save them to disk. The provided utility,
EmailExplorer.exe, let you view, search and convert the messages easily.
You can save and convert the messages to htm, txt, eml, mht and pdf.

I thought about exporting her emails to Excel, using the from, to, subject
and body headers.

You can export the following parts of an email to Excel, Xml or Html files:

Date
From
Subject
To
CC
Headers
HtmlPart
TextPart

 

[Brian Tillman]

The idea, as mentioned, is to clear the old emails from Outlook, but
allow them to still be searchable, and start Outlook from fresh with
the new emails that come through.

And multiple PSTs allow that. You create a new PST and make it your default
delivery location every time you want to "start fresh".

So a .pst file is of no use. The only way it could be used is by
importing it back into Outlook, which is pointless.

Nonsense. No importing is required.