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

  • Thread starter Thread starter mrider
  • Start date Start date
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.
 
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?
 
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...
 
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....
 
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..
 
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
 
Back
Top