Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GMA
 
Posts: n/a
Default worksheet email address to outlook xpress contact

On an excel worksheet I have numerous email addresses. Is it possible to put
them as a group in Outexpress without having to do them individually
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

First make a backup of you current Outlook Express email addresses,
Windows Address Book (*.WAB) file(s) so you have something to
come back to.

Within OE --- file, export address book, Text File (Comma Separated Values)
include all the fields that you have in your spreadsheet, and export

You will want to make you workbook have the same headings, in the same
order (so you are sure it is you have it right). and didn't miss anything.
To help you rearrange columns so you can see that everything is in order
see http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse

Move a Column(s) and insert between columns without losing data,
Select a column, hold the SHIFT key, and grab the side of the column below
the column headers (A,B,C) and drag it left or right to move, you wail see a
single line following the cursor, drop it between existing columns.

You will want to add one more column to your Excel file, you can give it
at title in row 1 and copy anything all the way down from row 2. This is
to make sure that Excel will generate all the commas in the csv file as
OE drops the last comma if there is not a comma next. Be sure to browse
your file to make sure you have a comma at the end of each row.

Then export you workbook from Excel to a CSV file,
and then import into OE (file, import).

You have your backup of your WAB files in case you messed up and
can simply start over again..

See conversion of AOL addressbook in
Office 2000, my experience in installing - Progress report
http://www.mvps.org/dmcritchie/excel/ofc2000.htm

BTW if you are converting from a specific ISP there would be migration
tools available.

I also have some pages on Outlook Express, starting at
http://www.mvps.org/dmcritchie/ie/oe6.htm
with references to additional pages of mine, and to pages
of MVPs that specialize in OE.

---
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

"GMA" wrote in message ...
On an excel worksheet I have numerous email addresses. Is it possible to put
them as a group in Outexpress without having to do them individually



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Worksheet Tab Name into a cell address Andy Excel Discussion (Misc queries) 2 April 6th 05 04:39 PM
Can I create a static link between Excel and Outlook contact data. Bokeltri Excel Discussion (Misc queries) 3 January 31st 05 01:57 PM
export excel file to outlook express contact list gebhardt family New Users to Excel 0 January 20th 05 11:59 PM
Is it possible to add dates in an excel worksheet to Outlook Cale. Matt Excel Discussion (Misc queries) 0 January 5th 05 09:13 PM
Remove Email address header Mark Excel Discussion (Misc queries) 2 December 3rd 04 10:27 PM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"