Setting up Excel file to be imported to a contact dbase in Outlook

[Manny]

Hello Again, I tried to inport this excel file into a contact database in Outlook. It prompts me to say the file does not contain named values???? My goal is to use the Contact Database from outlook to merge with a Word list for labels.. I am clueless on the Excel features that would allow me to do this, Please Help!!!!

MC

Regina Lewis
6400 8th Ave 90043
Los Angeles


Cassandra M. York
736 E 103rd St 90002
Los Angeles


Eleazar Valenzuela
352 W 68th St 90003
Los Angeles


Ruth E. Parks
2056 W 68th St 90047
Los Angeles


Eula S. Neal
347 W 124th St 90061
Los Angeles


Anthony Ryan
1206 Nolden St 90042
Los Angeles


Marilyn R. Stepto
4201 W 59th St 90043
Los Angeles


Barry N And Nancy J Yarkoni
419 S Mccadden Pl 90020
Los Angeles


Philip B. Vincent
2456 Mccready Ave 90039
Los Angeles


Malvina Neurath
1527 N Fairfax Ave 90046
Los Angeles

 

[Squid]

Outlook is looking for named ranges in order to map your
fields. How you have your data currently laid out is not
a valid Excel format to import into Outlook. It should
be in a format such as (using these column heads are
default names for Outlook):
Col A: FirstName
Col B: MiddleName
Col C: LastName
Col D: BusinessStreet
Col E: BusinessCity
Col F: BuinessState
etc...

Did you manually create this file? Or is it generated
from another program?

If it would be too difficult to change you file layout,
you may want to post this question on the Outlook
newsgroup. Someone there may know of a way to import
this information.

Also when posting to newsgroups it is best to use test
data, not real data especially with person's personal
address.

HTH
Squid

-----Original Message-----
Hello Again, I tried to inport this excel file into a

contact database in Outlook. It prompts me to say the
file does not contain named values???? My goal is to use
the Contact Database from outlook to merge with a Word
list for labels.. I am clueless on the Excel features
that would allow me to do this, Please Help!!!!