Results 1 to 1 of 1
2015-02-07, 08:14 #1
- Join Date
- Feb 2001
- Thanked 1 Time in 1 Post
Outlook 2007 doesn't recognise named range
Trying to import addresses from Excel spreadsheet into several different distribution lists.
One header row.
Addresses in different chunks below header row.
Defining names with header row and chunk of addresses below.
Now outlook not recognising any named range except contiguous range at top of list.
Wondered if it was something to do with back conversion by Excel 2007, so went back to old PC with Excel 2000 to define named ranges afresh, but still not recognised.
Can find no documentation that says that named ranges need to be contiguous.