![]() |
Exporting emails
Is there anyway to get Outlook to include the date/time fields along with
the exported emails? Thanks. tc |
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..... |
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..... |
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.... :-) |
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.... :-) |
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.... |
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