[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Time and Date info to excel

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
cansevin
Asked:
cansevin
2 Solutions
 
rspahitzCommented:
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
 
BlueComputeCommented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now