Make sure your address book has representative entries of the data you
want to include, then Export your Address book as a .csv file, which
you can read into Excel. Make sure that you save this file somewhere
so you can get it back it you mess things up Would also be a good
idea to backup your .wab file.
Make a copy of the file. Take your file and insert / rearrange columns to
match the format of what you exported. Then you can add one more
column with a space in all cells down to the last row of your data.
Then save your spreadsheet and export the sheet as a .csv file.
When IMPORTING your csv file into the address book that extra
comma on the end is needed to prevent loss of the last column.
It's an old page but you may find some helpful information on
http://www.mvps.org/dmcritchie/excel/ofc2000.htm
I don't remember if you lose or add to existing entries when you
import. I think you have to have everything when you import.
By the way you want to backup your .WAB (Windows Address Book)
along with your personal files when you backup your system.
http://www.mvps.org/dmcritchie/excel/backup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
Bradley Dawson said:
A line from one of the address records would be helpful. Also, elaborate on
the format that you want.
Not useful to us but Graham will need it to pattern his own file.
Are the fields seperated [separated] into columns? If everything is in one cell, use
the Data>Text to Columns wizard. Once the fields are seperated [separated], you can
move them around easily. // separated //
Graham received an Excel spreadsheet, I certainly hope it is in columns.
Jim said:
I have a received an excel spreadhsheet [spreadsheet] of address book
type information. I am trying to determine the simplest
way to get this into a directory type format. I have
tried to import into Access but have been unsuccessful.
Any ideas?
