Bryan said:
My friend just sent me an excel document with the names
adresses phone...ect. I've been trying to import it into
my outlook address book, but it says the file has no name
ranges and to use excel to name the ranges of data I want
to import. Hoe do I do that?
I have done this several times using Excel97 and Outlook98. As far as my
experience goes, all you need is to have field names that Outlook
understands in row 1, with the data starting in row 2. It doesn't matter
about the order of the columns (fields), and you don't need all the fields
that Outlook can recognise. But you do need to specify the names of the
fields you are using in the manner that Outlook requires.
The best approach is to export a file from Outlook into Excel format. (If
you don't already have one, just enter a couple of sample names/addresses in
Outlook and export this.) Then you can see exactly how Outlook names each
field. You can even copy/paste the required names from this into your own
Excel file, so that you can be sure Outlook will recognise them.
