Null Fields / Mailmerge to Word

  • Thread starter Thread starter Jannoth
  • Start date Start date
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?
 
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.
 
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
 
Back
Top