exporting categories - excel

  • Thread starter Thread starter Annemarie en Jeroen
  • Start date Start date
A

Annemarie en Jeroen

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)
 
Maybe a more simple question; how do you separate text that is in one cell
of excel and transfer it to different cells?

Text to Columns feature on the Data menu. I hope you can find this in your
language version of Excel.

--
Jim Rech
Excel MVP
| 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)
|
|
 
Back
Top