The No-Export 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 formatting. Otherwise, you'll paste Outlook items, not rows of text.

1. Switch to a list view, if not already using a list view.
2. Right click on the row of field names and choose Field Chooser.
3. Drag the fields you need to copy to the row of field names.
4. Drag the fields you don't need off of the row of field names.
5. Begin by selecting the text. Hold Ctrl as you scroll down or use the PgDown or End key to select the items faster.
6. Press Ctrl+C to copy the selection.
7. Go to Excel and paste (Ctrl+V)

Use Format Columns to change the format of the date or number fields. To open the format columns dialog, right click on the row of field names and choose View Settings, Format Columns

You can paste into any application that accepts paste, however if you paste in Word, you need to use Paste Special, As Text.

Video Tutorial

Tips:

• Disable in-cell editing - its easier to select the rows.
• Right click on the row of field names and choose Customize, then reset to reset the view.
• Remember, you need to use Paste Special, As Text when pasting into some applications.