Importing addresses from Excel into Outlook contacts

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

Judy
Sun Mar 23 15:39:50 PDT 2008

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


.
"DaShuta" <DaShuta@discussions.microsoft.com> wrote in message
news:81DE6CDB-A569-4CF5-934B-E553B6FE6CD2@microsoft.com...
>I have an Excel address book file I would like to import into my Outlook
> contacts. Is this possible?

Milly
Sun Mar 23 15:49:09 PDT 2008

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

--=20
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
Wed May 28 08:47:01 PDT 2008

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.

"DaShuta" wrote:

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

Russ
Wed May 28 13:01:35 PDT 2008

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

--
Russ Valentine
[MVP-Outlook]
"Liz" <Liz@discussions.microsoft.com> wrote in message
news:BF716902-C0B6-4092-A463-A62839B1B354@microsoft.com...
> 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.
>
> "DaShuta" wrote:
>
>> I have an Excel address book file I would like to import into my Outlook
>> contacts. Is this possible?

Brian
Thu May 29 06:54:41 PDT 2008

Liz <Liz@discussions.microsoft.com> wrote:

> 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.
--
Brian Tillman [MVP-Outlook]

Kelley
Mon Jun 23 13:07:03 PDT 2008

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

"Judy Gleeson (MVP Outlook)" wrote:

> 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
>
>
> ..
> "DaShuta" <DaShuta@discussions.microsoft.com> wrote in message
> news:81DE6CDB-A569-4CF5-934B-E553B6FE6CD2@microsoft.com...
> >I have an Excel address book file I would like to import into my Outlook
> > contacts. Is this possible?
>
>
>

Gordon
Tue Jun 24 00:05:45 PDT 2008

"Kelley" <Kelley@discussions.microsoft.com> wrote in message
news:774FADD5-E0A7-4E34-B803-9734CB0D80E9@microsoft.com...
>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
Tue Jun 24 05:41:36 PDT 2008

Kelley <Kelley@discussions.microsoft.com> wrote:

> 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.
--
Brian Tillman [MVP-Outlook]