Solved

Time and Date info to excel

Posted on 2013-11-17
2
326 Views
Last Modified: 2013-11-22
I am trying to run data on when I receive the most emails over the last year. Ultimately I would like to export my emails to an excel spreadsheet that has a column with date and time (in or two columns).

I have the emails in Outlook, an Yahoo inbox and a Gmail inbox (after the forwarding rules). Is there an easy way to do this?

I have tried in outlook to simply copy and past into excel. It either only has the time (if it is the same day) or it only has the date (if it is older than the same day). Doesn't have both. When I export a file in outlook, it doesn't carry the info of when it was received.

Any ideas? Thanks!
0
Comment
Question by:cansevin
2 Comments
 
LVL 22

Accepted Solution

by:
rspahitz earned 250 total points
ID: 39654939
Try pasting "special" to see if it makes a difference.  i.e. right-click and select Paste Special... then try maybe "Text" or some of the other options to see if it pastes what you want.
Also, I've seen that different browsers have different ways to copy so try IE, FireFox, Chrome, etc (whatever you have on your system) and see if you get the expected results.
0
 
LVL 14

Assisted Solution

by:BlueCompute
BlueCompute earned 250 total points
ID: 39654978
You can easily analyze your Gmail usage using Gmail Mater: http://gmailblog.blogspot.co.uk/2012/04/know-your-gmail-stats-using-gmail-meter.html
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now