Exporting emails from an Outlook folder to an external file is perfect,
except for the date field which is missing from the export.
Is there a way to get the date into the export? or is there a better
approach to getting this information from Outlook to Access?
Thanks
tc
In Access, File>Get External Data>Import>File Type=Outlook()
This brings up the Exchange/Outlook Import Wizard
It browses your entire Outlook Folder structure
Pick a folder and it gets Imported into an Access table
You get everything as separate fields in each record for each email
Recieved (date/time)
From
To
Cc/Bcc
Subject
Body (memo field)
Message size
Whether it had attachments or not
and about 20 other cool fields.
"Tony Cannizzo" <tcan...@bellsouth.net> wrote in message
news:dWsli.52037$Fo1....@bignews7.bellsouth.net...
I guess, you got my point :-)
--
Regards,
Amit Bhandari
http://amitbhandari.co.nr
"Tony Cannizzo" <tcan...@bellsouth.net> wrote in message
news:blrmi.8060$O9....@bignews6.bellsouth.net...