RE: Saving email to Access database?

["Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>]

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],
etc.

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.
http://www.DocToHelp.com/TechwrlList

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

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