Defining Names for Outlook's import feature

S

Southern at Heart

I have an Excel file that is a table of names, addresses, phone numbers, etc.
It is continually being updated, so the number of records changes.
Occassionally I will import this using Outlooks omport wizard in a contact
folder, but when I do so it requires a 'Named Field', so I have to go back
and select all the data in the excel file again and give it a new name. Is
there a simpler way of having excel automatically give all the data on a
sheet a name that will remain 'all the data' regardless of how many lines are
added or deleted?
thanks.
 
S

Southern at Heart

Thanks! I like this idea of a dynamic name. But I can't get the syntax.
I've tried:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$1:$1),1)


My list of names is on sheet1, and that's all that's on that sheet. It
starts in the top left corner, A1. It's 6 columns wide, but the column count
can be dynamic too? If I understand it right.
Can someone adjust this or tell me the correct formula to set when I define
my name.
thanks,
 
S

Southern at Heart

I GOT IT!
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))

(I have no idea what offset means, or maybe I'd have figured this out
quicker!)
 
S

Southern at Heart

Hmmm, Outlook doesn't recognize this coded 'named range'. It give me the
same old messege that this book doesn't contain any ranges... Guess I'll
have to just save it as a cvs file after all. How boring.
 
G

Gord Dibben

By golly.......you're right.

This type of named range is not recognized by Outlook.

Sorry for chasing you around like that.

Mayhaps someone else knows a workaround to get Outlook to recognize the
dynamic range?


Gord
 
S

Southern at Heart

thanks anyway...


Gord Dibben said:
By golly.......you're right.

This type of named range is not recognized by Outlook.

Sorry for chasing you around like that.

Mayhaps someone else knows a workaround to get Outlook to recognize the
dynamic range?


Gord
Click to expand...
 
Top