TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
"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!
> -----Original Message-----
> From: Dan Goldstein
> Sent: Tuesday, November 01, 2005 9:57 AM
> To: TECHWR-L
> 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?
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: http://www.webworks.com/techwr-l
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 http://www.techwr-l.com/techwhirl/ for more resources and info.