Word 2002 MailMerge & Access 2002

Victor Lazlo · External Since: Feb 17, 2005 Posts: 20

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 · External Since: Aug 10, 2004 Posts: 2188

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

"Victor Lazlo" <VictorLazlo DeleteThis @discussions.microsoft.com> wrote in message
news:D2ACA962-B366-40FB-A946-7ED122B4AEE6@microsoft.com...
> 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.

Frank · External Since: Mar 31, 2006 Posts: 150

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

"Peter Jamieson" wrote:

> 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
>
> "Victor Lazlo" <VictorLazlo.TakeThisOut@discussions.microsoft.com> wrote in message
> news:D2ACA962-B366-40FB-A946-7ED122B4AEE6@microsoft.com...
> > 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.
>
>
>