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.
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.
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?
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
- 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. http://www.doctohelp.com/
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-