View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Empty merge fields come over as 12:00:00

Use an If...then...Else... construction

{ IF { MERGEFIELD Birthdate } = "12:00:00" "" { MERGEFIELD Birthdate } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle off their display

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Pepper" wrote in message
...
When merging from Excel into Word 2002 the fields that are empty (a date
field) comes over with 12:00:00 instead of blank. I am putting together a
roster that shows birthdates. When the birthdate is unknown the field in
Excel is empty. When it merges into word the field indicates the time
instead
of being blank. How can I insert this field without the time.