import or conversion Word-table into address book

[ingel]

I have a large address book in Word-format: an ordinary table with 12
columns (surname, name etc). Is there any way how I can converse the
table into a OUtlook 2007 addressbook or import it without the need of
typing out all 500 addresses by hand?

Thanks in advance,

Peter

 

[Roady [MVP]]

Your best way to go would be to convert the table to Excel and then use
Outlook's import feature.

 

[ingel]

Thanks a lot. The conversion to Excel succeeded (1997-2003). However,
I do not manage to import the Excel file into Outlook 2007. Could you
help me once more?

Thanks again,

Peter

 

[Gordon]

Thanks a lot. The conversion to Excel succeeded (1997-2003). However,
I do not manage to import the Excel file into Outlook 2007. Could you
help me once more?

Do a Save-As into CSV format. Then try importing that....

 

[ingel]

Thanks. Sorry for keeping on asking, but I succeeded in the saving,
not yet in the correct importing. Wheb trying, I am asked to allocate
values to fields. However, in the value screen there is only one line
with name, surname, address and so on on that one and only line. So it
is not possible to allocate the different columns to different fields.
Could you again help me out?

Thanks!

Peter

 

[Roady [MVP]]

It sounds like you have copied everything into a single field in Excel then.
You must copy it in such a way that each value of your table has its own
field in Excel. Then import that Excel sheet.

You can probably use the Text to Columns option on the Data tab in Excel to
accomplish this easily.



-----

 

[ingel]

Sorry, still not succeeded, even not after many tries. When I look at
my excel sheet: every value has its own field. May I send you an
extract ot the excel file to show what I mean?

Thanks again,

Peter

 

[Roady [MVP]]

Hi Peter,

You could. You could even write the message in Dutch ;-)
You can send it to the address I post with (but then unmunged of course) or
you can find contact information on my websites in the About section.



-----

 

[Roady [MVP]]

I received your Excel sheet and replied with instructions on how to correct
your import.
In short for others;
-create a Named Range in the Excel sheet
-during the import process use the Map Custom Fields... button to map the
Excel columns to the Outlook fields.

Instructions on how to create a named range in Excel can be found here;
http://www.msoutlook.info/question/238