exporting outlook to access

[carlj]

I work for a Federal Government Agency in Washington, DC.

MS Outlook is our email program. It allows you to export a mail folder
to MS Access by following the following steps:

Select folder | File | Import and Export . . . | Export to file |
Microsoft Access | Select folder to export from: | Save exported file
as: [or Browse...] | The following actions will be performed: | Finish.

It works pretty well, exporting lots of
information/fields that you (I) didn't even know was in the messages.

Unfortunately, it does not export certain important information, such as
the date and time. In my job, that is a very important piece of
information in the email folders with which I am working.

Even if I apply the filters, date and/or time do/does not appear as an
option.

Outlook help is of no help in this area.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors. So, of
course, I can get no answer. They will not contact MS to find out,
because they say they cannot pay the cost.

Can someone in either or both of these newsgroups tell me how to export
an Outlook email folder and its comments to a MS Access file to include
the date and time?

Thank you in advance.

Replies to group only, please. No reply to above address. It will
bounce back.

 

[Sue Mosher [MVP-Outlook]]

You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools

Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm .
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

['69 Camaro]

Hi, Carl.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors.

Jobs that went to the lowest bidders, huh? ;-) Busineses and government
agencies alike think that this is the ticket to saving money, yet they
wonder why they are constantly bogged down with show-stoppers and
time-consuming work-arounds for what should be quick and simple tasks with
their computers.

The short answer is that the Outlook Import and Export Wizard is incapable
of exporting the date/time fields to Access. However, that doesn't mean
that Access can't import the records into a table for you.

First, ensure that Outlook is the default E-mail client. If it isn't
already, change the setting, close Outlook and then reopen it. You'll be
prompted whether you want it to become your default E-mail client. Select
"Yes," wait for Outlook to finish reconfiguring, then close Outlook.

Open Access and create a new database file. Import the table into Access
using Access's Import Wizard (File -> Get External Data -> Import... menu)
and select Outlook( ) in the "Files of type" combo box. If the Outlook
Translator hasn't already been installed on your computer, it will be
installed at this time.

Select the folder you'd like to import into Access and follow the prompts.
One cannot import all of the fields into the table without some
manipulation, but the dates "Received," "Created," and "Modified" for each
E-mail will be imported, which is probably what you were looking for.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

I work for a Federal Government Agency in Washington, DC.

MS Outlook is our email program. It allows you to export a mail folder to
MS Access by following the following steps:

Select folder | File | Import and Export . . . | Export to file |
Microsoft Access | Select folder to export from: | Save exported file
as: [or Browse...] | The following actions will be performed: | Finish.

It works pretty well, exporting lots of
information/fields that you (I) didn't even know was in the messages.

Unfortunately, it does not export certain important information, such as
the date and time. In my job, that is a very important piece of
information in the email folders with which I am working.

Even if I apply the filters, date and/or time do/does not appear as an
option.

Outlook help is of no help in this area.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors. So, of
course, I can get no answer. They will not contact MS to find out,
because they say they cannot pay the cost.

Can someone in either or both of these newsgroups tell me how to export an
Outlook email folder and its comments to a MS Access file to include the
date and time?

Thank you in advance.

Replies to group only, please. No reply to above address. It will bounce
back.

 

[carlj]

Thanks.

I'm forwarding this to myself at work, and will give it a try. The
Outlook translater might be a problem. They have security so tight that
no one can install or update anything. But I'm sure I can get the
helpdesk to come up and do it for me.

Hi, Carl.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors.

Jobs that went to the lowest bidders, huh? ;-) Busineses and government
agencies alike think that this is the ticket to saving money, yet they
wonder why they are constantly bogged down with show-stoppers and
time-consuming work-arounds for what should be quick and simple tasks with
their computers.

The short answer is that the Outlook Import and Export Wizard is incapable
of exporting the date/time fields to Access. However, that doesn't mean
that Access can't import the records into a table for you.

First, ensure that Outlook is the default E-mail client. If it isn't
already, change the setting, close Outlook and then reopen it. You'll be
prompted whether you want it to become your default E-mail client. Select
"Yes," wait for Outlook to finish reconfiguring, then close Outlook.

Open Access and create a new database file. Import the table into Access
using Access's Import Wizard (File -> Get External Data -> Import... menu)
and select Outlook( ) in the "Files of type" combo box. If the Outlook
Translator hasn't already been installed on your computer, it will be
installed at this time.

Select the folder you'd like to import into Access and follow the prompts.
One cannot import all of the fields into the table without some
manipulation, but the dates "Received," "Created," and "Modified" for each
E-mail will be imported, which is probably what you were looking for.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

I work for a Federal Government Agency in Washington, DC.

MS Outlook is our email program. It allows you to export a mail folder to
MS Access by following the following steps:

Select folder | File | Import and Export . . . | Export to file |
Microsoft Access | Select folder to export from: | Save exported file
as: [or Browse...] | The following actions will be performed: | Finish.

It works pretty well, exporting lots of
information/fields that you (I) didn't even know was in the messages.

Unfortunately, it does not export certain important information, such as
the date and time. In my job, that is a very important piece of
information in the email folders with which I am working.

Even if I apply the filters, date and/or time do/does not appear as an
option.

Outlook help is of no help in this area.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors. So, of
course, I can get no answer. They will not contact MS to find out,
because they say they cannot pay the cost.

Can someone in either or both of these newsgroups tell me how to export an
Outlook email folder and its comments to a MS Access file to include the
date and time?

Thank you in advance.

Replies to group only, please. No reply to above address. It will bounce
back.

 

[carlj]

Thanks.

I'm forwarding this one too to myself at work, and will see what I can do.

 

[carlj]

Thank you both. I both linking and importing gave me the fields I
wanted. They don't give the content of the messages, though, but in
this case I had over 5,900 exactly the same -- all sent from a single
webpage.

Thanks again.

 

[carlj]

Thank you both. I both linking and importing gave me the fields I
wanted. They don't give the content of the messages, though, but in
this case I had over 5,900 exactly the same -- all sent from a single
webpage.

Thanks again.

Hi, Carl.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors.

Jobs that went to the lowest bidders, huh? ;-) Busineses and government
agencies alike think that this is the ticket to saving money, yet they
wonder why they are constantly bogged down with show-stoppers and
time-consuming work-arounds for what should be quick and simple tasks with
their computers.

The short answer is that the Outlook Import and Export Wizard is incapable
of exporting the date/time fields to Access. However, that doesn't mean
that Access can't import the records into a table for you.

First, ensure that Outlook is the default E-mail client. If it isn't
already, change the setting, close Outlook and then reopen it. You'll be
prompted whether you want it to become your default E-mail client. Select
"Yes," wait for Outlook to finish reconfiguring, then close Outlook.

Open Access and create a new database file. Import the table into Access
using Access's Import Wizard (File -> Get External Data -> Import... menu)
and select Outlook( ) in the "Files of type" combo box. If the Outlook
Translator hasn't already been installed on your computer, it will be
installed at this time.

Select the folder you'd like to import into Access and follow the prompts.
One cannot import all of the fields into the table without some
manipulation, but the dates "Received," "Created," and "Modified" for each
E-mail will be imported, which is probably what you were looking for.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

I work for a Federal Government Agency in Washington, DC.

MS Outlook is our email program. It allows you to export a mail folder to
MS Access by following the following steps:

Select folder | File | Import and Export . . . | Export to file |
Microsoft Access | Select folder to export from: | Save exported file
as: [or Browse...] | The following actions will be performed: | Finish.

It works pretty well, exporting lots of
information/fields that you (I) didn't even know was in the messages.

Unfortunately, it does not export certain important information, such as
the date and time. In my job, that is a very important piece of
information in the email folders with which I am working.

Even if I apply the filters, date and/or time do/does not appear as an
option.

Outlook help is of no help in this area.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors. So, of
course, I can get no answer. They will not contact MS to find out,
because they say they cannot pay the cost.

Can someone in either or both of these newsgroups tell me how to export an
Outlook email folder and its comments to a MS Access file to include the
date and time?

Thank you in advance.

Replies to group only, please. No reply to above address. It will bounce
back.

 

['69 Camaro]

Hi, Carl.

You're welcome. The content of each message is in the "Contents" field.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

Thank you both. I both linking and importing gave me the fields I wanted.
They don't give the content of the messages, though, but in this case I
had over 5,900 exactly the same -- all sent from a single webpage.

Thanks again.

Hi, Carl.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors.

Jobs that went to the lowest bidders, huh? ;-) Busineses and government
agencies alike think that this is the ticket to saving money, yet they
wonder why they are constantly bogged down with show-stoppers and
time-consuming work-arounds for what should be quick and simple tasks
with their computers.

The short answer is that the Outlook Import and Export Wizard is
incapable of exporting the date/time fields to Access. However, that
doesn't mean that Access can't import the records into a table for you.

First, ensure that Outlook is the default E-mail client. If it isn't
already, change the setting, close Outlook and then reopen it. You'll be
prompted whether you want it to become your default E-mail client.
Select "Yes," wait for Outlook to finish reconfiguring, then close
Outlook.

Open Access and create a new database file. Import the table into Access
using Access's Import Wizard (File -> Get External Data -> Import...
menu) and select Outlook( ) in the "Files of type" combo box. If the
Outlook Translator hasn't already been installed on your computer, it
will be installed at this time.

Select the folder you'd like to import into Access and follow the
prompts. One cannot import all of the fields into the table without some
manipulation, but the dates "Received," "Created," and "Modified" for
each E-mail will be imported, which is probably what you were looking
for.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

I work for a Federal Government Agency in Washington, DC.

MS Outlook is our email program. It allows you to export a mail folder
to MS Access by following the following steps:

Select folder | File | Import and Export . . . | Export to file |
Microsoft Access | Select folder to export from: | Save exported file
as: [or Browse...] | The following actions will be performed: | Finish.

It works pretty well, exporting lots of
information/fields that you (I) didn't even know was in the messages.

Unfortunately, it does not export certain important information, such as
the date and time. In my job, that is a very important piece of
information in the email folders with which I am working.

Even if I apply the filters, date and/or time do/does not appear as an
option.

Outlook help is of no help in this area.

No one at my Agency seems to know how to do this -- not the help desk,
not the Agency's CIO employees and not the various contractors. So, of
course, I can get no answer. They will not contact MS to find out,
because they say they cannot pay the cost.

Can someone in either or both of these newsgroups tell me how to export
an Outlook email folder and its comments to a MS Access file to include
the date and time?

Thank you in advance.

Replies to group only, please. No reply to above address. It will
bounce back.