FW: Saving email to Access database?

Subject: FW: Saving email to Access database?
From: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Tue, 17 Aug 2010 15:24:22 -0400

This old method works great in Office 2010 -- much faster, and that's
not just the RAM talking. The only change for Access 2010 is in step 2:

2. External Data => More => Outlook Folder.

-----Original Message-----
From: Dan Goldstein
Sent: Wednesday, April 16, 2008 2:03 PM
To: techwr-l -at- lists -dot- techwr-l -dot- com
Subject: RE: Saving email to Access database?

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...

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.


Gain access to everything you need to create and publish information
through multiple channels. Your choice of authoring (and import)
formats with virtually any output. Try Doc-To-Help free for 30-days.

LavaCon 2010 in San Diego Sept 29 - Oct 2 is now open for registration.
Use referral code TECHWR-L for $50 off conference tuition!
See program at: http://lavacon.org/

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 http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com

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
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:

Previous by Author: RE: Windows 7 security quirk, or...?
Next by Author: RE: Font question
Previous by Thread: Re: keyboard shortcuts for new macros
Next by Thread: ReplaceText Deleted Fonts!

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

Sponsored Ads