I ran the macro and while the thousands of rows are still there, when I run
the merge it no longer spends (what seems like) hours looking for data that
doesn't exist in the thousands of rows.

Thank you! You have made my work a lot easier.


"oli merge" wrote:

Do you mean you have lots of blank rows on your recipient list in Word?

I get that problem somtimes, its because Excel gets confused about where the
true end of the data is if you once had something in a cell and then deleted
it.

A solution can be found he
http://articles.techrepublic.com.com...1-6135485.html

but personally, I just put in only the correct amount of paper/ labels and
then just cancel the print job once it starts merging the blank rows. (lazy i
know).

Also, you could cut and paste the just the data you need onto a brand new
sheet which hasnt got problem.

hope that helps.

"Northern Lights" wrote:

Hi
I have an excel 2002 spreadsheet set up by someone else which contains
thousands (likely the max) of rows. I am trying to merge into word using
this sheet and it takes forever and causes problems editing the merge. How
can I remove the extra rows? I have seen suggestions to select, delete rows
and save the document but the rows are not removed. It is extremely
irritating!!!!

Thanks.