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.

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

Southern at Heart wrote:

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.

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



On Mon, 24 Nov 2008 11:20:06 -0800, Southern at Heart
wrote:

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.

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,


"Gord Dibben" wrote:

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



On Mon, 24 Nov 2008 11:20:06 -0800, Southern at Heart
wrote:

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.

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

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


"Southern at Heart" wrote:

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,


"Gord Dibben" wrote:

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



On Mon, 24 Nov 2008 11:20:06 -0800, Southern at Heart
wrote:

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.

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.

"Southern at Heart" wrote:

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

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


"Southern at Heart" wrote:

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,


"Gord Dibben" wrote:

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



On Mon, 24 Nov 2008 11:20:06 -0800, Southern at Heart
wrote:

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.

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

On Mon, 24 Nov 2008 12:43:04 -0800, Southern at Heart
wrote:

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.

"Southern at Heart" wrote:

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

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


"Southern at Heart" wrote:

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,


"Gord Dibben" wrote:

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



On Mon, 24 Nov 2008 11:20:06 -0800, Southern at Heart
wrote:

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.

thanks anyway...


"Gord Dibben" wrote:

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

On Mon, 24 Nov 2008 12:43:04 -0800, Southern at Heart
wrote:

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.

"Southern at Heart" wrote:

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

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


"Southern at Heart" wrote:

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,


"Gord Dibben" wrote:

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



On Mon, 24 Nov 2008 11:20:06 -0800, Southern at Heart
wrote:

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.