Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / October 2003

Tip: Looking for answers? Try searching our database.

Import contacts from an excel spreadsheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anthony - 31 Oct 2003 20:23 GMT
I have an excel spreadsheet nicely organized with a
column that has business names, a column that has First
name, a column that has last names and a column that has
email addresses.  I want to take this info and import it
into my contact folder in outlook.  How do go about doing
this?  Would I convert it to a .csv format?  Please help.

Thanks.
Karl Timmermans - 01 Nov 2003 00:19 GMT
Easiest way is to use the Outlook Import wizard if this is a one-time event
(if it's going to be a repetitive event - an alternative solution may be
more suitable - ContactGenie comes to mind as one of the choices :-)  - link
below)

Excel vs CSV - basically a matter of choice in this case -

1) If Excel - you need to create a proper "named range" covering the column
header row and all the data you want to import.
or
2) If you don't want to mess with "named ranges" - export the worksheet as a
.CSV file and import it directly into Outlook.

Either of the above will do exactly what you want (this assumes that your
installation of Outlook has the necessary import filters installed or if
not, you have the install disk when it asks for it). Didn't ask for Outlook
version since the process is pretty much the same for all versions.

Karl

Signature

___________________________________
Karl Timmermans - The Claxton Group

ContactGenie - "automated contact importer for MS Outlook '2000/2002
http://contactgenie.claxton.com

> I have an excel spreadsheet nicely organized with a
> column that has business names, a column that has First
[quoted text clipped - 4 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.