Prev: Number of pages in worksheet doesn't match Print Preview pages
Next: Filter by Color
From: geno on 10 May 2010 16:25
I have an Excel spreadsheet of my contacts, and when in Outlook, I am trying
to import them into contacts there. I get the following:
file has no named ranges. in Excel, name the range of date you want to import.
I am using Office 2007 and would appreciate any help here. Thanks
From: Ron de Bruin on 10 May 2010 16:52

See http://www.rondebruin.nl/mail/importcontacts.htm

Note: Outlook 2007 cannot import Excel 2007 files, save the file in 2007 as Excel 97-2003 file


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"geno" <geno(a)discussions.microsoft.com> wrote in message news:65AA061A-7761-4D8C-B26A-CB2331F85764(a)microsoft.com...
> I have an Excel spreadsheet of my contacts, and when in Outlook, I am trying
> to import them into contacts there. I get the following:
> file has no named ranges. in Excel, name the range of date you want to import.
> I am using Office 2007 and would appreciate any help here. Thanks
From: Gord Dibben on 10 May 2010 17:34
In Excel help you could always look up how to name a range.

But see Ron's reply for more detail.


Gord Dibben MS Excel MVP

On Mon, 10 May 2010 13:25:02 -0700, geno <geno(a)discussions.microsoft.com>
wrote:

>I have an Excel spreadsheet of my contacts, and when in Outlook, I am trying
>to import them into contacts there. I get the following:
>file has no named ranges. in Excel, name the range of date you want to import.
>I am using Office 2007 and would appreciate any help here. Thanks

 | 
Pages: 1
Prev: Number of pages in worksheet doesn't match Print Preview pages
Next: Filter by Color