Thread: Stop merging cells when formula in table = null or 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Peter is offline
external usenet poster
  
Posts: 111
Default Stop merging cells when formula in table = null or 0
Formula used in a table (Excel 03) COL N =sumif(A:A,a2,L:L) - this is
autofilled to cell 250 - but 250 cells may not be used. (Macro used to
populate these cells)

So, if only d2:d10 0 then only want these cells to merge onto the word doc.
But mail merege recognises that there is a formula and lists 250 records.

Is there a way around this?


Reply With QuoteReply With Quote