If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I export contact information from Public Folders
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? |
#2
|
|||
|
|||
Can I export contact information from Public Folders
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? |
#3
|
|||
|
|||
Can I export contact information from Public Folders
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? |
#4
|
|||
|
|||
Can I export contact information from Public Folders
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? |
#5
|
|||
|
|||
Can I export contact information from Public Folders
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] |
#7
|
|||
|
|||
Can I export contact information from Public Folders
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] |
#8
|
|||
|
|||
Can I export contact information from Public Folders
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] |
#9
|
|||
|
|||
Can I export contact information from Public Folders
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? |
Thread Tools | |
Display Modes | |
|
|