Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - General Queries (http://www.outlookbanter.com/outlook-general-queries/)
-   -   Exporting emails (http://www.outlookbanter.com/outlook-general-queries/52288-exporting-emails.html)

Tony Cannizzo July 11th 07 07:09 PM

Exporting emails
 
Is there anyway to get Outlook to include the date/time fields along with
the exported emails?

Thanks.
tc



Gordon July 11th 07 07:20 PM

Exporting emails
 
"Tony Cannizzo" wrote in message
.. .
Is there anyway to get Outlook to include the date/time fields along with
the exported emails?

Thanks.
tc




Doesn't look like it.....



Tony Cannizzo July 12th 07 04:48 PM

Exporting emails
 
Is it just me, or does that seem odd to others?

I mean, what would the value be to exporting emails, with all of the other
fields, some more esoteric than others, conveniently provided, except for
date/time sent/recieved.

Is there any kind of workaround?

"Gordon" wrote in message
...
"Tony Cannizzo" wrote in message
.. .
Is there anyway to get Outlook to include the date/time fields along with
the exported emails?

Thanks.
tc




Doesn't look like it.....




Gordon July 12th 07 05:24 PM

Exporting emails
 
"Tony Cannizzo" wrote in message
.. .
Is it just me, or does that seem odd to others?


It does seem odd - but then I've never had reason to export emails.... :-)



Tony Cannizzo July 12th 07 05:34 PM

Exporting emails
 
Well, let me explain what I am trying to do. Maybe there is a better
solution.

I am trying to integrate Outlook 2003 and Access 2003.
My Access database is my CRM. I would like to incorporate my correspondence
and store individual emails as separate Notes records that are associated
with my Individuals.

Up til now, I have been manually opening each email and copy/paste the text
from the email into a form on Access. Painful process and therefore I have
to bounce back and forth between Outlook and Access.

So, by exporting the emails into an Access database works beautifully.
Except for the Date Sent field which is inconspicuously absent.

Is there another approach?

Thanks
tc

"Gordon" wrote in message
...
"Tony Cannizzo" wrote in message
.. .
Is it just me, or does that seem odd to others?


It does seem odd - but then I've never had reason to export emails.... :-)




Gordon July 12th 07 06:07 PM

Exporting emails
 
"Tony Cannizzo" wrote in message
.. .
Well, let me explain what I am trying to do. Maybe there is a better
solution.

I am trying to integrate Outlook 2003 and Access 2003.
My Access database is my CRM. I would like to incorporate my
correspondence and store individual emails as separate Notes records that
are associated with my Individuals.

Up til now, I have been manually opening each email and copy/paste the
text from the email into a form on Access. Painful process and therefore I
have to bounce back and forth between Outlook and Access.

So, by exporting the emails into an Access database works beautifully.
Except for the Date Sent field which is inconspicuously absent.

Is there another approach?



Sorry, this is beyond my expertise. Presumably, as the date/time field is
NOT offered as a default export field, there may be a chance of getting at
it programmatically - might be worth asking in the Outlook programming
group....



Tony Cannizzo July 15th 07 05:49 PM

Exporting emails
 
Thought I would post this for anyone's future reference

In Access, FileGet External DataImportFile 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.

"Gordon" wrote in message
...
"Tony Cannizzo" wrote in message
.. .
Well, let me explain what I am trying to do. Maybe there is a better
solution.

I am trying to integrate Outlook 2003 and Access 2003.
My Access database is my CRM. I would like to incorporate my
correspondence and store individual emails as separate Notes records that
are associated with my Individuals.

Up til now, I have been manually opening each email and copy/paste the
text from the email into a form on Access. Painful process and therefore
I have to bounce back and forth between Outlook and Access.

So, by exporting the emails into an Access database works beautifully.
Except for the Date Sent field which is inconspicuously absent.

Is there another approach?



Sorry, this is beyond my expertise. Presumably, as the date/time field is
NOT offered as a default export field, there may be a chance of getting at
it programmatically - might be worth asking in the Outlook programming
group....





All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com