RE: Exporting Outlook folders

Subject: RE: Exporting Outlook folders
From: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Wed, 2 Nov 2005 11:00:46 -0500

Simon Kravis suggested the following workaround on Google's
microsoft.public.outlook list (

"A clunky way is to export to Excel, then add a column for Received
Date, select all messages in the mail folder (ordered by date), copy to
clipboard and paste into Excel. The Received Date will then be present
as a column whose rows match up with the exported data. However, the
date format as pasted (e.g. Fri 29/1/2004 1:00 PM) is not interpreted by
Excel as a date. To make it interpreted as a date, remove the 1st 4
characters with the Excel Mid() function and use the excel Value
function to convert to Excel date format i.e. Value(Mid(A1,4,30)). Once
the column is converted to date format it can be copied into the
Received Date column of the exported data, or pasted into a new Access
field if the mail data has been exported there."

Good workaround. Thanks, Simon, wherever you are!

-- Dan

> -----Original Message-----
> From: Dan Goldstein
> Sent: Tuesday, November 01, 2005 9:57 AM
> Subject: Exporting Outlook folders
> Exporting Outlook 2003 folders (under Win XP Pro) to
> tab-separated TXT files. Does anyone know how to define the
> columns that are exported?
> Right now I get the following columns: Subject, Body, From
> (Name, Address, and Type), To, CC, BCC, Billing Information,
> Categories, Importance, Mileage, and Sensitivity.
> The exported columns don't match the columns selected for
> display in Outlook (View | Arrange By | Current View |
> Customize Current View...).
> What I really want is to include the Date and Time columns. Any ideas?
> Thanks,
> Dan

This message contains confidential information intended only for the use of the addressee(s). If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing, copying, electronic storing or the taking of any action in reliance on the contents of this message is strictly prohibited. If you have received this message by mistake, please notify us, by replying to the sender, and delete the original message immediately thereafter. Thank you.


Try WebWorks ePublisher Pro for Word today! Smooth migration of legacy
RoboHelp content into your new Help systems. EContent Magazine Decision-
maker review (October 2005) is here:

Doc-To-Help 2005 converts RoboHelp files with one click. Author with Word or any HTML editor. Visit our site to see a conversion demo movie and learn more.

You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- techwr-l -dot- com
Send administrative questions to lisa -at- techwr-l -dot- com -dot- Visit for more resources and info.

Previous by Author: RE: Implementing a glossary
Next by Author: RE: Slashes in abbreviations
Previous by Thread: Exporting Outlook folders
Next by Thread: Online Help Recommendations

What this post helpful? Share it with friends and colleagues:

Sponsored Ads