Defining Names for Outlook's import feature

[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.

 

[Bob I]

Save the file as a CSV then import that in Outlook.

 

[Gord Dibben]

Create a Dynamic Named Range to expand as you add more data.

http://www.contextures.on.ca/xlNames01.html#Dynamic

Or just save the workbook as a *.csv file and point Outlook to that.


Gord Dibben MS Excel MVP

 

[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,

 

[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!)

 

[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.

 

[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

 

[Southern at Heart]

thanks anyway...

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