Search OutlookPower's 9,596 Outlook and all-things-email article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
THIS WEEK'S POWERTIP
Powerful data exporting from Outlook
By David Gewirtz

I've owed Michal Bednarz an article in OutlookPower for months. Michal's a Microsoft Outlook MVP and back in April, he wrote us with a solution to one of our reader questions. In an Outlook Q&A article, Gavin Meyers asked:

Hope somebody can assist me. I need to extract the following information: Date, Time, Senders name, and Subject. These appear on emails being sent to a support mail address into Excel. Have tried the export function in Outlook but it does not give the date and time as an option. Looking forward to hearing from somebody. God Bless.

We didn't have a good answer, but Michal did. He wrote us to tell us that:

Some time ago I developed a free program for exporting Outlook items to CSV files -- "C2OutlookExport". It allows to export more data fields than standard Outlook export, also date and time fields for emails and also custom user-defined properties (UDP). The program is started by simply clicking its icon in Outlook standard toolbar (it is developed as a client extension). The program works under Windows Vista and Outlook 2007 (earlier versions of Windows and Outlook are also supported, of course).
After I read Your article, I prepared English UI for the program and wrote a short description in English.

A few weeks later, in May, he wrote to tell us that C2OutlookExport now can export data from all types of folders.

Unfortunately, we couldn't publish Michal's letter because right after Gavin wrote us the letter asking for help, we began our special investigation into White House email and that dominated our editorial coverage through the summer. Over the last few weeks, we've been going through our backlog of articles and making sure we got you more hands-on Outlook coverage.

We are particularly grateful to Michal for both listening to our request for help and taking the extra time to customize his program for English speakers and all types of folders. You can download his file from Code Two.

On the same subject, I've also owed Jules Hernandez a special shoutout as well. Jules wrote us to say:

I just read OutlookPower's latest issue's Q&A, specifically the question re exporting email messages to Excel. I had this same requirement before. You may want to refer your reader to http://www.jameswade.net/articles/outlookexport.html, which contains VBA code for exactly doing this same thing.
On another note, do you need writers for your magazine? I'm a freelance programmer and technical writer.

Jules, we always welcome new writers! Please feel free to visit http://www.authorpower.com for writer guidelines. Any of you out there who want to write are also welcome to visit AuthorPower, write something, and get a little bit famous.

By the way, the link Jules provided is no longer available, but the information is. We're linking to the Internet Archive, and they have a cached page with the code.

Reaching out across the pond
Since one of the reasons I had to push back publishing the tips from these helpful readers had to do with our coverage of America's White House and the email problems there, I think it's particularly appropriate to point out that Michal's from Poland and Jules is from the Philippines.

Maybe if we focus a bit more on helping each other and a bit less on crazy political issues, the world can be a more friendly place. Certainly Michal and Jules are setting examples of helping out that the rest of us might want to consider following.

Product availability and resources
Read "Why won't my email download automatically?".

Download C2OutlookExport (this is a .exe file).

Visit Code Two.

Get VBA export code.

Read our writer guidelines.

David Gewirtz is the author of How To Save Jobs and Where Have All The Emails Gone? For more than 20 years, he has analyzed current, historical, and emerging issues relating to technology, competitiveness, and policy. David is the Editor-in-Chief of the ZATZ magazines, is the Cyberterrorism Advisor for the International Association for Counterterrorism and Security Professionals, and is a member of the instructional faculty at the University of California, Berkeley extension. He can be reached at david@zatz.com and you can follow him at http://www.twitter.com/DavidGewirtz.


Other articles you might like
Home > Using Outlook > Contacts & Address Book (27 articles)
   Printing notes with contacts in Outlook 2007
   A very crude way to print Outlook contact pictures
   How to separate email accounts and still manage them
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent OutlookPower Articles
The strange case of Outlook losing notes and requiring passwords
Why I'm choosing to stick with Outlook 2007
Three ways to avoid email distraction and take back control of your time
Twenty ways to use email to commit career suicide
The two most motivational words in the English language
Diagnosing corrupted email headers
Email offenders
OutlookPower News Center
New Filing Assistant from Allometa
Dropbox bridges gaps in Microsoft's mobile sync
SmartBear Software Releases AQtime 7.0 Pro
6 Super Wi-Fi Tools for Windows
Microsoft Revives Windows 7 Family Pack Discount
Microsoft releases FixIt for critical flaw in 100 apps
M-Files Cloud Vault Easy, Hosted Document Management
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Smartphone smarts for a mobile world
David Gewirtz Online: CNN commentary and analysis
DominoPower: It's time for Lotus to double-down on Linux and open source
-- Advertisement --

ONLINE GROUP CALENDAR - FOR UP TO 100 OF YOUR CLOSEST FRIENDS
Stay organized and in control with 24/7 access to all of your important events, projects and files --whether you're at work, at home or on the road.

You can share your calendar, projects and files so everyone in your office is up to date. Plus, search your entire group to find times when everyone is available to meet, manage company resources and much more.

Organize your entire team for as low as $9.95 per year (and yes, that's where the decimal place is supposed to be!)

Tap here to get started right away.

-- Advertisement --

Printing emails and attachments has never been simpler
When it comes to printing emails or attachments, you can be confident that our Auto-Print add-in can do what Outlook lacks - print the emails and/or attachments as soon as they arrive.

Discover this professional tool today.
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Outlook is a trademark of Microsoft Corporation.
Editor's Login