The no-import way to use Outlook data in Excel

This is one of my favorite Outlook features and it works with all versions of Outlook and with all Outlook folders. It also works with any application that accepts paste, not just Excel.

Create a view that contains the fields you need, then copy the rows and paste into any application that accepts paste. Some applications, like Word, require Paste Special, As Text to remove OLE.  Otherwise, you'll paste Outlook items, not rows of text.

1. Begin by selecting the text. Hold Ctrl as you scroll down or use the PgDown or End key to select the items faster.
2. Press Ctrl+C to copy the select.
3. Go to Excel and paste (Ctrl+V)

Right click on the row of field names and choose Field Chooser to add fields to the view. Just drag then from Field chooser to the field row. Drag off and drop any fields you don't need.

Use Format columns to change the format of the date or number fields. 

More Information