View Single Post
  #7  
Old December 17th 07, 07:03 PM posted to microsoft.public.outlook.contacts
Brian Tillman
external usenet poster
 
Posts: 17,452
Default Data limitation when importing contact file from excel

David Burrows wrote:

If I am undrstanding correctly, a named range is created in the excel
sheet when I export from Outlook.
By default, the range is called "contacts", which is the name of the
single sheet is creates.
Again by default, if there are 60 contacts in Outlook, then there are
60 lines on the excel sheet.
I can confirm that the excel properties dialogue confirms that both
the sheet and named range are called "contacts"

So how do I alter the named range in excel, after I have added
additional data, so that Outlook will accept back a bigger list than
it exported?


Reselect the new range and give it a name.
--
Brian Tillman [MVP-Outlook]
Ads