Null Fields / Mailmerge to Word

J

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?
 
P

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.
 
M

Mark Graesser

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
[email protected]

----- 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
 
Top