How do I setup an EXCEL file to import to Outlook 2003 contact?

[Guest]

I basically exported a contact folder to an EXCEL file. Then I thought I
could just add new row (records) to this Excel file and import back into
OUTLOOK. I go through the steps but new records are not imported.

 

[Russ Valentine [MVP-Outlook]]

You'll need to provide at least some information. There is none here.
What were you trying to achieve by exporting Outlook data to a different
format, then re-importing it? I can think of no reason to do so unless you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what happens?

 

[Guest]

What I want to do is create a contact folder with a list of people and
organizations that I want to send emails to. The list may be up to 200
entries.

Doing this by adding individual contacts in MS Outlook is time consuming.

It’s easier in EXCEL. So I’d like to create a contact list in Excel and
import it into a MS contact folder.

To test this operation I created a contact folder in EXCEL and using the
OUTLOOK wizard I exported it to EXCEL. It worked fine.

I added a couple of new rows to the EXCEL file and used the Outlook wizard
to import it into MS Outlook and that worked fine.

When I tried to add more rows to the EXCEL file and import with wizard to MS
OUTLOOK the new rows did not appear in Outlook after importing.

Can you provide an example of how to do this correctly?

Thanks.
--
FRED

You'll need to provide at least some information. There is none here.
What were you trying to achieve by exporting Outlook data to a different
format, then re-importing it? I can think of no reason to do so unless you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what happens?
--
Russ Valentine
[MVP-Outlook]

I basically exported a contact folder to an EXCEL file. Then I thought I
could just add new row (records) to this Excel file and import back into
OUTLOOK. I go through the steps but new records are not imported.

 

[Russ Valentine [MVP-Outlook]]

Dubious claim. Explain why adding Contacts in Outlook is more difficult than
adding them in Excel.
Your contention suggests you are simply not familiar with Outlook.
--
Russ Valentine
[MVP-Outlook]

What I want to do is create a contact folder with a list of people and
organizations that I want to send emails to. The list may be up to 200
entries.

Doing this by adding individual contacts in MS Outlook is time consuming.

It's easier in EXCEL. So I'd like to create a contact list in Excel and
import it into a MS contact folder.

To test this operation I created a contact folder in EXCEL and using the
OUTLOOK wizard I exported it to EXCEL. It worked fine.

I added a couple of new rows to the EXCEL file and used the Outlook wizard
to import it into MS Outlook and that worked fine.

When I tried to add more rows to the EXCEL file and import with wizard to
MS
OUTLOOK the new rows did not appear in Outlook after importing.

Can you provide an example of how to do this correctly?

Thanks.
--
FRED

You'll need to provide at least some information. There is none here.
What were you trying to achieve by exporting Outlook data to a different
format, then re-importing it? I can think of no reason to do so unless
you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what happens?
--
Russ Valentine
[MVP-Outlook]

I basically exported a contact folder to an EXCEL file. Then I thought I
could just add new row (records) to this Excel file and import back
into
OUTLOOK. I go through the steps but new records are not imported.

 

[Sue Mosher [MVP-Outlook]]

You need to expand the named range to cover the newly added rows, then save the worksheet.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

HI Sue:

Thanks

How do I "expand the named range to cover the newly added rows"????


TIA, FRED

 

[Sue Mosher [MVP-Outlook]]

Insert | Range | Define

The named range needs to cover all the rows and columns you want to import, including column headings.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

HI Sue:

Thanks

How do I "expand the named range to cover the newly added rows"????


TIA, FRED

 

[Guest]

Hi, Well in Excel I can work in a worksheet were all fields are visible,
I can also type in column field and tab or move to next field. Hit enter to
find myself in the next row and start again. Also I'm more familiar with
Excel commands so mistakes are easier to correct.

If you have an example that shows MS Outlook to be as easy and straight
forward I'll not only be happy to try it but I might be come a cheering
customer.
FRED

Dubious claim. Explain why adding Contacts in Outlook is more difficult than
adding them in Excel.
Your contention suggests you are simply not familiar with Outlook.
--
Russ Valentine
[MVP-Outlook]

What I want to do is create a contact folder with a list of people and
organizations that I want to send emails to. The list may be up to 200
entries.

Doing this by adding individual contacts in MS Outlook is time consuming.

It's easier in EXCEL. So I'd like to create a contact list in Excel and
import it into a MS contact folder.

To test this operation I created a contact folder in EXCEL and using the
OUTLOOK wizard I exported it to EXCEL. It worked fine.

I added a couple of new rows to the EXCEL file and used the Outlook wizard
to import it into MS Outlook and that worked fine.

When I tried to add more rows to the EXCEL file and import with wizard to
MS
OUTLOOK the new rows did not appear in Outlook after importing.

Can you provide an example of how to do this correctly?

Thanks.
--
FRED

You'll need to provide at least some information. There is none here.
What were you trying to achieve by exporting Outlook data to a different
format, then re-importing it? I can think of no reason to do so unless
you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what happens?
--
Russ Valentine
[MVP-Outlook]
I basically exported a contact folder to an EXCEL file. Then I thought I
could just add new row (records) to this Excel file and import back
into
OUTLOOK. I go through the steps but new records are not imported.

 

[Guest]

HI Sue,

Thanks for reply.

How do I "name a range"? Do I do it in Excel or Outlook?

TIA

 

[Russ Valentine [MVP-Outlook]]

You can also work in a Table view in Outlook if you prefer that.
Considering the difficulty you are having trying to work first in Excel then
import into Outlook, you clearly need to broaden your horizon.
--
Russ Valentine
[MVP-Outlook]

Hi, Well in Excel I can work in a worksheet were all fields are visible,
I can also type in column field and tab or move to next field. Hit enter
to
find myself in the next row and start again. Also I'm more familiar with
Excel commands so mistakes are easier to correct.

If you have an example that shows MS Outlook to be as easy and straight
forward I'll not only be happy to try it but I might be come a cheering
customer.
FRED

Dubious claim. Explain why adding Contacts in Outlook is more difficult
than
adding them in Excel.
Your contention suggests you are simply not familiar with Outlook.
--
Russ Valentine
[MVP-Outlook]

What I want to do is create a contact folder with a list of people and
organizations that I want to send emails to. The list may be up to 200
entries.

Doing this by adding individual contacts in MS Outlook is time
consuming.

It's easier in EXCEL. So I'd like to create a contact list in Excel and
import it into a MS contact folder.

To test this operation I created a contact folder in EXCEL and using
the
OUTLOOK wizard I exported it to EXCEL. It worked fine.

I added a couple of new rows to the EXCEL file and used the Outlook
wizard
to import it into MS Outlook and that worked fine.

When I tried to add more rows to the EXCEL file and import with wizard
to
MS
OUTLOOK the new rows did not appear in Outlook after importing.

Can you provide an example of how to do this correctly?

Thanks.
--
FRED


:

You'll need to provide at least some information. There is none here.
What were you trying to achieve by exporting Outlook data to a
different
format, then re-importing it? I can think of no reason to do so unless
you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what
happens?
--
Russ Valentine
[MVP-Outlook]
I basically exported a contact folder to an EXCEL file. Then I
thought I
could just add new row (records) to this Excel file and import back
into
OUTLOOK. I go through the steps but new records are not imported.

 

[Guest]

Hi Russ

I looked in OUTLOOK help and can't find anything on "table view". Can you
tell me how to go to "Table View"?

TIA
--
FRED

You can also work in a Table view in Outlook if you prefer that.
Considering the difficulty you are having trying to work first in Excel then
import into Outlook, you clearly need to broaden your horizon.
--
Russ Valentine
[MVP-Outlook]

Hi, Well in Excel I can work in a worksheet were all fields are visible,
I can also type in column field and tab or move to next field. Hit enter
to
find myself in the next row and start again. Also I'm more familiar with
Excel commands so mistakes are easier to correct.

If you have an example that shows MS Outlook to be as easy and straight
forward I'll not only be happy to try it but I might be come a cheering
customer.
FRED

Dubious claim. Explain why adding Contacts in Outlook is more difficult
than
adding them in Excel.
Your contention suggests you are simply not familiar with Outlook.
--
Russ Valentine
[MVP-Outlook]
What I want to do is create a contact folder with a list of people and
organizations that I want to send emails to. The list may be up to 200
entries.

Doing this by adding individual contacts in MS Outlook is time
consuming.

It's easier in EXCEL. So I'd like to create a contact list in Excel and
import it into a MS contact folder.

To test this operation I created a contact folder in EXCEL and using
the
OUTLOOK wizard I exported it to EXCEL. It worked fine.

I added a couple of new rows to the EXCEL file and used the Outlook
wizard
to import it into MS Outlook and that worked fine.

When I tried to add more rows to the EXCEL file and import with wizard
to
MS
OUTLOOK the new rows did not appear in Outlook after importing.

Can you provide an example of how to do this correctly?

Thanks.
--
FRED


:

You'll need to provide at least some information. There is none here.
What were you trying to achieve by exporting Outlook data to a
different
format, then re-importing it? I can think of no reason to do so unless
you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what
happens?
--
Russ Valentine
[MVP-Outlook]
I basically exported a contact folder to an EXCEL file. Then I
thought I
could just add new row (records) to this Excel file and import back
into
OUTLOOK. I go through the steps but new records are not imported.

 

[Judy Gleeson, MVP Outlook]

Naming ranges is an Excel function try Excel help if you've never done it
before.

Tables in Outlook is where a lot of the powerful functions are hidden. Use
the Advanced Toolbars (View | Toolbars), then use the Current View Window,
Field Chooser and Group By Box to manipulate columns and data. They are
side by side on the Advanced toolbar.

Judy Gleeson, MVP Outlook
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!

HI Sue,

Thanks for reply.

How do I "name a range"? Do I do it in Excel or Outlook?

TIA

 

[Russ Valentine [MVP-Outlook]]

There are a number of Table views.
Phone List is one, for example.
I'm sure it is easier just to enter names and addresses into an Excel
spreadsheet when that's what you're used to doing rather than having to save
each Contact Record individually, but if what you want is an Outlook Contact
database, it still may be easier and more reliable in the long run just to
enter the data into Outlook.
--
Russ Valentine
[MVP-Outlook]

Hi Russ

I looked in OUTLOOK help and can't find anything on "table view". Can you
tell me how to go to "Table View"?

TIA
--
FRED

You can also work in a Table view in Outlook if you prefer that.
Considering the difficulty you are having trying to work first in Excel
then
import into Outlook, you clearly need to broaden your horizon.
--
Russ Valentine
[MVP-Outlook]

Hi, Well in Excel I can work in a worksheet were all fields are
visible,
I can also type in column field and tab or move to next field. Hit
enter
to
find myself in the next row and start again. Also I'm more familiar
with
Excel commands so mistakes are easier to correct.

If you have an example that shows MS Outlook to be as easy and straight
forward I'll not only be happy to try it but I might be come a cheering
customer.
FRED


:

Dubious claim. Explain why adding Contacts in Outlook is more
difficult
than
adding them in Excel.
Your contention suggests you are simply not familiar with Outlook.
--
Russ Valentine
[MVP-Outlook]
What I want to do is create a contact folder with a list of people
and
organizations that I want to send emails to. The list may be up to
200
entries.

Doing this by adding individual contacts in MS Outlook is time
consuming.

It's easier in EXCEL. So I'd like to create a contact list in Excel
and
import it into a MS contact folder.

To test this operation I created a contact folder in EXCEL and using
the
OUTLOOK wizard I exported it to EXCEL. It worked fine.

I added a couple of new rows to the EXCEL file and used the Outlook
wizard
to import it into MS Outlook and that worked fine.

When I tried to add more rows to the EXCEL file and import with
wizard
to
MS
OUTLOOK the new rows did not appear in Outlook after importing.

Can you provide an example of how to do this correctly?

Thanks.
--
FRED


:

You'll need to provide at least some information. There is none
here.
What were you trying to achieve by exporting Outlook data to a
different
format, then re-importing it? I can think of no reason to do so
unless
you
wanted to lose or corrupt your data.
You said you go through "the steps." What steps exactly and what
happens?
--
Russ Valentine
[MVP-Outlook]
I basically exported a contact folder to an EXCEL file. Then I
thought I
could just add new row (records) to this Excel file and import
back
into
OUTLOOK. I go through the steps but new records are not imported.