Exporting Emails to an Access Database

GLT · Joined: 13 Aug 2007 Posts: 2

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.

Archived from group: microsoft>public>outlook>general

Roady [MVP] · Joined: 12 Aug 2007 Posts: 536

Use Import from within Access instead.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

-----

"GLT" wrote in message @microsoft.com...
> 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.
>

GLT · Joined: 13 Aug 2007 Posts: 2

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]" wrote:

> Use Import from within Access instead.
>
> --
> Robert Sparnaaij [MVP-Outlook]
> Coauthor, Configuring Microsoft Outlook 2003
> http://www.howto-outlook.com/
> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>
> http://www.msoutlook.info/
> Real World Questions, Real World Answers
>
> -----
>
> "GLT" wrote in message
> @microsoft.com...
> > 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.
> >

Exporting autocomplete Help in Outlook 2007 says that to transfer autocomplete items from one computer to another simply copy the username.nk2 file in \Documents and to the same loation in the new computer. I can't

help with exporting a distribution list Has anyone ever been able to successfully export a distribution list only & not the whole address book?

open an email via a database link I am using 2003. I want to be able to capture metadata about emails received in a resource account. I can do this via a linked table in Access to the Inbox from Outlook. When the users are looking to see (via the Access database) what ema

Reset Database? (Start from Scratch) Hi, I haven't been able to successfully search this question, so I suspect I'm probably not wording the question correctly. My situation is that I am working with Outlook 2003 and Business Contact Manager. I am migrating from Outlook Express and ACT! vers

Exporting from Outlook to Excel Folder Problem I am trying to get a code for exporting data from an custom outlook form to default to export to a certain folder. I keep getting the message " The Selected Folder Do Not Contain Contacts" but I know for a fact I have 82 contacts in the folder Public Fold