Using Excel With MailMerge?

[gorkyness]

I'm using an Excel worksheet for my mailmerge source because I need som
calculations done that can't be done in Word. I have copied th
formulas 50 rows down. When I try to merge, it gives me 50 pages whe
I only have data in 20. The other 30 rows consist of formulas whic
don't do anything since there is no data on those rows. Even though th
cell values are blank, it reads the cell formulas as being anothe
row.

So what I'm trying to do now is this: create a named ranged tha
adjusts its size (A1:K"some number") according to how many rows hav
data in them. Using COUNTA on a data column gives me that "som
number", but is it possible to create a conditional range like this

 

[Frank Kabel]

Hi
something like
=OFFSET($A$1,0,0,COUNTA(...))