Thread: Exporting Outlook email details
2013-04-10, 20:25 #1
- Join Date
- Apr 2008
- Thanked 0 Times in 0 Posts
Exporting Outlook email details
Is there any way to export the details in excel of the outlook emails sent to a particular sender in a specified date and time interval?
Details required are:-
Count of Emails (Only initial emails - No replies and forwarded messages)
Subject line of all the emails
Any help would be highly appreciated
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2013-04-11, 06:46 #2
Exporting would be slightly different depending on what version of outlook you use:
Using Outlook 2010:
go <File>, <Options>, <Advanced>, <Export>
Follow the wizzard steps, selecting your folder.
This will export all the mails in the folder to excell. The following fields are exported:
In excel you can incert a column to the right of the "Subject" column and enter a formula
into cell B2, copy this cell and past it in all the lines in B column (inserted column).
Now you can filter the worksheet to exclude "RE" and "FW" in the B column and include only the required sender in the "FromName" column and your required date range as well.
This is the long way to do, I am sure there is a shorter way, hope somebody can enlighten us.
2013-04-11, 06:47 #3
PS: Should you want to use other mail fields than those listed above, you have to use MS Access and not Excel.