Export Date From Outlook 2003

  • Thread starter Thread starter Sam
  • Start date Start date
You can IMPORT data from Outlook into Access quite easily. GO To File>Get
External Data>Import and select 'Files of Type-Outlook'. You should see a
list of mail folders from the Microsoft Exchange server. Click the + next to
each folder to select individual folders. It seems that you have to do each
folder individually.
As well, if you have a Personal Folder (.pst) on a shared drive, the import
tool cannot access it. I found that by moving the .pst to my hard drive I was
able to access it and import from the individual folders.
You'd think there would be a better tool , though, as it seems to be a
common requirement, judging from this discussion group.
 
I should clarify - Excel does not appear to be able to import the same way
from Outlook. I would import into Access, then if necessary export the
resulting sheet to Excel. However, you can do more with the data in Access
anyway, so you may prefer to just use it instead.
 
Back
Top