Tip 254: Copying (and Pasting) Lists

Do you need a list of Outlook items in another format? You can use File, Export, or you can create a custom view, showing just the fields and items you need. Select one item, press Ctrl+A to select all, then Ctrl+C to copy and paste them into another program. You may need to use Paste Special, As Text or first paste into Notepad and copy when pasting into an OLE capable program, otherwise you'll paste the Outlook items as objects, not text.

If you need to paste Outlook data often, you can remove the OLE tags and convert the copy to plain text using PureText (PureText by Steve Miller).

Published May 13, 2005. Last updated on August 17, 2011.

Related posts:

When you need to copy a table of data, such as names and phone numbers, create a new view that uses just the fields you need. SeleTip 154: Copy Outlook Data Outlook 2003 includes a junk e-mail filter and a safe list which allows all entries in your address book to bypass the junk filterTip 21: Using Safe Lists Did you know you can create new Outlook items by selecting text and dragging it to a folder? A new item form opens with the selectTip 129: Create New Items From Old Tip 181: Copy Appointments