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
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.