using Excel and Outlook Express

  • Thread starter Thread starter ross
  • Start date Start date
R

ross

Is there a way to move names and addresses from Excel into the Outlook
Express address book, please? I appreciate this newsgroup. Dick Ross
 
Not really an excel question, but you can import a CSV file under
file>import>other address book
and text (comma separated values)
 
Sure it's an Excel question, how else are you going to do
massive updates. Start from the address book and export it,
being careful to get all of the fields, and watch
out for the comments. It did this 6 years ago.
I didn't have an address book then but I made up some entries
so that I could export and have the fields correct when I populated
it with data rearranged from AOL..

Then work with it in Excel. When you update your address book, you
will probably have to add a column with spaces in it all the way down
for your used range to generate a comma on end so that it can be
exported from Excel and imported back to the address book without
losing the last column.
 
Hi Ross,
Here is some more specific information:

see my experience in installing Office 2000 - Progress report
http://www.mvps.org/dmcritchie/excel/excel.htm/ofc2000.htm

You want to put some entries into your Outlook Express Address Book
so that you can see the layout and names of fields when you Export it
to a CSV file. You probably also want to backup your original
Address Book (.wab)
see my http://www.mvps.org/dmcritchie/excel/backup.htm

You then want to retitle your columns to match what is used in the
Address Book and import your file into the windows address book.
Remember to add an extra column when you create your .csv file
so you don't lose that last column..
You will probably do this a few times until you get it right. And make
sure that you picked up all columns.

If you want to rearrange columns see
http://www.mvps.org/dmcritchie/excel/fillehand.htm#mouse

If you want to separate lastname see SepLast in
http://www.mvps.org/dmcritchie/excel/join.htm#seplast

When you bring up the address book you will find Export and
Import under the file menu.
 
Back
Top