Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1 category to
excel. I can view by category in outlook, but is there a way for me to
export the data to excel?

This is based on Outlook 2003 and Outlook 2007.

The only way I have been able to make it work is to first change your
'Contacts' view to 'group by category'. Next, right click on the category
name and select 'move to folder'. Choose 'new' to set up a new Contact
folder -name it the category name. It will create under your main 'Contact'
folder. From there you can export it to an Excel file by using File, Import
and Export.

"MFD" wrote:

Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1 category to
excel. I can view by category in outlook, but is there a way for me to
export the data to excel?

Thank You. Will the contacts be actually moved or merely copied?

"Spoonemore" wrote:

This is based on Outlook 2003 and Outlook 2007.

The only way I have been able to make it work is to first change your
'Contacts' view to 'group by category'. Next, right click on the category
name and select 'move to folder'. Choose 'new' to set up a new Contact
folder -name it the category name. It will create under your main 'Contact'
folder. From there you can export it to an Excel file by using File, Import
and Export.

"MFD" wrote:

Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1 category to
excel. I can view by category in outlook, but is there a way for me to
export the data to excel?

The Outlook export wizard doesn't let you export from Public Folders.

You may find one of these two options of interest (there are some others):

#1) This free utility should solve your problem especially if this is either
a
one-time or casual requirement (product not related to us - provided for
info only)
http://www.codetwo.com/pages/freewar...ook_export.php

#2) In the event you require more advanced features - you can review our
export product options which includes simultaneous multiple folder export
available in either CGX Adv or Prem editions (not free) he
http://www.contactgenie.com/cgxfeatures.htm

__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"MFD" wrote in message
...
Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1 category
to
excel. I can view by category in outlook, but is there a way for me to
export the data to excel?

MFD wrote:

Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1
category to excel. I can view by category in outlook, but is there a
way for me to export the data to excel?

Don't bother exporting anything. DIsplay your contacts in a table with,
select the range you want, and paste it into Excel.
--
Brian Tillman [MVP-Outlook]

Don;'t export or mess around with moving - if you need to use outlook data
in other program, create a view with the fields you need in the other
program and copy and paste (paste special, as text). It works with any
application that accepts paste.
http://www.outlook-tips.net/howto/copy_data.htm

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:


** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **


"MFD" wrote in message
...
Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1 category
to
excel. I can view by category in outlook, but is there a way for me to
export the data to excel?

Brian meant table "view" - that spell check got you Brian!

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au
My suggested settings for Outlook 2003 are FREE on my website.

..
"Brian Tillman" wrote in message
...
MFD wrote:

Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1
category to excel. I can view by category in outlook, but is there a
way for me to export the data to excel?

Don't bother exporting anything. DIsplay your contacts in a table with,
select the range you want, and paste it into Excel.
--
Brian Tillman [MVP-Outlook]

Judy Gleeson (MVP Outlook) judy wrote:

Brian meant table "view" - that spell check got you Brian!

My fingers don't always type what my brain supplies. I think I was put
together by Dr. Frankenstein.
--
Brian Tillman [MVP-Outlook]

Just one caveat that's worth noting regarding the "cut 'n paste" solution
and that is the number of items ultimately involved in the process. Have
found that Outlook can get particularly unhappy for large numbers (don't
know what the actual number is) and throwing "out of memory" errors or
causing addins to throw out error messages (i.e. OutlookSpy is one case in
point). Doesn't appear to have anything to do with how well endowed the
system itself is in terms of memory etc. Have run across this on more than
one occasion so it's certainly not a fluke occurrence nor is it related to
any specific version of Outlook since have had it occur on all versions
between O'2000 - O'2007. To be more exact however, the errors occurred when
highlighting the items ultimately intended for deletion.

Just mentioning this as a FYI.

Karl

__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Diane Poremsky {MVP}" wrote in message
...
Don;'t export or mess around with moving - if you need to use outlook data
in other program, create a view with the fields you need in the other
program and copy and paste (paste special, as text). It works with any
application that accepts paste.
http://www.outlook-tips.net/howto/copy_data.htm

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:


** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **


"MFD" wrote in message
...
Contact information in our Public Folders is organized by assigning
categories to individual contacts.

I would like to export contact information for the members of 1 category
to
excel. I can view by category in outlook, but is there a way for me to
export the data to excel?