RE: Saving email to Access database?

Subject: RE: Saving email to Access database?
From: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Wed, 16 Apr 2008 14:03:03 -0400

Hi Nancy,

That was me, with a little help from Hans V. at Woody's Lounge. But I
prefer using Access to save to Excel, as follows:

1. Open new MDB file in Access.

Repeat steps 2-7 for each desired Outlook folder:
2. File => Get External Data => Import.
3. File Type Outlook, select desired Outlook folder.
4. Copy imported table.
5. Open new Excel file.
6. Edit => Paste Special => Text.
7. Save and close Excel file.

8. Delete imported Access table and close Access DB.
9. Delete new MDB file.

The Excel columns include the date and time that messages are received,
created, and modified. Of course, they also include the Priority,
Subject, From, CC, To, Message Size, Contents [body], Prefix [RE, FW],

I guess if you want to save it as an Access DB, you could stop after
step 3.

- Dan Goldstein

> -----Original Message-----
> From: Nancy Allison
> Sent: Wednesday, April 16, 2008 1:48 PM
> To: techwr-l -at- lists -dot- techwr-l -dot- com
> Subject: Saving email to Access database?
> Someone on the list mentioned this in passing, and I'm
> curious.
> I've done it myself, by following the quick'n'easy
> directions I readily found online, but some pretty
> crucial information wasn't carried over to the DB.
> Could it have been the date and time of each post?
> Yes, I think so! (And what genius neglected to
> automated that part of the transfer? Who knows!)
> I have a book on Access DBs, and of course I will
> soon find several hours in which to read it with
> devoted attention and meticulously follow its
> every direction.
> But.
> In the meantime, if you could tell me how *you*
> do it . . . I would greatly appreciate it.

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.


Create HTML or Microsoft Word content and convert to Help file formats or
printed documentation. Features include support for Windows Vista & 2007
Microsoft Office, team authoring, plus more.

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity!

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit

To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit for more resources and info.

Saving email to Access database?: From: Nancy Allison

Previous by Author: RE: Version Control - Dates & Versions in File Names
Next by Author: RE: Saving email to Access database?
Previous by Thread: Re: Saving email to Access database?
Next by Thread: RE: Saving email to Access database?

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

Sponsored Ads