RE: Minor problem when using Access to back up Outlook

Subject: RE: Minor problem when using Access to back up Outlook
From: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Tue, 8 Apr 2008 15:42:11 -0400

Hans V. from Woody's Lounge posted the correct solution:

"The databases aren't created when you export to Excel, but when you
select File | Open in Access and specify Outlook. Each time you do this,
Access will create a new database.
"If you want to import into an existing database, use File | Get
External Data | Import..., or perhaps even better, File | Get External
Data | Link Tables...
"The latter will let you create a table in Access that is dynamically
linked to your Outlook folder. Each time you open the linked table, or
export it, it will use up-to-date information from Outlook."

> -----Original Message-----
> From: Dan Goldstein
> Sent: Friday, April 04, 2008 11:20 AM
> To: techwr-l -at- lists -dot- techwr-l -dot- com
> Subject: Minor problem when using Access to back up Outlook
>
> I back up my Outlook folders as Excel spreadsheets. The
> easiest method I've found is:
>
> 1. Open the Outlook folder as a table in Access.
> 2. Copy the Access table and paste as plain text into the spreadsheet.
> 3. Delete the table from the Access DB.
>
> Outlook's native export-to-Excel function doesn't export all
> of the information I need - this method does, and it's faster, too.
>
> The only drawback to this method is that it creates two new
> Access MDB files each time (one in C:\Program Files\Common
> Files\System\MSMAPI\1033, and one in My Documents). No, it
> doesn't take long to delete them... But still, isn't there a
> way to avoid creating the two new MDB files, given that I
> don't perform any Save function in Access?
>
> TIA,
>
> Dan
>

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.


Previous by Author: Minor problem when using Access to back up Outlook
Next by Author: RE: WORD: Finding all instances of Title Case
Previous by Thread: Minor problem when using Access to back up Outlook
Next by Thread: amusing? docs story


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


Sponsored Ads