Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting categories - excel
Exporting categories from msoutlook contacts to excel
In our company we still use msword97, excel97 and outlook with this version (it is true!). All our companycontacts (1000) are in outlook/contacts and we use many company related categories in contacts. When I export the contacts to excel, the categories are placed in one cell, separated by a column (or semi colon??). When I try to mail merge from the category column in excel in word, I cannot make extractions from the category column. Is there anybody who can tell me how to solve this problem? The problem again in short: I cannot make a mailmerge only for certain categories from outlook contacts (the 97-version). By the way; I also have problems doing this in later versions. I am very glad if anybody can help me out. Maybe a more simple question; how do you separate text that is in one cell of excel and transfer it to different cells? Thanks in advance! Jeroen (working for Dutch government) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting categories - excel
Jeroen
Try DataText To Columns, with a comma as the separator. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Annemarie en Jeroen" wrote in message ... Exporting categories from msoutlook contacts to excel In our company we still use msword97, excel97 and outlook with this version (it is true!). All our companycontacts (1000) are in outlook/contacts and we use many company related categories in contacts. When I export the contacts to excel, the categories are placed in one cell, separated by a column (or semi colon??). When I try to mail merge from the category column in excel in word, I cannot make extractions from the category column. Is there anybody who can tell me how to solve this problem? The problem again in short: I cannot make a mailmerge only for certain categories from outlook contacts (the 97-version). By the way; I also have problems doing this in later versions. I am very glad if anybody can help me out. Maybe a more simple question; how do you separate text that is in one cell of excel and transfer it to different cells? Thanks in advance! Jeroen (working for Dutch government) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
exporting categories - excel
You got pretty much the same answers at your other post, too.
Annemarie en Jeroen wrote: Exporting categories from msoutlook contacts to excel In our company we still use msword97, excel97 and outlook with this version (it is true!). All our companycontacts (1000) are in outlook/contacts and we use many company related categories in contacts. When I export the contacts to excel, the categories are placed in one cell, separated by a column (or semi colon??). When I try to mail merge from the category column in excel in word, I cannot make extractions from the category column. Is there anybody who can tell me how to solve this problem? The problem again in short: I cannot make a mailmerge only for certain categories from outlook contacts (the 97-version). By the way; I also have problems doing this in later versions. I am very glad if anybody can help me out. Maybe a more simple question; how do you separate text that is in one cell of excel and transfer it to different cells? Thanks in advance! Jeroen (working for Dutch government) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel chart categories.... | Excel Worksheet Functions | |||
How can I collapse Excel data into categories? | Excel Discussion (Misc queries) | |||
Drop down categories in Excel | Excel Worksheet Functions | |||
Excel function wizard categories | Excel Programming | |||
Categories in Excel. | Excel Programming |