How do I... Export Outlook e-mail messages to Access using VBA?
Exporting Outlook folders and their contents is a simple enough task most of the time. The Import And Export wizard handles the process nicely. But as easy as it is to use, the wizard is a one-time deal. You can't append records to an existing file using the wizard. So if you want to export frequently to the same database, or if you just want to take the process out of user hands, you'll need to use VBA to automate the export.
Access expert Susan Harkins explains how the technique works and provides the code you need to handle the task.
This download is also available as a blog entry.