Solved

Time and Date info to excel

Posted on 2013-11-17
2
312 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
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

772 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

10 Experts available now in Live!

Get 1:1 Help Now