[Squeekykilt]

Hi,

I currently have a mail merge set up to read data from an excel file and
populate mergefields in my word file. Several of the fields in the
spreadsheet use an IF statement in a formula to test if the row is in use and
either calculates a value or leave the cell blank if the row is not populated
with any other data.

When run the merge brings across the actual data from the spreadsheet but
also brings across what appear to be blank fields or values calculated as
zero from the sheet.

I assumed if the merge round no data in the next row it would stop the merge
but this is not happening.

Examples of my IF statements are;
- =IF(A4="","",(TEXT(TODAY()+2,"dddd dd mmmm yyyy")))
- =IF(A4="","",(E4+F4))

Any ideas gratefully received, thanks.