Word 2002 MailMerge & Access 2002

[Victor Lazlo]

My null value merge field displays 12:00:00 AM in a word merge document.
Where is there an option to "Suppress Null Value" when the Access Query
merged field is null.

 

[Peter Jamieson]

There isn't an option to do that in Word.

You can try using the following nested field:
{ IF "{ MERGEFIELD mydate }" = "12:00:00 AM" "" "{ MERGEFIELD mydate }" }

All the {} have to be the special field braces you can insert using ctrl-F9.

If that doesn't work, you can try switching the way Word connects to
theAccess data to DDE by checking Word Tools|Options|General|"Confirm
conversion at open", going through the connection process again, and
selecting the DDE option when offered.

Peter Jamieson

 

[Frank]

On and off have been seeking an answer to this very same problem for a couple
of years. Obviously been looking in the wrong place!!

Mail merge now works brilliantly - thanks for raising the issue and for the
(so simple) solution.