Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
joelcelyn
 
Posts: n/a
Default Can I import my excel worksheet to my address book


  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

Probably. Will you address book import CSV. Is the excel worksheet setup
like you address book. What does it say in the help file?

--
Regards,
Tom Ogilvy

"joelcelyn" wrote in message
...



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

This is how I do it.

The basics........Your layout may differ. Instructions here are for Name and
Email address only, but adjust to suit for more columns.

First have the names and email addresses in Excel in two columns.

I set up also a third column with the names duplicated so when you Import to
Outlook you have a name for the Contact and a Display Name instead of the
email address in the To: box.

FileSave AsFile Type CSV(comma delimited)(*.csv)

Now open Outlook and FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile to Import(you can browse to your saved
*.csv file). Next you will be asked where to import them to. I bring mine to
"Contacts".

Follow the instructions and you will get a Map. Drag your names and addresses
to the appropriate spots on the Map

1. Name of Contact
2. Email address1
3. Display Name(if you have one by making the duplicate column mentioned
earlier). If not, the email address wil be displayed in the To: box.

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).

Now they are in the Contacts folder, you can group them as you wish.

Gord Dibben Excel MVP

On Sun, 13 Feb 2005 13:15:03 -0800, joelcelyn
wrote:


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
Hyperlink to specific worksheet in Excel Glenn Mulno Links and Linking in Excel 2 February 7th 05 06:01 PM
save an Excel worksheet as a comma delimited file? Trophy Man Excel Discussion (Misc queries) 2 January 8th 05 03:11 AM
How do I convert an existing MS Excel worksheet tracking a simple. NOTANYJOE Excel Discussion (Misc queries) 1 January 4th 05 02:07 AM
how create/maintain Excel "db" of client, output to Avery address. SunnyCritters Excel Discussion (Misc queries) 1 December 27th 04 09:09 PM
Will Excel import a spooled file to look the same every month? teamo333 Excel Worksheet Functions 1 December 7th 04 09:44 PM


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

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

About Us

"It's about Microsoft Excel"