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
|
|||
|
|||
export contacts by category
I can't find how to export only a specific category of contacts, e.g. Family,
to an Excel file. I've read all the posts and help. Custom views is fine for print, mail merge, etc. but doesn't appear to be able to "export" what you see in the custom views to Excel. Cut/paste is a kludge, but at least gets the data there, if you don't mind lots of manual cleanup (only realistic if you have only very a few contacts). I have hundreds of contacts in dozens of categories. Many contacts have multiple categories, e.g. Family and Holiday Card. In the end, the File-Export function seems to be the tool MS made for this, but it only exports ALL contacts in a folder, with no filtering (by category or anything else it seems), other than selecting specific fields of course. I switched to multiple folders of contacts years ago for this reason, but switched back to a single Contacts folder with multiple categories for many reasons probably well known to all. And when I File-Export the categories (as one of the specific fields), I get all categories in a single Excel column - NOT SORTABLE. Any ideas? |
#2
|
|||
|
|||
export contacts by category
Create another contact folder to which you *copy* the contacts of the category you want to export. Then export that folder. After that you can delete the folder with its content. -- Best regards Michael Bauer - MVP Outlook Use Outlook Categories? This is Your Tool: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Fri, 14 Mar 2008 22:10:00 -0700 schrieb dprawel: I can't find how to export only a specific category of contacts, e.g. Family, to an Excel file. I've read all the posts and help. Custom views is fine for print, mail merge, etc. but doesn't appear to be able to "export" what you see in the custom views to Excel. Cut/paste is a kludge, but at least gets the data there, if you don't mind lots of manual cleanup (only realistic if you have only very a few contacts). I have hundreds of contacts in dozens of categories. Many contacts have multiple categories, e.g. Family and Holiday Card. In the end, the File-Export function seems to be the tool MS made for this, but it only exports ALL contacts in a folder, with no filtering (by category or anything else it seems), other than selecting specific fields of course. I switched to multiple folders of contacts years ago for this reason, but switched back to a single Contacts folder with multiple categories for many reasons probably well known to all. And when I File-Export the categories (as one of the specific fields), I get all categories in a single Excel column - NOT SORTABLE. Any ideas? |
#3
|
|||
|
|||
export contacts by category
In addition to Michael's answer;
Method 1: Customize your view to what you want it exactly to be and then select-all/copy/paste it to Excel. No cleanup needed. Method 2: Export everything to Excel and then use the filter function in Excel to only display items containing the word (category) of your choice. -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "dprawel" wrote in message ... I can't find how to export only a specific category of contacts, e.g. Family, to an Excel file. I've read all the posts and help. Custom views is fine for print, mail merge, etc. but doesn't appear to be able to "export" what you see in the custom views to Excel. Cut/paste is a kludge, but at least gets the data there, if you don't mind lots of manual cleanup (only realistic if you have only very a few contacts). I have hundreds of contacts in dozens of categories. Many contacts have multiple categories, e.g. Family and Holiday Card. In the end, the File-Export function seems to be the tool MS made for this, but it only exports ALL contacts in a folder, with no filtering (by category or anything else it seems), other than selecting specific fields of course. I switched to multiple folders of contacts years ago for this reason, but switched back to a single Contacts folder with multiple categories for many reasons probably well known to all. And when I File-Export the categories (as one of the specific fields), I get all categories in a single Excel column - NOT SORTABLE. Any ideas? |
#4
|
|||
|
|||
export contacts by category
Good catch, Robert. I like #2. -- Best regards Michael Bauer - MVP Outlook Use Outlook Categories? This is Your Tool: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Sat, 15 Mar 2008 11:43:30 +0100 schrieb Roady [MVP]: In addition to Michael's answer; Method 1: Customize your view to what you want it exactly to be and then select-all/copy/paste it to Excel. No cleanup needed. Method 2: Export everything to Excel and then use the filter function in Excel to only display items containing the word (category) of your choice. |
#5
|
|||
|
|||
export contacts by category
Hi,
You can use CodeTwo Outlook Export freeware to do that. Group your view "by category", then select category groups you want to export and click the "Outlook Export" icon in the Outlook toolbar. You can download Outlook Export he http://www.codetwo.com/pages/freewar...ook_export.php -- Best regards, Michal [Microsoft Outlook MVP] http://www.codetwo.com Share Outlook on the net without Exchange! dprawel wrote: I can't find how to export only a specific category of contacts, e.g. Family, to an Excel file. I've read all the posts and help. Custom views is fine for print, mail merge, etc. but doesn't appear to be able to "export" what you see in the custom views to Excel. Cut/paste is a kludge, but at least gets the data there, if you don't mind lots of manual cleanup (only realistic if you have only very a few contacts). I have hundreds of contacts in dozens of categories. Many contacts have multiple categories, e.g. Family and Holiday Card. In the end, the File-Export function seems to be the tool MS made for this, but it only exports ALL contacts in a folder, with no filtering (by category or anything else it seems), other than selecting specific fields of course. I switched to multiple folders of contacts years ago for this reason, but switched back to a single Contacts folder with multiple categories for many reasons probably well known to all. And when I File-Export the categories (as one of the specific fields), I get all categories in a single Excel column - NOT SORTABLE. Any ideas? |
#6
|
|||
|
|||
export contacts by category
Thanks! It's funny to see how many different solutions we came up with in
this thread :-) -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "Michael Bauer [MVP - Outlook]" wrote in message .. . Good catch, Robert. I like #2. -- Best regards Michael Bauer - MVP Outlook Use Outlook Categories? This is Your Tool: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Sat, 15 Mar 2008 11:43:30 +0100 schrieb Roady [MVP]: In addition to Michael's answer; Method 1: Customize your view to what you want it exactly to be and then select-all/copy/paste it to Excel. No cleanup needed. Method 2: Export everything to Excel and then use the filter function in Excel to only display items containing the word (category) of your choice. |
#8
|
|||
|
|||
export contacts by category
I am reading this and still cannot figure out how to do this. I have the
same issue of wanting to export specific distribution lists to an excel spreadsheet. I have almost 4000 names in my Outlook contact list. This post was originally written 2 years ago. I can't believe there still isn't a simple way to do this! "Michal [Outlook MVP]" wrote: Hi, You can use CodeTwo Outlook Export freeware to do that. Group your view "by category", then select category groups you want to export and click the "Outlook Export" icon in the Outlook toolbar. You can download Outlook Export he http://www.codetwo.com/pages/freewar...ook_export.php -- Best regards, Michal [Microsoft Outlook MVP] http://www.codetwo.com Share Outlook on the net without Exchange! dprawel wrote: I can't find how to export only a specific category of contacts, e.g. Family, to an Excel file. I've read all the posts and help. Custom views is fine for print, mail merge, etc. but doesn't appear to be able to "export" what you see in the custom views to Excel. Cut/paste is a kludge, but at least gets the data there, if you don't mind lots of manual cleanup (only realistic if you have only very a few contacts). I have hundreds of contacts in dozens of categories. Many contacts have multiple categories, e.g. Family and Holiday Card. In the end, the File-Export function seems to be the tool MS made for this, but it only exports ALL contacts in a folder, with no filtering (by category or anything else it seems), other than selecting specific fields of course. I switched to multiple folders of contacts years ago for this reason, but switched back to a single Contacts folder with multiple categories for many reasons probably well known to all. And when I File-Export the categories (as one of the specific fields), I get all categories in a single Excel column - NOT SORTABLE. Any ideas? |
#9
|
|||
|
|||
export contacts by category
There isn't and never will be. Distribution Lists are a deprecated feature
that were never robust to begin with. If you want that data in an Excel file, then just save the DL as a text file and open it in Excel. That's not all that hard, is it? -- Russ Valentine "PaintedLady" wrote in message ... I am reading this and still cannot figure out how to do this. I have the same issue of wanting to export specific distribution lists to an excel spreadsheet. I have almost 4000 names in my Outlook contact list. This post was originally written 2 years ago. I can't believe there still isn't a simple way to do this! "Michal [Outlook MVP]" wrote: Hi, You can use CodeTwo Outlook Export freeware to do that. Group your view "by category", then select category groups you want to export and click the "Outlook Export" icon in the Outlook toolbar. You can download Outlook Export he http://www.codetwo.com/pages/freewar...ook_export.php -- Best regards, Michal [Microsoft Outlook MVP] http://www.codetwo.com Share Outlook on the net without Exchange! dprawel wrote: I can't find how to export only a specific category of contacts, e.g. Family, to an Excel file. I've read all the posts and help. Custom views is fine for print, mail merge, etc. but doesn't appear to be able to "export" what you see in the custom views to Excel. Cut/paste is a kludge, but at least gets the data there, if you don't mind lots of manual cleanup (only realistic if you have only very a few contacts). I have hundreds of contacts in dozens of categories. Many contacts have multiple categories, e.g. Family and Holiday Card. In the end, the File-Export function seems to be the tool MS made for this, but it only exports ALL contacts in a folder, with no filtering (by category or anything else it seems), other than selecting specific fields of course. I switched to multiple folders of contacts years ago for this reason, but switched back to a single Contacts folder with multiple categories for many reasons probably well known to all. And when I File-Export the categories (as one of the specific fields), I get all categories in a single Excel column - NOT SORTABLE. Any ideas? |
Thread Tools | |
Display Modes | |
|
|