Thanks Brian

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?

Thanks
--
Best wishes
David


"Brian Tillman" wrote:

David Burrows wrote:

sorry Diane - I mean "no", or "I don't know"

are you refering to a range in excel?

no range is specified anywhere on the excel sheet, as far as I can
see - (I went looking for that when it went wrong)

You can't import from an Excel spreadsheet without using a named range that
covers the items you're importing.
--
Brian Tillman [MVP-Outlook]