Export single catagory from Outlook 2007 to an Excel file

D

dspohn

Is it possible to export only one catagory from Outlook 2007 instead of our
entire contact list? We have a large shared contact list and some entries
have several catagories. If the catagory I need isn't listed first, sorting
the Excel list doesn't work. Exporting a single catagory would make things
much easier.
 
M

Michael Bauer [MVP - Outlook]

You can either copy the contacts to another (empty) folder, and export then,
or group the view by categories, select eacg contact of the category you're
looking for, copy, and insert into the Excel workbook.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 22 Apr 2009 09:25:01 -0700 schrieb dspohn:
 
D

Diane Poremsky [MVP]

along with Michael's suggestions, use filters and filter for the category
in Excel rather than typing to sort.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
[email protected]

Exchange Messaging Outlook newsletter:
[email protected]




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
Top