G Guest Dec 16, 2005 #1 I am trying to import into Outlook some names and addresses from Excel.. Why does Outlook need a named range in that spread sheet?
I am trying to import into Outlook some names and addresses from Excel.. Why does Outlook need a named range in that spread sheet?
G Gord Dibben Dec 16, 2005 #2 Because you could have multiple sheets in a workbook, Outlook needs to know where to find the data. To name a range, select the range and Insert>Name>Define. Alternative.......copy the worksheet with the names and addresses to a new workbook and save as *.txt or *.csv file. Use that file as the source file for importing to Outlook Gord Dibben Excel MVP
Because you could have multiple sheets in a workbook, Outlook needs to know where to find the data. To name a range, select the range and Insert>Name>Define. Alternative.......copy the worksheet with the names and addresses to a new workbook and save as *.txt or *.csv file. Use that file as the source file for importing to Outlook Gord Dibben Excel MVP
