Why won't Outlook 2003 import my contacts entered in Excel?

M

mrider

So I first imported a couple contacts from an Excel spreadsheet I created as
sort of a tester and it worked perfectly. I created the spreadsheet based on
fields from an exported Outlook contact so that my fields would correspond in
each program. The first tester sheet worked fine. I then entered additional
contact information and now Outlook will not even pick up one bit of the
data. I've remapped the fields twice just to make sure I didn't make any
errors. What is going on?

Info that might be helpul:
It is linked to an Access database as well. I've been experimenting with
ways to get it to work via other contact managers.
 
G

Gordon

mrider said:
So I first imported a couple contacts from an Excel spreadsheet I created
as
sort of a tester and it worked perfectly. I created the spreadsheet based
on
fields from an exported Outlook contact so that my fields would correspond
in
each program. The first tester sheet worked fine. I then entered
additional
contact information and now Outlook will not even pick up one bit of the
data. I've remapped the fields twice just to make sure I didn't make any
errors. What is going on?

Info that might be helpul:
It is linked to an Access database as well. I've been experimenting with
ways to get it to work via other contact managers.
Click to expand...


Did you name the range in the Excel workbook?
 
G

Gordon

mrider said:
No... How do I do that?
Click to expand...

Select (ie highlight) all the data and in the Name box at the top LH side of
the window, type in a name. Anything will do AFAIK...
 
M

mrider

Unfortunately, when I do that and press enter the selection changes from what
I had originally chosen (which included the new contacts I had added in
addition to the tester contacts) to just a selection of the original tester
contacts. Grrr....
 
G

Gordon

mrider said:
Unfortunately, when I do that and press enter the selection changes from
what
I had originally chosen (which included the new contacts I had added in
addition to the tester contacts) to just a selection of the original
tester
contacts. Grrr....
Click to expand...

Sounds like the original data already had a range name - call the larger
range a different name..
 
K

Karl Timmermans

Alternative to Excel & Named Range.........

#1 - Save current worksheet as a CSV file
#2 - Import CSV file into Outlook instead of Excel file

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing excel spreadsheet into contacts 3
Outlook 2003 - Missing Email Address when Importing Contacts 0
Import Contacts From Excel to Outlook Not Working 3
Why does outlook only import the first contact from my .xls file? 2
Problem importing contacts from excel 2003 to outlook 2007 4
How do I import a contact list from excel to Outlook? 8
Importing contact data from Excel 4
Contact file not visible when importing or exporting contacts 2

Top