Defined ranges

[ymcata]

Hi.

I'm new in Excel. I have a database with defined name Contracts (=sheet!($A$4:$AN$283)).

From this range I'm merging fields to Word.

With learning Excel, I managed to change defined range to OFFSET (=OFFSET(sheet!$A$4;0;0;COUNTA(sheet!$A:$A);40)), because I need it to work dinamicaly.

But it doesn't work anymore, because Word cannot find object Contracts.

Why cannot Word find my object, if it's in offset?
Why isn't my offset displayed in my Name Box?

Thanks in advance

[Andy Pope]

It's does not appear in NameBox because it is dynamic.
Probably the same reason in Word.

For the mailmerge part you may need to revert to a static reference

[ymcata]

You're telling me that is not possible to merge word-excel with dynamic range?
I found this very strange.
And no solution to this?

Thank you anyway!

[Andy Pope]

A possible solution but it depends on your data setup.
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm