eml file report with hyperlinks

I have a bunch of individual EML files (emails) that were exported from a mailbox to a windows file share. I need some software or script that can scan the files and create a report I.e.( csv/HTML) to list the sent and received dates within the EML files, and ideally the distribution list (i.e. senders and receivers), and ideally the report should create a hyper-link to the eml file on disc. Is this possible?
LVL 3
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
I don't know of software that does this, but it wouldn't be very difficult to write such a program. If you can't find an existing product that does it, you may want to look in member profiles here at EE for folks with the Hire Me button.

Some questions on the specs:

o  Do you want a graphical user interface, command line interface, or both?

o  Do you want all recipients (TO, CC, BCC) in the same cell or in different cells?

o  If there's a very large number of recipients (e.g., a hundred addresses on the TO line), do you want all of them, or do you want to be able to specify a maximum number?

o  Do you want the display name, the email address, or both? For example, consider the FROM line:

From: Experts Exchange <noreply@experts-exchange.com>

Possibilities for the CSV file are:

(1) Experts Exchange <noreply@experts-exchange.com>
(all in one cell)

(2) Experts Exchange noreply@experts-exchange.com
(all in one cell with angle brackets removed)

(3) Experts Exchange

in one cell and

<noreply@experts-exchange.com>

or

noreply@experts-exchange.com

in another cell.

There are surely other design issues that need to be specified, but those are off the top of my head. Regards, Joe
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pma111Author Commented:
Hi Joe,

Thanks for the reply...

No GUI neccesary, command line/script would be fine

Either same cell or split is fine, whichever is easier

Ideally all - think there is a policy in place on max number of receipients for standard users anyway so shouldnt be an issue

Both would be ideal

Thanks
0
Joe Winograd, Fellow&MVEDeveloperCommented:
> No GUI neccesary, command line/script would be fine

Would a GUI be ok (rather than a CLI)?

> a windows file share

Are all the EML files in a single folder or will the program need to look in subfolders?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

pma111Author Commented:
Gui fine and we can run it many times over different folders and a report per folder would be great
0
Joe Winograd, Fellow&MVEDeveloperCommented:
> the sent and received dates within the EML files

The EML files I looked at (File>Save As>File from Thunderbird 31.0 with POP mail) have a "Delivery-date:" line and a "Date:" line. Those are the dates I would propose to put in the CSV file. I'm not an expert on the internal format of EML files, but web research indicates that dates can be problematic sometimes (and that there are differences in the EML files created from POP and IMAP emails). Look at a few of your EML files in a text editor (Notepad is fine) and let me know if the "Delivery-date:" line and "Date:" lines are there. Thanks, Joe
0
pma111Author Commented:
Will do joe thanks they are basically exported from an exchange pst file
0
Joe Winograd, Fellow&MVEDeveloperCommented:
I just did an Export from Outlook 2013 (IMAP, not Exchange) and the only file type choices are CSV and PST — not EML. I also tried Save As, but the only choices there are TXT, OFT, MSG, HTML, and MHT — again, not EML. How did you export/save EML files from an Outlook PST file?
0
pma111Author Commented:
Its through a 3rd party forensics software called intella 10
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Ah, that explains it!
0
pma111Author Commented:
I presume nothing in this area exists at present?
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Not that I'm aware of, but, as I mentioned earlier in <http:#a40246257>, it wouldn't be very difficult to develop a custom program for it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.