Exporting Emails to an Access Database

[GLT]

Hi,

I am exporting emails to an access database.

All works fine, but I would like to export the Email Received Date / Time
into the database as well.

This field does not show up in the export wizard - can anyone advise how to
achieve this?

Cheers,
GLT.

 

[Roady [MVP]]

Use Import from within Access instead.

 

[GLT]

Hi Roady,

Thanks for your reply.

I have changed this to access, and manually using the export wizard imports
the date fine.

I am trying to automate this process via VBA, and just like exporting in
Outlook, the received feild does not seem to exist.

Can someone PLEASE explain why this is the case? Why is it so difficult to
get the date feild imported / exported out of Outlook?

 

[Roady [MVP]]

What exactly are you trying to achieve?
Note that Access can hold an active link to Outlook to keep the database
up-to-date.

 

[GLT]

Hi Roady,

I am just importing a bunch of emails into access every day.

I tried using the export feature of outlook, but the 'Received date' does
not export.

So then I switched to Importing into Access, but want to do this via VBA
code, not be the wizard.

As part of the import process, I required the received date value for each
message.

I have since found the feild name:

ReceivedDate

All works fine now. The only thing I could not get working, was (in VBA)
refering to a folder that is created outside (or above the inbox folder in
the Outlook tree view) of the Inbox folder. I since moved the folder
'underneath' the Inbox and it worked.

I am also interested in the Active Link between access and Outlook and Access.

Can you provide more details?

Cheers,
GLT.