Export Outlook 2003 emails with Date and Address
Posted on 2007-08-10
I'm looking for some way to export emails from Outlook 2003
1. If i use Outlook's export feature, it will export the email addresses, but not the date
2. if I link to Outlook from Access and import, I get the dates, but the email addresses don't always show up: instead of "firstname.lastname@example.org" it will just export "John Doe". I need the address
I also need the email body. I've looked at the EML files which seem to have all i need, but I don't know how to parse them.
the ideal solution would also create one-to-many tables for the To: CC: addresses (i.e. if an email was sent to multiple ppl). ideally it would also be automated so i wouldn't have to do any dragging / dropping. this may be a lot to ask though so if i dont get a solution that answers all of this, it might work.