exporting emails including headers or date

  • Thread starter Thread starter nfhm2k
  • Start date Start date
N

nfhm2k

I have tried using the normal methods to export emails from Microsoft
Outlook 2003 into a csv file.

However it DOES NOT include the date or the header information.

How can I extract my emails into a basic format such as cvs that
includes the date or the header information.

Anyone got any ideas on this?

Thanks.
 
I have tried using the normal methods to export emails from Microsoft
Outlook 2003 into a csv file.

However it DOES NOT include the date or the header information.

How can I extract my emails into a basic format such as cvs that
includes the date or the header information.
Click to expand...

May I ask what the purpose of the export is?
 
The purpose doesn't matter. However basically it is so I can export
them from outlook, then import them into a MySQL database for
processing.

Anyway, I found an overall solution...

Using my "elite google skillz" I managed to locate something useful via
http://www.outlookcode.com/d/customimport.htm

In particular
http://www.topxml.com/snippetcentral/main.asp?view=viewsnippet&lang=xml&id=v20020414223234

Which allowed me to export emails (including the date) using VBA/Macros
to XML, which I could then open in excel and export to CVS format,
which I could then import into the MySQL database.

Using the script above I simply loaded the script into
"ThisOutlookSession" (You need to use Tools | References to add a
reference to the Microsoft XML library.), save and close. Then hit
Alt+F8 and choose the ExportEmailToXml.

Thanks to Sue at http://www.outlookcode.com/ for her help.

I hope everyone finds this as useful as I did.
 
Back
Top