• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Outlook Tips

Learning Microsoft Outlook One Tip At A Time

Diane Poremsky [Outlook MVP]

  • Home
  • Tips Archive
  • How to...
  • Beginner
  • Outlook.com

Use Custom View Data in Another Program

Ok. So you have the data in Outlook but need it in another program. What is the easiest way to do it? You could use File, Export and export it to one of a number of formats, which works well when you need most or all of the fields in the other program. But say you just need the name and phone number in a list or even just the email address?

In this case, just create a custom view, select one item, press Ctrl+A to Select All and Ctrl+C to Copy, then Paste it into the other program.

See Create a Custom View if you aren't sure where to begin.

For this example, I'll create a custom view in Contacts that contains only the full name and email address fields so that we can create a distribution list, as explained in Tip 201, Add Addresses to a Distribution List. You can use this method to copy data from any fields in any Outlook folder type.

Open the Define views dialogs, as explained in Create a Custom View and select any table view, then click the Copy button. Enter a name for the view – for this example, it will be named "Email only". Click OK and the Customize view dialog opens.

  1. Select the Fields button.
  2. Select the Full Name field on the right.
  3. Click the Move Up button to move the Full Name field to the top of the list.
  4. Select the other fields on the right side (hold control and move the arrow keys to select all).
  5. Click < – Remove to remove the other fields from the view.
  6. Click on Frequently Used fields in the drop down on the top left.
  7. Select Email fields.
  8. Add – > the Email field to the view
  9. Click Ok.

Show fields dialog

Note that you really only need the email address, but it's nice to have the full name in the DL and it doesn't affect how this works. In fact, you could just use the full name field when using this method to create a DL and let Outlook resolve the address. It also doesn't matter which field is listed first, Outlook will resolve the names and addresses correctly. When you are pasting the data in another program, you'll probably want the fields in a specific order. Use the Move Up and Move Down buttons to adjust the order.

To make it easier to copy, we're going to disable in-cell editing too.

  1. Click on Other Settings button
  2. Near the top right is an option In-cell editing.
  3. Click it to remove the check box
  4. Click Ok.

Other Setting dialog

If you want to filter by category or other criteria, click the Filter button and create a filter for your view. When you are finished, click Ok, then Apply View. You now have a view that contains just your contact's full name and email address.

Press Ctrl+A to select all. (Click on one address to select it, if it's not already selected), then Ctrl+C to copy. Now you can paste it anywhere as a tab delimited list, like this:

Custom view of dataFull Name E-mail
Billy Barker bbarker@here.com
Jenny Jones jjones@jones.com
Mark Jackson mj@jackson.com
Mary Smith msmith@there.com

Create a Distribution List

To use this list in a distribution list form as described in Tip 201, Add Addresses to a Distribution List, press Ctrl+Shift+L to open a new DL form.

  1. Click the Select Members button.
  2. Paste (Ctrl+V or right click, paste) the list into the Members field.
  3. Press Ok.
  4. Because the list includes the field names, the Check Names dialog opens.
  5. distribution list view dialog

  6. Click Cancel to close the Check Names dialog and return to the Select Members dialog.
  7. All of the entries in the Members field should be underlined as proper and resolved email address, except for the field names, Full Name Email.
    add names to a dl or contact groyp

  8. Delete "Full Name Email" from the Members list.
  9. Click Ok to return to the Distribution List (Contract Group) form.
  10. The addresses will be in listed in the DL (Contract Group) now.
  11. Enter a name for your DL (Contract Group) and Save it.

It's now ready to use.

You can paste the copied data (in table format) into any program that accepts pasted data, including Excel, Word, and of course, FrontPage. It's reported that you can even paste it into an Access database, although I never tried.

Note, however, that if you paste in Word or another application that is "OLE" compliant, you'll need to use Paste Special, As Unformatted Text (Edit menu in Word) or you'll end up pasting Outlook contact forms, not tabular data, as shown at the top of this screenshot.

OLE paste results include full contacts

If the program doesn't have a Paste Special, As Text option, first paste the data into Notepad, then select it in Notepad and copy again. (If you need to copy and paste Outlook data very often, get Pure Text to quickly convert it to plain text, instead of using Notepad.)

Published May 13, 2011. Last updated on October 25, 2020.

Share this:

  • Twitter
  • Facebook
  • LinkedIn
  • More
  • Print
  • Tumblr
  • Reddit
  • Pocket
  • Pinterest

Related posts:

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 theTip 254: Copying (and Pasting) Lists Tip 201: Add Addresses to a Distribution List A user asks: I'd like to take all the data listed under Home Phone and move it to Primary Phone. Or maybe just rename the HomeTip 513: Move Data to Other Fields A filtered view of the upcoming birthdaysCreate a custom view to list upcoming birthdays
Subscribe
Notify of
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Primary Sidebar

Search OutlookTips

Training and one-on-one assistance

Do you need help setting up Outlook or want some one-on-one training? I'm available for hire. See Training and one-on-one assistance for fees and to check availability.

All-Time Most Popular Posts

  • Windows 7 and Vista Start Search field
    How to start Outlook in safe mode
  • outlook.com icon
    Delete a message stuck in Outlook's Outbox
  • How to use Outlook's Command line switches
  • Use Cleanviews switch to reset all views
    How to Reset the View on Outlook folders
  • Where are my Outlook Files?
  • Folder paths
    How to Find Folder Paths in Outlook Mailboxes
  • How to use Scanpst.exe to repair Outlook data files
  • Outlook's Missing Holidays
  • backstage page
    Where is File tab in Outlook?
  • Icons found in the Inbox, Message Headers, and Toolbars

Footer

Recent Posts

  • Log into multiple Outlook on the web accounts
  • Keeping Hackers out of Microsoft accounts
  • Microsoft Account Closure Email
  • Outlook on the web Quick Actions moved to the right
  • Automatically sign out of Outlook.com

Recent Bug List

Microsoft keeps a running list of issues affecting recently released updates at Fixes or workarounds for recent issues in Outlook for Windows.

Office Update History

Update history for supported Office versions is at Update history for Office

Resources

Ask questions and share your knowledge in Outlook Forums.

You Might Like

Where is File tab in Outlook?
Using Two-factor authentication
Where are my Outlook Files?
How to use Outlook's Command line switches

© 2003–2025 ยท Outlook Tips

wpDiscuz
You are going to send email to

Move Comment