View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laura
 
Posts: n/a
Default Hiding Rows Leaves Labels Blank

I have an Excel address list of 400 contacts. I'm using mail merge to get
these into Word for label printing. When I edit the Excel chart by hiding
rows 20 to 45, Word will leave those labels blank. In otherwords, I'm seeing
populated labels 1 thru 19....then a bunch of blank labels....then populated
labels 46 to 400.

I made sure the setting "if a blank row exists do not print a blank label"
(or something to that effect) is checkmarked.

Any ideas???? Thanks.