Empty merge fields come over as 12:00:00

[Pepper]

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.

 

[Doug Robbins - Word MVP]

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