Outlook wants an Excel named range to import contact data why?

G

GDB026

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

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
 
Top