Null Fields / Mailmerge to Word

[Jannoth]

Have set up a mailmerge whereby Word accesses data in
Excel worksheet.

I don't need every record so want only those with a date
in a particular column.

But Word reads them all as Excel has placed a value in the
null cells (12:00:00 AM).

How can I stop that happening please?

 

[PegL]

I assume you have a formula in the Date column in Excel.
You could add an If to the formula so the cell will be ""
if there's no date to use in it's calculation.

 

[Guest]

Jannoth
Mail merge will not ignore lines starting with a blank cell. Did you set up a Query Option in step 3 of the Mail Merge Helper in Word. This is the best way to set up a selective merge

Good Luck
Mark Graesse
(e-mail address removed)

----- Jannoth wrote: ----

Have set up a mailmerge whereby Word accesses data in
Excel worksheet

I don't need every record so want only those with a date
in a particular column

But Word reads them all as Excel has placed a value in the
null cells (12:00:00 AM)

How can I stop that happening please