View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Simon Simon is offline
external usenet poster
 
Posts: 6
Default print next record on same page untill, cell=FALSE then start new page.

I need to print next record on same page untill, cell=FALSE then start new
page.

If the value is TRUE then next row (record) should be added to the same
document.

When the value is FALSE a the record should start on a new document.

I have tried used "Next Record IF" which works where there are multiple
records for the same account, however where there is only one record, it
doesnt print the next record - but the same record again?

Can I work round this?

For example

Bob Smith 12345 TRUE
Bob Jones 12456 TRUE
Sam Smith 13343 FALSE
Joe Peters 3141 FALSE
Mike Smith 213 FALSE
Harry Rivers 31414 TRUE
Bob Rivers 34234 FALSE


This would give 4 pages as follows (note there could be 60+ enteries per
page)

Page 1.

Bob Smith
Bob Jones
Sam Smith

Page 2
Joe Peters

Page 3
Mike Smith

Page 4
Harry Rivers
Bob Rivers