Mail Merge from Excel to Word

[funkylad20]

Having asked a lot of question of late, I have another...

Following on from this:
http://www.theanswerbank.co.uk/Technology/Comp uters/Question608945.html#top

I want to mail merge from excel into word. I have a super great spreadsheet on the go.

When the word doc is set with the merge fields, on pressing 'Merge to new document' it goes mad and make thousands of pages of blank data, even though on the spreadsheet there is no visible data!

Now I understand it is down to me having formulas in the cells (even though this generate no actual figure in the cell as there is no inputted record in the row), thus making the cells 'nonblank cells'.

Problem is this work is not for me and I want to hand the system to people to input records continually over the fortcoming year. Is the only answer REALLY to select 'merge record 1 to 100' when selecting 'merge to a new document' in word if say there are only 100 records at that merging stage?