Importing addresses from Excel into Outlook contacts

[DaShuta]

I have an Excel address book file I would like to import into my Outlook
contacts. Is this possible?

 

[Judy Gleeson \(MVP Outlook\)]

In Outlook you use File | Import. Make sure to name the range in Excel
first.

Here's how to post a good question:
http://66.39.69.143/goodpost.htm
http://support.microsoft.com/kb/555375


Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au


..

 

[Milly Staples [MVP - Outlook]]

In Outlook-File->Import and Export->From a program->Excel.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, DaShuta asked:

| I have an Excel address book file I would like to import into my
| Outlook contacts. Is this possible?

 

[Liz]

Hi There,

I have MS Office Outlook 2003 SP3, Small business edition and there is no
"Import" option under the File menu options. I am unsure how to do a simple
import of contacts into my address book and cannot find any on-line comments
regarding such... except that allow you tobring in pst files and
unfortunatley i am obviously clueless as to how i convert an excel file to a
pst file. any insight would be much appreciated.

 

[Russ Valentine [MVP-Outlook]]

That would mean you have not yet installed Outlook's importers and exporters
from the Office CD.

 

[Brian Tillman]

I have MS Office Outlook 2003 SP3, Small business edition and there
is no "Import" option under the File menu options. I am unsure how
to do a simple import of contacts into my address book

Outlook 2003's Address Book interface is never the proper interface for
manipulating contacts. Use the Contacts folder for contacts. There will be
an Import and Export item on the main Outlook window's File menu.

 

[Kelley]

I can not find any instrution that says to name a range in Excel first. Why
isn't that in the instruction. How do I name a range in Excel? What name do I
use?

Thank you,
Kelley Judd

 

[Gordon]

I can not find any instrution that says to name a range in Excel first. Why
isn't that in the instruction.

It is in mine. Did you go to Help in Excel and type in "name a range"?

How do I name a range in Excel?

Select the data (highlight it) then in the Name box, that's the box to the
left of the formula bar that has the cell address in, just type in your
name.

What name do I
use?

Anything you like......something like Outlook Contacts might do.....

 

[Brian Tillman]

I can not find any instrution that says to name a range in Excel
first. Why isn't that in the instruction. How do I name a range in
Excel? What name do I use?

And if you don't wish to use a named range (Gordon gives fine instructions
on how), save the spreadsheet as a CSV file. You won't need a named range
then.