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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing named range from another workbook 5
importing contacts from excel to Outlook error 2
range of data 3
name the range of data 3
How do you name "range" of data to import/export? 2
Import Excel File to Contacts in Outlook 6
Import Multiple CSV Files from Same Folder into Open Workbook 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top